On Mon, Apr 26, 2010 at 8:55 AM, John Gage <jsmgage@numericable.fr> wrote:
> A very key difficulty is that if I attempt to add postgres as a user to my
> system, my system tells me postgres already is a user. But, unfortunately,
> postgres as a user on my system has no password. His postgresql password
> does not work on the system.
The account doesn't have a password by default as it's a service
account and you shouldn't need to use it interactively.
If you really want to though, just set a password:
gator:~ dpage$ sudo passwd postgres
Changing password for postgres.
New password:
Retype new password:
gator:~ dpage$ su - postgres
Password:
gator:~ postgres$
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company