Date: Fri, 19 Dec 2014 00:35:07 +1100
From: Martin Steer <martinsteer@maxi.net.au>
To: pgsql-novice@postgresql.org
Subject: Re: warning about console code page on starting psql
Message-ID: <20141218133507.GC775@arch>
References: <54910242.3090706@gmail.com> <549113EA.2010007@gmail.com>
 <1418795707357-5831042.post@n5.nabble.com>
 <CAKFQuwaT55DVMResDFbvscdT5jigTAE5Z+sp6P8Zc8kgXThJCQ@mail.gmail.com>
 <CAKFQuwaCDcUGvoWowWh__J80KR+nS51YBRhNFu8yKPLRsNxnfQ@mail.gmail.com>
 <549275CC.4010607@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Disposition: inline
In-Reply-To: <549275CC.4010607@gmail.com>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-novice-owner@postgresql.org

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.


-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice