Postgres container

database connection

postgres

host: localhost port: 5432 db: timeseriesdb user: timeseriesuser pass: timeseriespass

start and stop container

start db container, create basic db:

bash db_up.sh

tear down db container:

bash db_down.sh

maintenance commands

check if container running:

docker ps --all

run container (in the background):

docker-compose up --detach

connect to postgres and check the table found in init.sql:

docker exec --interactive --tty my_postgres_container psql --username=myuser --dbname=mydatabase

verify it's working:

select  * from cats

restart container:

docker compose down --volumes
docker compose up --detach