/Shell/Bash/Pg_restore docker

Pg_restore docker

Pg_restore, pg_dump

pg_restore --verbose --clean --no-acl --no-owner --host=localhost --dbname=db_name --username=username latest.dump

1

Source: stackoverflow.com

Pgrestore schema backup to a container

docker exec -i pg_container_name psql --username pg_username [--password pg_password] database_name < /path/on/your/machine/dump.sql

1

Source: davejansen.com

Pg_restore docker

docker-compose exec -T "${DB_CONTAINER}"  pg_restore -C --clean --no-acl --no-owner -U "${DB_USER}" -d "${DB_NAME}" < "${LOCAL_DUMP_PATH}"

0

Source: stackoverflow.com

Similar codes

0 vote321 views1 answer
Check g++ on ubuntu
Shell/Bash
7 votes355 views5 answers
Update branch with master
Shell/Bash
0 vote343 views1 answer
Java compile script
Shell/Bash
1 vote352 views1 answer
Capacitor resources
Shell/Bash
16 votes369 views3 answers
Npm install different version
Shell/Bash
0 vote352 views1 answer
What does le mean in linux
Shell/Bash
0 vote388 views1 answer
Check age of git branch
Shell/Bash
5 votes375 views2 answers
Could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432
Shell/Bash
4 votes331 views2 answers
Linux get signing certificate SHA-1
Shell/Bash
0 vote339 views1 answer
Bash replace specific line in file
Shell/Bash

Share