or simply use oidentd
--- On Mon, 9/8/08, Robert Hodges <[EMAIL PROTECTED]> wrote: > From: Robert Hodges <[EMAIL PROTECTED]> > Subject: Re: [Sequoia] PostgreSql Backuper Error > To: "Sequoia general mailing list" <[email protected]> > Date: Monday, September 8, 2008, 4:58 PM > 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 _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
