Re: How To Install Extension Via Script File?

On Thu, Aug 8, 2013 at 8:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Don Parris <parrisdc(at)gmail(dot)com> writes:
> > 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.
>
> You're right, it can't, if you've selected peer authentication in
> 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.
>
> > However, this works (with me just typing my password for sudo):
> > donp(at)wiesbaden:~$ sudo -u postgres psql -U postgres
> > [sudo] password for donp:
>
> Sure, because then psql is launched as the postgres OS user, and peer auth
> 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 Advocate
http://dcparris.net/
<https://www.xing.com/profile/Don_Parris><http://www.linkedin.com/in/dcparris>
GPG Key ID: F5E179BE