Re: Post Install / Secure PostgreSQL

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Post Install / Secure PostgreSQL
Date: 2010-09-13 10:33:55
Message-ID: 20100913103355.GA7862@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 10, 2010 at 01:23:39PM -0700, bjjjrn lundin wrote:
> I usually do like this on a new box
>
> sudo su -
> su - postgres
> createuser bnl
> exit
> exit

It would be somewhat easier to use sudo's "-u" switch, the following
should do the same as the above:

sudo -u postgres createuser "$USER"

--
Sam http://samason.me.uk/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MailingLists 2010-09-13 11:48:50 new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
Previous Message Carlos Henrique Reimer 2010-09-13 10:16:34 Re: User function canceling VACUUMDB utility