logging pg_dump results in windows 7

From: Owen Sleep <osleep(at)docfocus(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: logging pg_dump results in windows 7
Date: 2012-04-19 17:45:54
Message-ID: 4F904F52.702@docfocus.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm currently running Postgres version 9.0.1 (haven't gone to 9.0.7 yet
but soon) in a Windows 7 Professional x64 environment.

I run a pg_dump of certain DBs every night and would like to log the
pg_dump results into a file. I'm just wondering what the best method for
this is.

The pg_dump command I use is contained in a *.bat file. The actual
follows this format:
pg_dump.exe -h my_host -p my_port -U my_user -w -F c -b -v -f
C:\testbackup postgres

I've tried the following commands to redirect the output to a file:
pg_dump.exe -h my_host -p my_port -U my_user -w -F c -b -v -f
C:\testbackup postgres>C:\testlog.txt
pg_dump.exe -h my_host -p my_port -U my_user -w -F c -b -v -f
C:\testbackup postgres|echo C:\testlog.txt
Both fail to produce anything.

I've searched the darkest corners of the net for an answer to this and
come up with nothing. Which makes me feel that this is extraordinarily
simple.
Am I correct?

Sleeper

--
Owen Sleep
DOCFOCUS INC.
Suite 103, 17505 - 107 Avenue
Edmonton, Alberta T5S 1E5
Email: osleep(at)docfocus(dot)ca
Support: dfisupport(at)docfocus(dot)ca
WebSite: www.docfocus.ca

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message raghu ram 2012-04-19 18:12:17 Re: logging pg_dump results in windows 7
Previous Message Willy-Bas Loos 2012-04-19 16:32:27 Re: Escaping literal strings in pg_8.4