pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marcelo Costa <marcelojscosta@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Lane Van Ingen <lvaningen@esncc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Security Concerns over User 'postgres'
Date: Fri, 22 Sep 2006 16:38:02 -0300
Message-ID: <c13f2d590609221238g11b1d578n75f234c7fcfadbdd@mail.gmail.com> (raw)
In-Reply-To: <9540.1158952105@sss.pgh.pa.us>
References: <TWMAILaUfOImd1UtYj700000063@twmail.ESNCC.COM>
	<9540.1158952105@sss.pgh.pa.us>

Hi,

Only create one user to your aplications and give to her rights to acess
your database

You can change the password of postgresql user

In your linux distro type:

su - postgres

psql -U postgres

in the prompt of postgres type:

# alter user postgres with password 'your new password';

After this your password of user postgres are change.

Create an user to your aplications and give this to all users.

Don´t forget of rights (INSERT,SELECT,UPDATE,DELETE) on your tables to this
user.

[],s

Marcelo Costa
DBA
Executive Secretary of Education from Pará/Amazônia/Brazil



2006/9/22, Tom Lane <tgl@sss.pgh.pa.us>:
>
> "Lane Van Ingen" <lvaningen@esncc.com> writes:
> > We created our PostgreSQL instance by compiling it from source, and the
> > instance is working just fine. User postgres runs the service; we do not
> > know what the password is, and we think it got created automatically by
> the
> > compile / install process.
>
> Are you sure it even *has* a password?  In the default RPM installation,
> user postgres is created without any password --- the only way to become
> postgres is to su there from root, and if you've got root you hardly
> need to crack into postgres.
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>



-- 
Marcelo Costa

view thread (5+ messages)  latest in thread

Message-ID: <c13f2d590609221238g11b1d578n75f234c7fcfadbdd@mail.gmail.com>
Permalink:  ../c13f2d590609221238g11b1d578n75f234c7fcfadbdd@mail.gmail.com/
Also on:    postgresql.org/message-id/c13f2d590609221238g11b1d578n75f234c7fcfadbdd@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: marcelojscosta@gmail.com, tgl@sss.pgh.pa.us, lvaningen@esncc.com
  Subject: Re: Security Concerns over User 'postgres'
  In-Reply-To: <c13f2d590609221238g11b1d578n75f234c7fcfadbdd@mail.gmail.com>
  References: <TWMAILaUfOImd1UtYj700000063@twmail.ESNCC.COM> <9540.1158952105@sss.pgh.pa.us> <c13f2d590609221238g11b1d578n75f234c7fcfadbdd@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox