Re: [GENERAL] regular backups - super user
Hello, Your pg_hba.conf controls the authentication model for your machine. One way to handle this is to have the database on a local machine and allow anything local (not localhost/127.0.0.1) to be of type trust. You should only do this if you trust the people that have access to shell accounts on that machine. Then set your network connections to be of type md5 (better yet use hostssl as well). Sincerely, Joshua D. Drake Paul Thomas wrote: On 30/10/2003 15:29 Jeff MacDonald wrote: Hi, WHen i run pg_dumpall as the super user [postgres in my case] it asks for a password for every database. I don't know my users passwords. Is there a way to make the super user able to backup without passwords ? What version of PG are you using? I've just tried this on my 7.3.4 box and I don't get asked for user passwords. -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC Postgresql support, programming, shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL.Org - Editor-N-Chief - http://www.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])
Re: [GENERAL] regular backups - super user
DeJuan Jackson wrote: quick answer: research/read the pg_hba.conf in the data directory. Jeff MacDonald wrote: Hi, WHen i run pg_dumpall as the super user [postgres in my case] it asks for a password for every database. I don't know my users passwords. Is there a way to make the super user able to backup without passwords ? If your users always connect through TCP/IP then you can set local connections to not use passwords but I'm pretty sure there is no way to configure this just for the postgres user (I wish you could). If you need passworded local connections for users then you'll probably want to turn on 'ident' mode just long enough to set the password for the postgres user (or some other 'super user'). Then you may also want to use the PGPASSWORD environment variable or the .pgpass file to avoid typing the password repeatedly. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] regular backups - super user
quick answer: research/read the pg_hba.conf in the data directory. Jeff MacDonald wrote: Hi, WHen i run pg_dumpall as the super user [postgres in my case] it asks for a password for every database. I don't know my users passwords. Is there a way to make the super user able to backup without passwords ? Thanks. Jeff. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 8: explain analyze is your friend