Re: [pgsql-novice] Daily digest v1.3706 (6 messages)

On Mon, Nov 16, 2015 at 6:26 PM, Alan Hodgson <ahodgson@simkin.ca> wrote:

On Monday, November 16, 2015 05:36:08 PM Michael Convey wrote:
> ​Thank you. Assuming a default Fedora installation, if I am logged in as
> Linux user lab and I don't know the Linux "postgres"​ password, but I do
> know the PostgreSQL "postgres" role password; what is the syntax (from the
> Linux command line) to login as the "postgres" role and connect to the
> "postgres" database?

psql -U postgres postgres

It'll prompt for the password.

Make sure you've enabled md5 or password as an authentication method allowed
for local in pg_hba.conf.

​Thank you. I received the following error:

bash-4.2 ~ $ psql -U postgres postgres

psql: FATAL:  Peer authentication failed for user "postgres"

Here's the relevant portion of my ​pg_hba.conf file:

-----------------------------------------------------------------------------------------------------------

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only

local   all             all                                     peer

# IPv4 local connections:

host    all             all             127.0.0.1/32            ident

# IPv6 local connections:

host    all             all             ::1/128                 ident

# Allow replication connections from localhost, by a user with the

# replication privilege.

#local   replication     postgres                                peer

#host    replication     postgres        127.0.0.1/32            ident

#host    replication     postgres        ::1/128                 ident

-----------------------------------------------------------------------------------------------------------

Do I modify the first section, as follows?

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only

local   all             all                                     peer

local   all             all             samehost          md5    #added

Or, do I replace the first line with #added?