/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

2 votes129 views1 answer
How to get the temp of cpu in linux terminal raspberry pi
Shell/Bash
0 vote133 views1 answer
Redis::CommandError: MISCONF Redis is configured to save RDB snapshot
Shell/Bash
7 votes114 views2 answers
Linux query port use by pid
Shell/Bash
1 vote126 views6 answers
Online linux terminal for c programming
Shell/Bash
86 votes106 views6 answers
Git view remote url
Shell/Bash
10 votes155 views3 answers
Conda install from yaml
Shell/Bash
2 votes132 views2 answers
Wget install windows cmd
Shell/Bash
0 vote115 views1 answer
Vim error in ubuntu
Shell/Bash
0 vote123 views1 answer
Append to a file from terminal
Shell/Bash
29 votes104 views2 answers
Git merge cancel
Shell/Bash

Share