/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

10 votes283 views2 answers
Uninstall in linux
Shell/Bash
1 vote330 views1 answer
Default raspberry pi login ubuntu
Shell/Bash
9 votes294 views1 answer
How to check ram from cli
Shell/Bash
4 votes300 views2 answers
Change master to main git
Shell/Bash
0 vote280 views1 answer
Display your current shell name
Shell/Bash
1 vote278 views1 answer
Cut command in unix
Shell/Bash
0 vote301 views1 answer
Show 10 Largest Open Files
Shell/Bash
18 votes306 views2 answers
Mac terminal find process by port
Shell/Bash
0 vote290 views1 answer
Read file and while loop example
Shell/Bash
4 votes276 views3 answers
Kill screen sessions
Shell/Bash

Share