Re: Unable to run createlang (or psql for that matter)

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