Re: postgres db deleted and recreated... "No directory, logging in with HOME=/" error...

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: postgres db deleted and recreated... "No directory, logging in with HOME=/" error...
Date: 2006-05-07 04:01:28
Message-ID: 20060507040128.GA2482@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, May 06, 2006 at 16:58:47 -0500,
David <dbree(at)duo-county(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2006-05-08 01:02:07 postgres db
Previous Message David 2006-05-07 01:11:07 Re: Switch to Linux Dev Questions