Hi Viorel,

what are the exact circumstances for this? I'm not experiencing
that behavior. Maybe it depends on your settings in pg_hba.conf?
And are you using -X set-session-authorization and so on?

Regards
Tino Wildenhain

Viorel Dragomir wrote:
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" <[EMAIL PROTECTED]>
To: "Pgsql-General" <[EMAIL PROTECTED]>
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



---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])




---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to