Re: postgres db deleted and recreated... "No directory, logging in with HOME=/" error... - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: postgres db deleted and recreated... "No directory, logging in with HOME=/" error...
Date
Msg-id 20060507040128.GA2482@wolff.to
Whole thread Raw
In response to Re: postgres db deleted and recreated... "No directory, logging in with HOME=/" error...  (David <dbree@duo-county.com>)
List pgsql-novice
On Sat, May 06, 2006 at 16:58:47 -0500,
  David <dbree@duo-county.com> wrote:
>
> This is because you're using ident authentication for user postgres.  I
> don't think you can use this option with ident authentication, because
> ident authentication checks to see if you're who you say you are, and as
> above, it doesn't see you as being postgres, but as root.  As I noted in
> my previous reply, my postgres user authenticates (locally) by this
> method.  You will have to su to root and then su to postgres, or
> directly with a command like

You can use -U with ident authentication. You need to set up custom maps
to make it useful. I normally do things that way.

pgsql-novice by date:

Previous
From: David
Date:
Subject: Re: Switch to Linux Dev Questions
Next
From:
Date:
Subject: postgres db