Thanks a lot pg_restore -all options >output.txt 2>&1 worked
Regards On Tue, May 18, 2010 at 12:15 PM, Scott Mead <[email protected]>wrote: > > On Tue, May 18, 2010 at 12:11 PM, akp geek <[email protected]> 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 capture stdout or stderr (I'm honestly not sure > which is required) > > > pg_restore -all options >output.txt 2>&1 > > --Scott > >> >> >> Regards >> >> >> >> >> On Tue, May 18, 2010 at 12:07 PM, Thom Brown <[email protected]> wrote: >> >>> On 18 May 2010 17:03, akp geek <[email protected]> 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 >>> >> >> >
