Re: Unable to run createlang (or psql for that matter) - Mailing list pgsql-general

From Dave Page
Subject Re: Unable to run createlang (or psql for that matter)
Date
Msg-id y2g937d27e11004260158p14bded7ch6ca80b1019108d8d@mail.gmail.com
Whole thread Raw
In response to Re: Unable to run createlang (or psql for that matter)  (John Gage <jsmgage@numericable.fr>)
Responses Re: Unable to run createlang (or psql for that matter)
Re: Unable to run createlang (or psql for that matter)
List pgsql-general
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

pgsql-general by date:

Previous
From: Yan Cheng CHEOK
Date:
Subject: Re: Deadlock occur while creating new table to be used in partition.
Next
From: John Gage
Date:
Subject: Re: Unable to run createlang (or psql for that matter)