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