pg_restore to log file

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:

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

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 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

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:

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

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: