Re: Post Install / Secure PostgreSQL - Mailing list pgsql-general

From Sam Mason
Subject Re: Post Install / Secure PostgreSQL
Date
Msg-id 20100913103355.GA7862@samason.me.uk
Whole thread Raw
In response to Re: Post Install / Secure PostgreSQL  (björn lundin <b.f.lundin@gmail.com>)
Responses Re: Post Install / Secure PostgreSQL  (Carlos Mennens <carlos.mennens@gmail.com>)
List 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/

pgsql-general by date:

Previous
From: Carlos Henrique Reimer
Date:
Subject: Re: User function canceling VACUUMDB utility
Next
From: Merlin Moncure
Date:
Subject: Re: How to inherit search_path from template