docker postgres sample database

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 › 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%

Discussions

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

r/docker

3

1

July 1, 2024

Are there sample database containers?

You don't need a pre-built image. Just find an SQL file that will build the schema and run it. More on reddit.com

r/docker

4

2

September 15, 2023

How 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

r/docker

16

6

April 30, 2023

Connection 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

r/PostgreSQL

15

1

October 31, 2020

Videos

12:23

YouTube

Run Postgres in a Docker Container (Easiest PostgreSQL Setup) - ...

How to Create a Docker Postgres Image with Preloaded Data #docker ...

Getting Started With PostgreSQL in Docker: From Setup to Sample ...

December 28, 2023

10:01

YouTube

How to Set Up a PostgreSQL Database with Docker - YouTube

Docker Volumes with PostgreSQL Example - YouTube

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%

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%

Find elsewhere

Google Bing Mojeek

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.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?

Top answer

1 of 1

1

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.

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.

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.

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%

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/

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):

reddit.com › r/docker › are there sample database containers?

r/docker on Reddit: Are there sample database containers?

September 15, 2023 -

I'm working on an app that connects to several different kinds of databases. Currently, mostly Postgres, MySQL and maybe MSSQL.

What I need is a Docker container that has each of these databases but also includes sample data. I don't care what the data is. Just something with a database (or more) with multiple tables and records. Views, triggers, etc. would be cool too.

I can create my own but essentially what I'm looking for is the "lorem ipsum" for a database server.

Do such containers exist?

Thanks!