On Tue, May 18, 2010 at 12:15 PM, Thom Brown <thombr...@gmail.com> wrote:
> On 18 May 2010 17:11, akp geek <akpg...@gmail.com> wrote: > > 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 > > > > That's odd. I can't see why those settings should conflict, although > 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >