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 <parri...@gmail.com> wrote: > On Thu, Aug 8, 2013 at 8:42 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Don Parris <parri...@gmail.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@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 >
