Search Postgresql Archives

Re: How To Install Extension Via Script File?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



A bit of an aside, but you also might want to change that "CREATE EXTENSION ltree;" to

"CREATE EXTENSION IF NOT EXISTS ltree;"

That way your script won't error out if the extension is already enabled.


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:
> 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@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
GPG Key ID: F5E179BE


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux