karnveer4/pgsql_db repository overview

pgsql_db:v1.0 is built on top of ubuntu 22.04

⁠The below command should be used to pull the image below

docker pull karnveer4/pgsql_db:v1.0

⁠run container with downloaded image

docker run -it --rm -e POSTGRES_PASSWORD=karnveer4 -v pgdata-ssl:/opt/pgsql/data -p 5432:5432 karnveer4/pgsql_db:v1.0

⁠Below environment variable can also be passed if required

-e POSTGRES_PASSWORD=karnveer4 \
-e POSTGRES_DB=nodejsdb \
-e POSTGRES_USER_EXTRA=karnveer4 \
-e POSTGRES_PASSWORD_EXTRA=karnveer4pwd \

⁠Once container spawned, use below command to run the DB service

/usr/local/bin/docker-entrypoint.sh &

use netstat -tlpen to check ports are up and in listen mode

⁠To Verify that DB is up and reachable below command can be used by first spawning a container

docker run -it --rm -e POSTGRES_PASSWORD=karnveer4 -v pgdata-ssl:/opt/pgsql/data --network=host karnveer4/pgsql_db:v1.0

⁠and then send sql client req

/opt/pgsql/bin/psql "host=X:X:X:X port=5432 dbname=postgres user=postgres password=karnveer4 sslmode=require"

⁠Below Output confirms that connection got established

SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off) Type "help" for help.

postgres=#

⁠below debian package is required for pgsql related binary to get up

libssl1.1_1.1.1w-0+deb11u4_amd64.deb

this file can be downloaded from debian repository and place it in side /opt