Re: pg_dump/pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexey Bobkov <bax(at)sunet(dot)ru>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump/pg_restore
Date: 2004-01-12 14:46:58
Message-ID: 28375.1073918818@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Alexey Bobkov <bax(at)sunet(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alexey Bobkov 2004-01-12 15:01:49 Re: pg_dump/pg_restore
Previous Message Jan Wieck 2004-01-12 14:38:11 Re: [HACKERS] IEEE 754