A bit of an aside, but you also might want to change that "CREATE EXTENSION ltree;" to
"CREATE EXTENSION IF NOT EXISTS ltree;"On Fri, Aug 9, 2013 at 3:57 AM, Don Parris <parrisdc@xxxxxxxxx> wrote:
On Thu, Aug 8, 2013 at 8:42 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Don Parris <parrisdc@xxxxxxxxx> writes:You're right, it can't, if you've selected peer authentication in
> When I try a simple psql -U postgres -W - just to initiate the psql
> session, I get:
> psql: FATAL: Peer authentication failed for user "postgres"
> It's like my regular user cannot connect as the postgres user.
pg_hba.conf. You'd need to use some other auth method, perhaps
password-based auth, if you want this to work. Read up on auth methods
in the fine manual.
Sure, because then psql is launched as the postgres OS user, and peer auth
> However, this works (with me just typing my password for sudo):
> donp@wiesbaden:~$ sudo -u postgres psql -U postgres
> [sudo] password for donp:
will let that user connect as the postgres DB user.
regards, tom lane
Ahhhh... now I understand. Thanks Tom! That should really help! I'll check that out.
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software AdvocateGPG Key ID: F5E179BE
