Docker
docs.docker.com › guides › pre-seeding database with schema and data at startup for development environment
Pre-seeding database with schema and data at startup for development environment | Docker Docs
3 weeks ago - Using Docker Compose makes it even easier to manage and deploy the PostgreSQL container with the seeded database. This compose.yml file defines a Postgres service named db using the latest Postgres image, which sets up a database with the name sampledb, along with a user postgres and a password mysecretpassword...
GitHub
github.com › ghusta › docker-postgres-world-db
GitHub - ghusta/docker-postgres-world-db: Example Database for PostgreSQL : World DB · GitHub
Example Database for PostgreSQL : World DB. Contribute to ghusta/docker-postgres-world-db development by creating an account on GitHub.
Starred by 46 users
Forked by 36 users
Languages PLpgSQL 77.4% | Dockerfile 11.7% | Shell 10.9%
Initialize Postgres container with “template” database
This should be fairly simple. If you have no persistent data mounted to the host, the container will reset whenever you up/down it, starting fresh. Usually you would use something like this with a defined named volume: volumes: - postgres:/var/lib/postgresql/data If you skip that, then there is no persistent data mounted and all data is lost when the container is recreated. The official postgres image supports init scripts to be provided, you would do this like that for example with a bind mount: volumes: - /some/path/on/your/host:/docker-entrypoint-initdb.d:z Refer to the postgres image documentation for more details. If you combine those two things, the lack of actual persistent data plus a init sql script, you would have a fresh "template" database each time. More on reddit.com
3
1
July 1, 2024How to connect Python to Docker Pg Database?
You run both containers in the same docker network and use their service names for the connection string. More on reddit.com
16
6
April 30, 2023Connection error dbeaver docker postgres
Are you using the docker postgres image? Do you have any other Postgres installs on your local computer? More on reddit.com
15
1
October 31, 2020Connecting to a localhost postgres database from within a docker container
Should this 127.0.0.1:5432 be 0.0.0.0:5432?
More on reddit.com 4
2
June 29, 202112:23
Run Postgres in a Docker Container (Easiest PostgreSQL Setup) - ...
03:53
How to Create a Docker Postgres Image with Preloaded Data #docker ...
10:45
Getting Started With PostgreSQL in Docker: From Setup to Sample ...
10:01
How to Set Up a PostgreSQL Database with Docker - YouTube
13:38
Docker Volumes with PostgreSQL Example - YouTube
GitHub
github.com › zseta › postgres-docker-samples
GitHub - zseta/postgres-docker-samples: PostgreSQL database samples with Docker · GitHub
host=localhost port=5432 database=example user=postgres password=password string=postgresql://postgres:password@localhost:5432/example · To stop the container you can press CTRL+C. You are welcome to add new sample data folders to the project.
Starred by 6 users
Forked by 2 users
Languages Shell 63.6% | Dockerfile 36.4%
Docker Docs
docs.docker.com › reference › samples › postgresql samples
PostgreSQL samples | Docker Docs
December 2, 2024 - These samples offer a starting point for how to integrate different services using a Compose file.
Software and Booz
softwareandbooz.com › introducing-bluebox-docker-a-living-postgresql-sample-database
Introducing Bluebox Docker: A Living PostgreSQL Sample Database – Software and Booz
February 16, 2026 - This is why I created Bluebox, and now I’m excited to share the next evolution: Bluebox Docker — a ready-to-run PostgreSQL container that gives you a realistic, continuously-updating sample database with zero setup required.
Docker Hub
hub.docker.com › r › aa8y › postgres-dataset
aa8y/postgres-dataset - Docker Image
Postgres Sample Databases: The datasets being used from here are dellstore2 (tagged dellstore), iso3166, pagila, sportsdb, usda and world. pagila is not being used from the pgFoundry source because it doesn't directly work with the newer version of PostgreSQL we're using.
Attilatoth
attilatoth.dev › posts › postgres-docker-samples
Spin up PostgreSQL instances in seconds with preloaded data · Attila Toth
October 27, 2023 - It’s a lot of time for setting up sample databases that you only need temporarily. So anyway, I wanted to streamline this process as much as possible so I don’t waste time spinning up databases, finding datasets and ingesting data. I came up with this GitHub repo: PostgreSQL database samples with Docker
GitHub
github.com › aa8y › docker-dataset
GitHub - aa8y/docker-dataset: Docker database images with pre-populated data for testing and/or practice.
Under such circumstances, you have to either have to create dummy data or utilize some internet-searching skills to find data to populate your database. I think this is a common enough problem/requirement that solution can be Dockerized for reuse. So here is a Docker image for PostgreSQL with databases populated with sample data.
Starred by 37 users
Forked by 5 users
Languages Dockerfile 100.0% | Dockerfile 100.0%
Docker
hub.docker.com › _ › postgres
postgres - Official Image | Docker Hub
The only variable required is POSTGRES_PASSWORD, the rest are optional. Warning: the Docker specific variables will only have an effect if you start the container with a data directory that is empty; any pre-existing database will be left untouched on container startup.
Geshan
geshan.com.np › blog › 2021 › 12 › docker-postgres
Postgres with Docker and Docker compose a step-by-step guide for beginners
December 25, 2021 - We are asking docker-compose for the service to be an image of Postgres version 14.1 alpine which will always restart if the container stops automatically. Consequently we define two environment variables to send in the Postgres user and password. Keep in mind, as the database is not sent by default for the official image it will use the username as the database name.
Medium
wkrzywiec.medium.com › database-in-a-docker-container-how-to-start-and-whats-it-about-5e3ceea77e50
Database in a Docker container — how to start and what’s it about | by Wojciech Krzywiec | Medium
September 21, 2021 - First, we need to insert them, so in your favourite database tool run following command: INSERT INTO public.persons (id, firstname, lastname, address) VALUES (1, 'Luke', 'Skywalker', 'Tatooine'), (2, 'Leia', 'Organa', 'Alderaan'), (3, 'Han', 'Solo', 'Corellia'); Then go back to terminal and stop running container with: $ docker stop my-postgres-containermy-postgres-container
Reddit
reddit.com › r/docker › initialize postgres container with “template” database
r/docker on Reddit: Initialize Postgres container with “template” database
July 1, 2024 -
I want to use docker compose to build a postgresql database with a starting “template” of a database. I do not want to use volumes to make it so that operations on a running container permanently change that template. I want to be able to compose down and compose up the image and it resets to that template. As far as I know the Volumes command doesn’t allow this to happen and I’m unsure how else to go about it. I’ve tried using COPY to copy a var/lib/postgresql/data directory into the container in the dockerfile but that doesn’t work either. Anyone know how to do this?
Baeldung
baeldung.com › home › docker › postgresql with docker setup
PostgreSQL with Docker Setup | Baeldung on Ops
July 23, 2025 - In this tutorial, we’ll learn how to install PostgreSQL with Docker. Generally, we run a Docker container using the public Docker image. Similarly, we can pull preconfigured Docker images of the PostgreSQL database server from Docker Hub.
Docker
docker.com › blog › how to use the postgres docker official image | docker
How to Use the Postgres Docker Official Image | Docker
November 6, 2024 - Build a Go server with an NGINX proxy and a Postgres database. Create a sample Postgres and pgAdmin management setup.
GitConnected
levelup.gitconnected.com › creating-and-filling-a-postgres-db-with-docker-compose-e1607f6f882f
Creating and filling a Postgres DB with Docker compose | by José David Arévalo | Level Up Coding
April 14, 2022 - In this case, we mapped our local port 5438 to the port 5432 (Postgres default port) inside the container., also we will persist the data in our machine, preventing data loss when deleting the containers, for this, we add the volume using the folder postgres-data as the place where Postgres data are stored. To create the tables in our database we need to copy our create_tables.sql script to/docker-entrypoint-initdb.d/
GitHub
github.com › sameersbn › docker-postgresql
GitHub - sameersbn/docker-postgresql: Dockerfile to build a PostgreSQL container image which can be linked to other containers. · GitHub
In the above example dbuser with be granted access to both the dbname1 and dbname2 databases. The image also packages the postgres contrib module. A comma separated list of modules can be specified using the DB_EXTENSION parameter. docker run --name postgresql -itd \ --env 'DB_NAME=db1,db2' --env 'DB_EXTENSION=unaccent,pg_trgm' \ sameersbn/postgresql:15-20230628
Starred by 1.1K users
Forked by 470 users
Languages Shell 90.1% | Dockerfile 9.1% | Makefile 0.8%
DEV Community
dev.to › andre347 › how-to-easily-create-a-postgres-database-in-docker-4moj
How to easily create a Postgres database in Docker - DEV Community
January 28, 2021 - You can check if it's working when there is a Docker icon (the whale or ship like image with containers) on the top right next to your other small icons. If this is the case you can quickly follow the 'Hello World' example to get up and running. Hands down the easiest way of running a clean Postgres database is by running this command in a terminal window (after Docker has been installed):
End Point Dev
endpointdev.com › blog › 2022 › 07 › running-postgresql-on-docker
Running PostgreSQL on Docker | End Point Dev
July 27, 2022 - Just as Postgres running natively on an operating system, Postgres on Docker comes with the psql front-end client for accessing the Postgres database. To access psql in the Postgres container execute the following command: ... Now we are able to execute any psql command. Let’s try a few Postgres commands and import the famous “dvdrental” sample database to our Postgres installation.
CommandPrompt Inc.
commandprompt.com › education › how-to-create-a-postgresql-database-in-docker
How to Create a PostgreSQL Database in Docker — CommandPrompt Inc.
June 12, 2024 - Then, create and start the Postgres container via the “docker run --name -d <cont-name> -p 5432:5432 -e POSTGRES_PASSWORD=<password> postgres” command. After that, access the Postgres container and make a connection with the desired database.
Call +1-503-667-4564
Address 2950 Newmarket ST STE 101 - 231, 98226, Bellingham
Medium
medium.com › @asuarezaceves › initializing-a-postgresql-database-with-a-dataset-using-docker-compose-a-step-by-step-guide-3feebd5b1545
Initializing a PostgreSQL Database with a Dataset using Docker Compose: A Step-by-step Guide | by Asuarezaceves | Medium
June 25, 2023 - This approach provides a reproducible and portable way of setting up databases, ideal for development, testing, and continuous integration environments. In your docker-compose.yml file, add this extra bit: version: '3.8' services: postgres: image: postgres:latest env_file: - .env volumes: - ./data:/var/lib/postgresql/data networks: - initexample metabase: image: metabase/metabase:latest depends_on: - postgres ports: - 3000:3000 networks: - initexample networks: initexample: driver: bridge