Postgres Pro
Downloads
Home   >   mailing lists

Re: File System Restore - Mailing list pgsql-general

From Doug McNaught
Subject Re: File System Restore
Date
Msg-id 87isdmicvl.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: File System Restore  ("Tim Penhey" <tim@penhey.net>)
List pgsql-general
Tree view 
"Tim Penhey" <tim@penhey.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_proc_proname_args_nsp_index error
Next
From: Tom Lane
Date:
Subject: Re: Relocation error pg_dumpall undefined symbol get_progname in 7.4.3