Top "Pg-dump" questions

pg_dump is a utility for backing up a PostgreSQL database.

pg_restore toc error

i was using the following syntax for pg_dump and restore pg_dump eval --inserts -b -c --encoding UTF8 -Fc …

postgresql pg-dump pg-restore
Use pg_restore to restore from a newer version of PostgreSQL

I have a (production) DB server running PostgreSQL v9.0 and a development machine running PostgreSQL v8.4. I would like to …

postgresql export restore psql pg-dump
pg_dump: too many command line arguments

what is wrong with this command: pg_dump -U postgres -W admin --disable-triggers -a -t employees -f D:\ddd.txt …

postgresql dump database-backups pg-dump
Populate MySQL database from postgresql dump file

Actually I need to populate MySQL database from a SQL file which was generated by postgresql as pg_dump dbname &…

mysql database postgresql pg-dump
Why is pg_restore returning successfully but not actually restoring my database?

I have a Postgres 8.4 database on a linux server that I have dumped using the following command: pg_dump --format=…

postgresql pg-dump pg-restore
How do I convert a binary pgdump (compressed) to a plain SQL file?

I do want to search for some data inside a database dump but these dumps are using the binary-compressed format (…

postgresql pg-dump pg-restore
2 versions of pg_dump on my OSX Lion

I had Postgres 9.0.x installed with homebrew, but because of lack of some modules I removed it using: brew uninstall …

macos postgresql osx-lion version pg-dump
Is there a way to get pg_dump to exclude a specific sequence?

I want to exclude a sequence from my pg_dump command which is putting the output into a plain file. …

postgresql sequences pg-dump
"permission denied" for pg_dump output file

i used below command to backup my database sudo -u user_name pg_dump dbName -f /home ..../someWhere/db.sql …

database postgresql command-line backup pg-dump
will pg_restore overwrite the existing tables?

Say I have two host servers s1 and s2. In both the servers i have a schema named n1, now …

postgresql psql postgresql-9.5 pg-dump pg-restore