Re: trouble downloading postgres 9.4 for RHEL 6.x

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: trouble downloading postgres 9.4 for RHEL 6.x
Date: 2015-10-21 22:10:55
Message-ID: 56280D6F.5010009@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/21/2015 11:58 AM, anj patnaik wrote:
> With the graphical installer, I had a way to create a user. Does it
> create postgres user by default?

after following the steps I gave earlier, do this...

$ sudo -u postgres psql
.... postgres=# create user YOURNAME password 'whatever' superuser;
.... postgres=# create database YOURNAME owner YOURNAME;
.... postgres=# \q
$

and now when logged in as unix user 'YOURNAME', you can connect to psql
and use all admin functionality directly. if you want a gui admin
utility...

$ sudo yum install -y pgadmin3_94
....
$ pgadmin

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-10-21 23:00:27 Re: temporary indexes?
Previous Message Jonathan Vanasco 2015-10-21 20:28:53 Re: temporary indexes?