Re: warning about console code page on starting psql

From: Martin Steer <martinsteer(at)maxi(dot)net(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: warning about console code page on starting psql
Date: 2014-12-18 13:35:07
Message-ID: 20141218133507.GC775@arch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs 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.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message David Johnston 2014-12-19 21:33:19 Add Optional Variadic Invocation Explanation to 35.4.5 (xfunc-sql)
Previous Message Scott Robertson 2014-12-18 06:35:56 Re: warning about console code page on starting psql

Browse pgsql-novice by date

  From Date Subject
Next Message Ravi Kiran 2014-12-23 09:37:56 mysql with postgres
Previous Message Scott Robertson 2014-12-18 06:35:56 Re: warning about console code page on starting psql