Thread: pg_restore to log file
Hi All -
Is there a way to direct the message generated during pg_restore to a log file?
Regards
On 18 May 2010 17:03, akp geek <akpgeek@gmail.com> wrote: > Hi All - > Is there a way to direct the message generated during > pg_restore to a log file? > Regards > I think you can use "-f outputfile". Regards Thom
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
On Tue, May 18, 2010 at 12:07 PM, Thom Brown <thombrown@gmail.com> wrote:
I think you can use "-f outputfile".On 18 May 2010 17:03, akp geek <akpgeek@gmail.com> wrote:
> Hi All -
> Is there a way to direct the message generated during
> pg_restore to a log file?
> Regards
>
Regards
Thom
On Tue, May 18, 2010 at 12:11 PM, akp geek <akpgeek@gmail.com> wrote:
pg_restore -h 10.xx.xx.xxx -d dbName -n schemaName -v -U postgres testDB_20100414.txt -f outputifileI got the following error "pg_restore: options -d/--dbname and -f/--file cannot be used together"
I think you would either capture stdout or stderr (I'm honestly not sure which is required)
pg_restore -all options >output.txt 2>&1
--Scott
RegardsOn Tue, May 18, 2010 at 12:07 PM, Thom Brown <thombrown@gmail.com> wrote:I think you can use "-f outputfile".On 18 May 2010 17:03, akp geek <akpgeek@gmail.com> wrote:
> Hi All -
> Is there a way to direct the message generated during
> pg_restore to a log file?
> Regards
>
Regards
Thom
On 18 May 2010 17:11, akp geek <akpgeek@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. Anyone else know? Thom
Thanks a lot
pg_restore -all options >output.txt 2>&1 worked
Regards
On Tue, May 18, 2010 at 12:15 PM, Scott Mead <scott.lists@enterprisedb.com> wrote:
On Tue, May 18, 2010 at 12:11 PM, akp geek <akpgeek@gmail.com> wrote:pg_restore -h 10.xx.xx.xxx -d dbName -n schemaName -v -U postgres testDB_20100414.txt -f outputifileI got the following error "pg_restore: options -d/--dbname and -f/--file cannot be used together"I think you would either capture stdout or stderr (I'm honestly not sure which is required)pg_restore -all options >output.txt 2>&1--ScottRegardsOn Tue, May 18, 2010 at 12:07 PM, Thom Brown <thombrown@gmail.com> wrote:I think you can use "-f outputfile".On 18 May 2010 17:03, akp geek <akpgeek@gmail.com> wrote:
> Hi All -
> Is there a way to direct the message generated during
> pg_restore to a log file?
> Regards
>
Regards
Thom
On Tue, May 18, 2010 at 12:15 PM, Thom Brown <thombrown@gmail.com> wrote:
On 18 May 2010 17:11, akp geek <akpgeek@gmail.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general