/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

1 vote152 views3 answers
Xrandr 1366
Shell/Bash
1 vote136 views1 answer
Install apache on ubuntu 20.04
Shell/Bash
0 vote144 views1 answer
Archlinux free used port
Shell/Bash
23 votes141 views3 answers
How to open xampp control panel in ubuntu
Shell/Bash
0 vote160 views1 answer
Enable the containers feature in Windows Server 2019
Shell/Bash
1 vote131 views4 answers
How to run shell script
Shell/Bash
0 vote164 views1 answer
Transcode input to output with h264 720p with gpu
Shell/Bash
0 vote151 views1 answer
Prisma format schema
Shell/Bash
0 vote130 views1 answer
Please install paramiko on your system. (sudo pip3 install paramiko)
Shell/Bash
0 vote165 views1 answer
Bash array initialization multiple lines
Shell/Bash

Share