Top "Pg-dump" questions

pg_dump is a utility for backing up a PostgreSQL database.

Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How …

postgresql backup pg-dump postgresql-9.2
How to create a backup of a single table in a postgres database?

Is there a way to create a backup of a single table within a database using postgres? And how? Does …

postgresql backup pg-dump
How do I do a schema only backup and restore in PostgreSQL?

How do I take a schema level backup in PostgreSQL database and restore on the another database? Is there any …

postgresql pg-dump
pg_dump postgres database from remote server when port 5432 is blocked

I'm trying to pg_dump a SQL database on a remote server in our DMZ. There are 2 problems. 1) there is …

postgresql ssh remote-server pg-dump
How can I get pg_dump to authenticate properly

I have tried using host variable PGPASSWORD and .pgpass and neither of these two will allow me to authenticate to …

postgresql pg-dump
postgresql where does the output of pg_dump go

I am trying to backup a db of postgresql and I want to use pg_dump command. I tried : psql …

database postgresql command-line backup pg-dump
I want to restore the database with a different schema

I have taken a dump of a database named temp1, by using the follwing command $ pg_dump -i -h localhost …

postgresql pg-dump pg-restore
How to fix pg_dump version mismatch errors?

When trying to get local data to Heroku, I am encountering a version mismatch between two different versions of pg_…

postgresql osx-mountain-lion uninstallation pg-dump
Easy way to view postgresql dump files?

I have a ton of postgresql dump files I need to peruse through for data. Do I have to install …

database postgresql-9.1 pg-dump
pg_restore: [archiver] unsupported version (1.14) in file header

I have a live server and development box, call them live and dev respectively both running postgresql. I can see …

postgresql ubuntu pg-dump pg-restore