Re: File System Restore

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Tim Penhey" <tim(at)penhey(dot)net>
Cc: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: File System Restore
Date: 2004-06-20 13:21:18
Message-ID: 87isdmicvl.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tim Penhey" <tim(at)penhey(dot)net> writes:

> This has been a bit of a point of confusion for me.
>
> When do you use pg_restore vs. psql -f dumped.sql?

If you used the 'custom' or 'tar' formats of pg_dump, you need to use
pg_restore. If you dumped as straight SQL (the default), just feed
the dump to psql.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-06-20 13:28:46 Re: Relocation error pg_dumpall undefined symbol get_progname in 7.4.3
Previous Message Tom Lane 2004-06-20 13:11:27 Re: pg_proc_proname_args_nsp_index error