Skip site navigation (1) Skip section navigation (2)

Re: How to know the password for the user 'postgres'

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to know the password for the user 'postgres'
Date: 2008-10-28 12:32:17
Message-ID: 20081028123217.GU2459@frubble.xen.chris-lamb.co.uk (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote:
> An easy trick I have found to set postgres password: $ sudo passwd
> postgres, and now you can type a new password. So now you can switch
> user with: $ su postgres, and then connect to the DB with psql.

Won't that allow logins to the postgres account then?  If there's no
password then logins (either locally, ssh, or whatever is configured)
can't happen and your data is going to be safer.  Going in through root
first may require five more characters to be typed (or less if you
create an alias), but wont create any backdoors.


  Sam

In response to

Responses

pgsql-general by date

Next:From: John DeSoiDate: 2008-10-28 12:34:36
Subject: Re: [Help] Config Failure on Mac OSX: psqlodbc-08.03.0300
Previous:From: Andrew SullivanDate: 2008-10-28 12:28:54
Subject: Re: Archiving WAL for 7.4.21

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group