From: | Jim Blizard <jim(at)blacksheepventures(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: logging pg_dump results in windows 7 |
Date: | 2012-04-23 17:46:37 |
Message-ID: | 4F95957D.9030503@blacksheepventures.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Run you command and redirect to a file. Like this:
pg_dump.exe > pg_dump.sql
This will dump the output of pg_dump to pg_dump.sql.
*Jim Blizard*
Technology Director
Black Sheep Ventures, LLC
678.343.7771
On 4/19/2012 1:45 PM, Owen Sleep wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bartosz Dmytrak | 2012-04-24 18:46:52 | Re: Returning generated id after a transaction. |
Previous Message | Guillaume Henriot | 2012-04-23 15:28:31 | Re: Returning generated id after a transaction. |