pgsql

PGSQL Docker Guide

Some basic commands to use pgsql docker container

🐳 Docker-Hub

⏩ Running a sample

docker-compose up

To stop and remove all containers of the sample application run:

docker-compose down

To stop and remove all containers with Volume of the sample application run:

docker-compose down -v

✨ PGSQL Config

• database (Created Default)- postgres
• username - postgres
• password - Passw0rd.
• port - 5432

• database (Created using Docker compose) - rajawat
• username - postgres
• password - Passw0rd.
• port - 5432

🎓 PGSQL Commands

1. Run the following command to open the pgsql client terminal

docker exec -it pg_container psql -h localhost -U postgres

2. To See list of database:

\l

3. Create database command

create database lks;

4. Change database context command

\c lks

4. List all tables in database

\dt

5. Drop database command

drop database lks;

6. To quit the database;

quit

7. To Take the database backup;

pg_dump -U postgres "DbName" > dbbackup
or
pg_dump -U postgres "DbName" > dbbackup.sql

8. To restore the database backup;

psql -U postgres "DbName" < dbbackup
or
psql -U postgres "DbName" < dbbackup.sql

Author

👤 RajawatBanna