Re: [GENERAL] pg_restore to log file

2010-05-18 Thread Scott Mead
On Tue, May 18, 2010 at 12:15 PM, Thom Brown wrote: > On 18 May 2010 17:11, akp geek 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 > > cann

Re: [GENERAL] pg_restore to log file

2010-05-18 Thread akp geek
Thanks a lot pg_restore -all options >output.txt 2>&1 worked Regards On Tue, May 18, 2010 at 12:15 PM, Scott Mead wrote: > > On Tue, May 18, 2010 at 12:11 PM, akp geek wrote: > >> pg_restore -h 10.xx.xx.xxx -d dbName -n schemaName -v -U postgres >> testDB_20100414.txt-f outputifile >>

Re: [GENERAL] pg_restore to log file

2010-05-18 Thread Scott Mead
On Tue, May 18, 2010 at 12:11 PM, akp geek 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" > I think you would either ca

Re: [GENERAL] pg_restore to log file

2010-05-18 Thread Thom Brown
On 18 May 2010 17:11, akp geek 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 t

Re: [GENERAL] pg_restore to log file

2010-05-18 Thread akp geek
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 wrote: > On 18 May 2010 17:03, a

Re: [GENERAL] pg_restore to log file

2010-05-18 Thread Thom Brown
On 18 May 2010 17:03, akp geek 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan