Kemin Zhou wrote: >> >>If I have to organize an automatic nightly pg_dumpall, how do I handle >>authentication ? I do not want to create a passwordless superuser (or >>trust method in pg_hba.conf), and there is noone to enter the password >>manually. Is there another recipe? >> >>Thanks in advance for any input. >> >> >> > use crontab > run this daily > su - postgres -c "/usr/local/pgsql/bin/pg_dump -b -Ft -f db.tar -h > machine_name_of_db your_db"
I am afraid you did not understand my question. In your scenario, pg_dump will ask for the authentification of the user "postgres". I have already stated above that I do not want to create a passwordless superuser (or trust method in pg_hba.conf). > > Kemin > > > > > > > ********************************************************************** > Proprietary or confidential information belonging to Ferring Holding SA or to one of > its affiliated companies may be contained in the message. If you are not the > addressee indicated in this message (or responsible for the delivery of the message > to such person), please do not copy or deliver this message to anyone. In such case, > please destroy this message and notify the sender by reply e-mail. Please advise the > sender immediately if you or your employer do not consent to e-mail for messages of > this kind. Opinions, conclusions and other information in this message represent the > opinion of the sender and do not necessarily represent or reflect the views and > opinions of Ferring. > ********************************************************************** > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005/[EMAIL PROTECTED] http://vas.tomsk.ru/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
