Docker samples for PostgreSQL.

A Docker-Compose file with PostgreSQL ready to use. - gaelgthomas/docker-compose-with-postgresql

Docker Compose v2.23.1+ supports inline config files using the top-level configs section with a content field. This lets you define small configuration files directly inside compose.yaml instead of maintaining separate files on disk. Compose mounts the content as a read-only file inside the container at the path specified by target. configs: postgres_init: content: | CREATE DATABASE demo2; \c demo2 CREATE EXTENSION vector; pgadmin_servers: content: | { "Servers": { "1": { "Name": "Docker Compose", "Group": "Servers", "Port": 5432, "Username": "postgres", "Host": "postgres", "SSLMode": "prefer", "MaintenanceDB": "postgres", "PassFile": "/tmp/pgpassfile" } } }

February 16, 2026 - If you want to skip the details ...se-examples/postgresql-complete directory and run the following command : docker compose -f dc-postgresql-complete.yml up -d....

Is there way to update my sql script and then update existing image, without data loss? for example I need to add trigger for existing postgres image... Hi, initdb.sh scripts are called only if there is no database set, so if you need to migrate current database it's better to run this sql migrations from psql cli for already created databases, and initdb.sh/ scripts will be run for new clean instances. ... FYI: do not pass the host (localhost) in the initialization script or you'll likely to encounter an error about not being able to connect to database. ... in docker-compose.yml patch /file.sql:/patch/to/docker-entrypoint-initdb.d/ in fact, point the file to the directory hint: remember where the work dir is base on your docker file for the image you are using to compose this container volumes:

June 12, 2024 - To create a PostgreSQL database in Docker, use the “CREATE DATABASE <database-name>;” command. Then, create a new table in it and insert values in the ta…

March 3, 2024 - services: local-postgres-service: ... local-postgres-network: ... Start the container in detach mode using: docker compose -f postgres-local.yml up -d Stop the container using: docker compose -f postgres-local.yml ...

4 weeks ago - Now let’s write our Docker Compose file, docker-compose.yml, and save it in src/main/docker: version: '2' services: app: image: 'docker-spring-boot-postgres:latest' build: context: .

August 22, 2024 - We'll show you how to define a docker-compose.yml file to set up the PostgreSQL service, automatically create a database, and insert predefined data upon initialization.

# Use postgres/example user/password credentials services: db: image: postgres restart: always # set shared memory limit when using docker compose shm_size: 128mb # or set shared memory limit when deploy via swarm stack #volumes: # - type: tmpfs # target: /dev/shm # tmpfs: # size: 134217728 # 128*2^20 bytes = 128Mb environment: POSTGRES_PASSWORD: example adminer: image: adminer restart: always ports: - 8080:8080 Copy

January 2, 2022 - This article shares some tips and code examples for setting up your PostgreSQL database with Docker Compose and Flyway.

February 20, 2020 - We need a way to mount some volumes, add some configuration, and import/seed our database. Docker Compose to the rescue! Let’s setup a simple project structure: mkdir -p docker-postgres/data && cd docker-postgres && touch docker-compose.yml.

April 21, 2025 - services: database_postgres: image: postgres:latest ports: - 5432:5432 environment: POSTGRES_PASSWORD: password POSTGRES_USER: username POSTGRES_DB: database_name volumes: - ${HOME}/postgres-data/:/var/lib/postgresql/data pgweb: container_name: pgweb restart: always image: sosedoff/pgweb ports: - 8081:8081 links: - database_postgres:database_postgres environment: - PGWEB_DATABASE_URL=postgres://username:password@database_postgres:5432/database_name?sslmode=disable depends_on: - database_postgres · Nothing new under the sun here. Just some variables to initialize the database with a user. But the trick is in the volumes: Here we make sure the data is saved in a directory inside your HOME, so all database data will persist there. 👉 This way, if you run docker-compose down (or docker compose down, depending on your version), you won’t lose your data.

October 17, 2023 - version: '3.8' services: postgres_db: image: postgres:13.5 container_name: PostgresCount restart: always environment: - POSTGRES_USER=hoadev - POSTGRES_PASSWORD=hoadev123 - POSTGRES_DB=hoadev_db volumes: - postgres_db:/var/lib/postgresql/data ports: - '5432:5432' volumes: postgres_db: driver: local · version : specifies the version of the Docker Compose file.

October 14, 2023 - Create Spring Boot App working with Postgres database. Create Dockerfile for Spring Boot App. Write Docker Compose configurations in YAML file.

You will notice that the volume has a rather unfriendly name and is mounted at /var/lib/postgresql/data. Let’s remove this container and the associated volume for now: $ docker rm -f mydb $ docker volume rm 8328940661c0703ed867b004ea6343b9432e70069280b71cfce592ecdd12e55d · The same is true when you create a container using a simple docker-compose file.

December 28, 2022 - You can use the POSTGRES_PASSWORD environment variable that you set in the Docker Compose file. Click the Save button to create the server. That’s it! Your database should now be up and running, and you should be able to connect to it using pgAdmin or any other PostgreSQL client. To verify that the database is working correctly, you can try running a few simple queries. For example, you can create a table and insert some data into it, and then run a SELECT query to retrieve the data: