| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | John Gage <jsmgage(at)numericable(dot)fr> |
| Cc: | Jorge Arevalo <jorgearevalo(at)gis4free(dot)org>, PostgreSQL - General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Unable to run createlang (or psql for that matter) |
| Date: | 2010-04-26 08:58:11 |
| Message-ID: | y2g937d27e11004260158p14bded7ch6ca80b1019108d8d@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Apr 26, 2010 at 8:55 AM, John Gage <jsmgage(at)numericable(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luís de Sousa | 2010-04-26 10:06:23 | Convert odb to Postgres |
| Previous Message | Yan Cheng CHEOK | 2010-04-26 08:28:16 | Re: Deadlock occur while creating new table to be used in partition. |