Re: [GENERAL] regular backups - super user

2003-11-01 Thread Bruno Wolff III
On Fri, Oct 31, 2003 at 15:48:31 -0600, Stuart Johnston <[EMAIL PROTECTED]> wrote: > > 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). I

Re: [GENERAL] regular backups - super user

2003-11-01 Thread Joshua D. Drake
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 acco

Re: [GENERAL] regular backups - super user

2003-10-31 Thread DeJuan Jackson
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 pass

Re: [GENERAL] regular backups - super user

2003-10-31 Thread Stuart Johnston
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

[GENERAL] regular backups - super user

2003-10-30 Thread Jeff MacDonald
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)---