From: | "Viorel Dragomir" <bc(at)vio(dot)ro> |
---|---|
To: | <shridhar_daithankar(at)persistent(dot)co(dot)in>, "Pgsql-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Scheduled back up |
Date: | 2003-07-18 10:39:19 |
Message-ID: | 037701c34d18$d84af210$0600a8c0@fix.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
As i experienced with pg_dump it looks like in ver.7.3 requires interactive
enter password for *custom users*.
The 7.1 will not make this kind of problems.
Still in 7.3 you can make it with cron, but as i know, only with a script
which might look like this
<?php
exec("pg_dump -u [other options] db_name < /path_to/password_file.txt >
the_dumped_file");
?>
where password_file.txt contains:
user_name
user_password
good luck, and if u find that i already said is wrong please notify me
[2 days ago i've send [almost] the same problem and this is the only answer
that i got it]
----- Original Message -----
From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, July 18, 2003 1:35 PM
Subject: Re: [GENERAL] Scheduled back up
> On 18 Jul 2003 at 15:58, Kallol Nandi wrote:
> > How to go about scheduled backup in Postgresql.
>
> You need to use cron and pgdump. Man pages for both of them will give you
what
> you want.
>
> Bye
> Shridhar
>
> --
> Cohen's Law: There is no bottom to worse.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Viorel Dragomir | 2003-07-18 11:21:55 | Re: Scheduled back up |
Previous Message | Shridhar Daithankar | 2003-07-18 10:35:12 | Re: Scheduled back up |