-
I've recently began going through the internals of Postgres and I have written an extension PG_WAL_EXT that reads a WAL(Write Ahead Log) file and generates back the raw SQL statements for Insert/Update/Delete commands.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
postgres
Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch (by misachi)
# I have an AMD CPU. Use the right image for your case FROM amd64/ubuntu:latest # Prepare the directories and files required ENV APP_HOME=/postgres/ ID=991 USR=postgres USR_HOME=/home/postgres PG_FILES=/usr/local/pgsql/ BASH_PROFILE=/etc/bash.bashrc # Permissions RUN groupadd -g ${ID} ${USR} && \ useradd -r -u ${ID} -g ${USR} ${USR} # If you have Postgres installed in the current directory. This should be enough to copy # the source code to the image...You can also download it from the repo directly # with `RUN git clone https://github.com/misachi/postgres.git` ADD . ${APP_HOME} WORKDIR ${APP_HOME} RUN chown -R ${USR}:${USR} ${APP_HOME} && \ mkdir -p ${USR_HOME} && \ chown -R ${USR}:${USR} ${USR_HOME} # Requirements installations RUN apt-get update && apt-get install -y g++ gdb \ zlib1g-dev \ make curl \ tar gzip \ git nano \ libreadline-dev \ flex bison libicu-dev # Build and Install Postgres # Install a debug build since want to develop with Postgres # If debug build is not required, remove the CFLAGS="-O2 -ggdb3" section # I had issues with installing icu library and making it work with PG, that is why I pass in the --without-icu flag. It can be removed if required RUN CFLAGS="-O2 -ggdb3" ./configure --without-icu --enable-debug && \ make && \ make all && \ make install RUN echo "export PATH=$PATH:/usr/local/pgsql/bin/" >> ${BASH_PROFILE} && \ chown -R ${USR}:${USR} ${PG_FILES} USER ${USR} # Post-Installation RUN ${PG_FILES}/bin/pg_ctl -D /usr/local/pgsql/data initdb CMD [ "pg_ctl", "-D", "/usr/local/pgsql/data", "-l", "logfile start" ]
-
PostgreSQL
Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
Databases are complex systems with many different moving parts that work together to store/retrieve data. There are many database systems each solving unique problems within its space. Postgres is a popular open source relational database. For our case, Postgres is a general purpose database which attempts to solve many different problems for the user.
