-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
thank you for you reply. I already solved this using trust authentication for our admin user from the sequoia ip-address. This is save enought for our needs. :) Markus Robert Hodges schrieb: > 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 - -- 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/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIxizYDBHISU1oEKERAuWNAKC/St366+6ROnD2LGCQI8JSrKrltgCfSagk goFIIpTadbF4AsFzMpjfWSw= =Nttd -----END PGP SIGNATURE----- _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
