Sorry; I meant a password at the operating system level, not at the postgresql level.
On my Linux system, without an OS level password, the only way to log in (in Linux) to the postgres account is by su'ing from root, which seems more secure than having a password for the postgres account.
----- Original Message -----
From: "jqpx37" <jqpx37@xxxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Thursday, June 08, 2006 11:05 AM
Subject: [GENERAL] Password for postgresql superuser?
Is there any security risk in the postgresql superuser having a password?
I installed a Linux distro recently and had it install Postgresql. It automatically set up the postgres account; the account was set up with no password.
I could of course create a password, but it's not clear to me that's a good thing from a security standpoint.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
