/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

4 votes134 views2 answers
Install zsh debian
Shell/Bash
0 vote179 views1 answer
How to check open vpn on ubuntu
Shell/Bash
175 votes316 views6 answers
Install nodemon dev
Shell/Bash
24 votes141 views2 answers
Bash check file exists
Shell/Bash
0 vote144 views3 answers
Wget with username and password
Shell/Bash
0 vote142 views1 answer
Linux run command on ssh connected
Shell/Bash
1 vote154 views2 answers
Install glibc
Shell/Bash
0 vote126 views1 answer
Ubuntu list all disks
Shell/Bash
20 votes138 views2 answers
Sh read file line by line
Shell/Bash
1 vote140 views1 answer
How to enable gitlab runner to use local docker images
Shell/Bash

Share