Sign inSign up

buildsecurity/sample-postgres-db

By buildsecurity

Updated almost 6 years ago

A PostgreSQL DB containing a simple pre-populate users table

Image
0

3.6K

buildsecurity/sample-postgres-db repository overview

PostgreSQL Docker image with a sample DB

This image contains a sample DB, containing a single 'users' table that is being populate upon running the container.

Running the image

When running the image, you should supply DB credentials and the DB name in the environment variables

docker run -d -p 5432:5432 --name sample-pg  -e POSTGRES_USER=postgres  -e POSTGRES_PASSWORD=password -e DB_NAME=sample  buildsecurity/sample-postgres-db

Populated data

The data being populated in the table is of the below structure:

"id""name""email""is_active""last_login""role"
"027c7da1-6bd1-dd4a-322c-78eb3bb8fb9a""Lev Steele""[email protected]"false"2021-08-15 15:33:12+00""admin"
"033cf963-2f15-64d2-007f-13ba400149db""Judah Harrell""[email protected]"true"2021-06-18 09:53:31+00""developer"

Tag summary

Content type

Image

Digest

Size

109.4 MB

Last updated

almost 6 years ago

docker pull buildsecurity/sample-postgres-db