Top "Pg-restore" questions

pg_dump & pg_restore password using python module subprocess

Problem: Use the PSQL pg_dump and pg_restore in a Python script and using the subprocess module. Background: I …

python subprocess psql pg-dump pg-restore

pg_restore duplicate key and invalid command errors

Postgres version : PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit We transfer from one server to …

postgresql postgresql-9.2 database-backups pg-restore

How to restore pg_dump file into postgres database

So I regularly backup and restore databases and schema's using pgadmin4. I would like to do it with a batch …

postgresql pg-dump pg-restore

pg_restore works with zip file?

Just trying to restore tutorial database from resource: http://www.postgresqltutorial.com/load-postgresql-sample-database/ so, after this code pg_restore -U …

database postgresql pg-restore

pg_restore: [archiver] unsupported version (1.13) in file header

C:\Program Files (x86)\pgAdmin III\1.22\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "randd" --role "postgres" --no-password --verbose "…

postgresql pg-restore postgres-9.4

Unable to restore psql database from pg_dump with a different username

I need to dump a postgres database from computer1 with postgres username1 and then restore it on computer2 with postgres …

postgresql psql pg-dump pg-restore