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

From Alan Hodgson
Subject Re: [pgsql-novice] Daily digest v1.3706 (6 messages)
Date
Msg-id 1659889.N3MqLQ1TXV@skynet.simkin.ca
Whole thread Raw
Responses Re: [pgsql-novice] Daily digest v1.3706 (6 messages)  (Michael Convey <smconvey@gmail.com>)
List pgsql-novice
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.

Attachment

pgsql-novice by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Linux Users vs PostgreSQL Users
Next
From: "petrov.boris.v@mail.ru"
Date:
Subject: Different performance of two simple queries