| FROM ubuntu:20.04 | |
| # Install dependencies | |
| RUN apt-get update && apt-get install -y \ | |
| build-essential \ | |
| libreadline-dev \ | |
| zlib1g-dev \ | |
| libssl-dev \ | |
| libpq-dev \ | |
| git \ | |
| wget \ | |
| ca-certificates | |
| # Download and extract PostgreSQL source code | |
| RUN wget https://ftp.postgresql.org/pub/source/v14.1/postgresql-14.1.tar.gz | |
| RUN tar -xzf postgresql-14.1.tar.gz | |
| # Configure and build PostgreSQL | |
| WORKDIR /postgresql-14.1 | |
| RUN ./configure | |
| RUN make | |
| RUN make install | |
| # Set environment variables | |
| ENV POSTGRES_DB=mydb | |
| ENV POSTGRES_USER=myuser | |
| ENV POSTGRES_PASSWORD=mypassword | |
| # Expose the PostgreSQL port | |
| EXPOSE 5432 | |
| # Start the PostgreSQL server | |
| CMD ["postgres", "-D", "/usr/local/pgsql/data"] | |