On Tue, May 18, 2010 at 12:15 PM, Thom Brown <thombrown@xxxxxxxxx> wrote:
On 18 May 2010 17:11, akp geek <akpgeek@xxxxxxxxx> wrote:That's odd. I can't see why those settings should conflict, although
> pg_restore -h 10.xx.xx.xxx -d dbName -n schemaName -v -U postgres
> testDB_20100414.txt -f outputifile
>
> I got the following error "pg_restore: options -d/--dbname and -f/--file
> cannot be used together"
>
> Regards
>
I notice you haven't specified your input file as the last parameter.
It shouldn't appear before the other arguments.
Yeah, the output file isn't for messages, it's for the data. You can restore a compressed dump to two places, either a text file (-f) or a database (-d).
--Scott
Anyone else know?
Thom
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
