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

From: Giles Lean <giles(dot)lean(at)pobox(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: John Gage <jsmgage(at)numericable(dot)fr>, PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unable to run createlang (or psql for that matter)
Date: 2010-04-26 15:56:34
Message-ID: 20100426155634.30916.qmail@sapphire.netherstone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Dave Page <dpage(at)pgadmin(dot)org> wrote:

> 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$

Or even without a password, from an administrative account which
can use sudo:

$ sudo -i -u postgres
Password:
sapphire:~ postgres$ id
uid=770(postgres) gid=770(postgres)
groups=770(postgres),402(com.apple.sharepoint.group.1),61(localaccounts),12(everyone)

Regards,

Giles

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jkunkel 2010-04-26 17:37:52 gmake check problem
Previous Message Chris.Ellis 2010-04-26 15:53:32 Re: Table Bloat still there after the Vacuum