On 26/01/2010 22:28, stee...@gmail.com wrote:
> I am new to posgres.
> By running Pg-dump like this, do we need to type in pwd for login manually?
It depends on what access rules are defined in the pg_hba.conf file.
Read about it here:
http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-
I am new to posgres.
By running Pg-dump like this, do we need to type in pwd for login manually?
Thanks
Sent from my BlackBerry device on the Rogers Wireless Network
-Original Message-
From: Moe
Date: Tue, 26 Jan 2010 19:25:50
To:
Subject: Re: [GENERAL] pg dump.. issue with when
Thank you both, that did the trick.
Sincerely / Moe
On Tue, Jan 26, 2010 at 7:14 PM, Tom Lane wrote:
> Moe writes:
> > I have a simple script file db :
> > #!/bin/bash
> > pg_dump -U postgres prodDB > /var/a/db/$(date
> "+%Y-%m-%d_%H:%M")-prodDB.dump
>
> > Which works fine when executed manual
Moe writes:
> I have a simple script file db :
> #!/bin/bash
> pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
> Which works fine when executed manually ( ./db ).. I get a dump file which
> is around 1.9 MB
> I run this script from the crontab schedueler (crontab -e)
Moe wrote:
> Hi folks,
>
> I have a simple script file db :
> #!/bin/bash
> pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
>
> --
> Which works fine when executed manually ( ./db ).. I get a dump file which is
> around 1.9 MB
>
>
> I run this script from
On Tue, Jan 26, 2010 at 11:54 AM, Moe wrote:
> Hi folks,
>
> I have a simple script file db :
> #!/bin/bash
> pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
>
> --
> Which works fine when executed manually ( ./db ).. I get a dump file which
> is around 1.9 MB
