Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group