Hi Markus, This problem can be solved by using .pgpass to specify passwords. Sequoia uses pg_dump and pg_restore to transfer data, which in turn trigger password prompts within the controller process. Here's how I usually set things up for PostgreSQL:
1.) Create a PostgreSQL login on PG that matches your vdb admin login and password. I usually cheat and make the login a superuser. 2.) Set non-local logins to md5 in pg_hba.conf. This will force PG to ask for passwords, which is good. 3.) Define .pgpass in your home directory and add PostgreSQL logins there. Make sure the file is chmod'ed to 700 or PG clients will ignore the .pgpass settings. To test your work, try 'psql -Umylogin -hmyhost dbname' and ensure it can login directly without a prompt. Now try backup and restore commands. They should work without triggering the prompt problem within the controller. Cheers, Robert On 9/8/08 7:35 AM, "Markus Wolf" <[EMAIL PROTECTED]> wrote: Hi there, I try to use any of the postgres backuper, but all are failing, since thy try to do dropdb, createdb which require a password on the commandline even if I enable a trust user in the pg_hba.conf. The password is requested in the terminal where the controller was started. This is even more worse if the terminal was closed and the controller process moved to the background. Is there any solutions for this? I already tried to set the option useAuthentication. Also to mention we are using sequoia-2.10.10. Thank you very much Markus Wolf -- NMMN - New Media Markets & Networks GmbH Geschäftsführung: Kfm. Michael Schütt Finanzamt HH-Altona UStID DE 812 699 852 HRB 71102 Hamburg HypoVereinsbank - BLZ 200 300 00 - Konto-Nr. 156 29 82 http://www.nmmn.com Tel.: +49 40 284 118 -0 Langbehnstrasse 6 Entwicklung: -720 22761 Hamburg Fax: -999 Rufen Sie uns kostenlos an: http://www.nmmn.com/call/software +++ Hausmesse am 14.11.2008 von 10:00 bis 16:00 Uhr +++ Überzeugen Sie sich auf unserer Hausmesse von unseren Produkten und Dienstleistungen! Weitere Informationen und Anmeldung unter: http://www.nmmn.com/hausmesse/ _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
