From: | Scott Mead <scott(dot)lists(at)enterprisedb(dot)com> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | akp geek <akpgeek(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_restore to log file |
Date: | 2010-05-18 16:26:49 |
Message-ID: | AANLkTikRDVk8bOfujdEQosIb4MZI7YE_tegOH3VjSwK0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 18, 2010 at 12:15 PM, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> On 18 May 2010 17:11, akp geek <akpgeek(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | akp geek | 2010-05-18 16:32:09 | Re: pg_restore to log file |
Previous Message | Scott Mead | 2010-05-18 16:15:23 | Re: pg_restore to log file |