Re: warning about console code page on starting psql - Mailing list pgsql-novice

From Martin Steer
Subject Re: warning about console code page on starting psql
Date
Msg-id 20141218133507.GC775@arch
Whole thread Raw
In response to Re: warning about console code page on starting psql  (Scott Robertson <stumpednomore@gmail.com>)
List pgsql-novice
On Thu, Dec 18, 2014 at 02:35:56PM +0800, Scott Robertson wrote:

>open psql (in same console) as superuser so operating system user password
>isn't expected: psql -U postgres
>prompt comes up for postgres password

I doubt that you need to connect as superuser. If you have it, see the
manpage for psql, otherwise online, or the postgres docs. There are
various ways of setting permissions.

(On Linux the default postgres user is your user name, i.e. in my case
'martin'. Here 'psql (dbname)' is enough, no password needed.)

M.




pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: warning about console code page on starting psql
Next
From: Ravi Kiran
Date:
Subject: mysql with postgres