Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump/pg_restore - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump/pg_restore
Date
Msg-id 28375.1073918818@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump/pg_restore  (Alexey Bobkov <bax@sunet.ru>)
Responses Re: pg_dump/pg_restore
List pgsql-admin
Tree view 
Alexey Bobkov <bax@sunet.ru> writes:
> I have been dumping my database with next options:
> pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name
> and get db_backup.file file.

This is giving you a plain SQL-script dump file.  To restore, feed it
into psql.

            regards, tom lane

pgsql-admin by date:

Previous
From: Alexey Bobkov
Date:
Subject: pg_dump/pg_restore
Next
From: Alexey Bobkov
Date:
Subject: Re: pg_dump/pg_restore