[ADMIN] All users can enter as one user "puser" without superuser priviledges: how?

2001-12-16 Thread Jameson Burt
I seek a simplistic access, 1. superuser "postgres" gets access when his system-name is "postgres", but not otherwise [some security sought]. This can be done in pg_hba.conf with either local all peer sameuser local all trust #but anyone then gets "postges" access. 2. One o

Re: [ADMIN] Shared Memory

2001-12-16 Thread Chris Ruprecht
Thank you guys - I have the answer and it's ticking along nicely now with 6 KB of shared memory (this is what 'top' reports). I have set the parameter in the config file to 8192, now I have to monitor if this has any impact on speed. Best regards, Chris -- Chris Ruprecht Network grunt and

Re: [ADMIN] Shared Memory

2001-12-16 Thread Nick Fankhauser
Chris: The quick answer is here- a little more than halfway down the page. http://www.postgresql.org/idocs/index.php?kernel-resources.html Regards, -Nick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Ruprecht > Sent: Saturday, December