Re: [GENERAL] Assigning password to the superuser

2005-04-14 Thread Tom Lane
Forgot to mention: you might also want to think about setting up a separate superuser account for the stats monitor. Unlike Unix, Postgres doesn't think there can be only one superuser. The advantage of this is (a) you can give it a separate password from what you normally use, and (b) you can ch

Re: [GENERAL] Assigning password to the superuser

2005-04-14 Thread Tom Lane
Justin Hawkins <[EMAIL PROTECTED]> writes: > I'm putting together a system to monitor multiple postgresql > installations and to gain full access to all remote statistics I'd like > to connect as the super user. > To do that I'd add a single IP entry in pg_hba.conf for the monitoring > machine and

[GENERAL] Assigning password to the superuser

2005-04-14 Thread Justin Hawkins
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm putting together a system to monitor multiple postgresql installations and to gain full access to all remote statistics I'd like to connect as the super user. To do that I'd add a single IP entry in pg_hba.conf for the monitoring machine