X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 46DBE9FB410 for ; Fri, 22 Sep 2006 16:38:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 18510-09 for ; Fri, 22 Sep 2006 19:38:05 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 084D19FB40A for ; Fri, 22 Sep 2006 16:38:04 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id 30so284323ugc for ; Fri, 22 Sep 2006 12:38:03 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=JF6WlOZ42QTd47tlmbN3g3LCOVPvBgwirTzgSZV8cUCLV11U0Z4R2U1l/I6FJujyscQn6ZIUvvzkRCapDITgph8FKrXKqzJWdJez/iVz4GKucVoVnsE1cUpqvTJR6igsh9cpEuGbR5wwpPRV4bzLpbHmTfjvSW9BOo+Juzb3zUE= Received: by 10.67.101.10 with SMTP id d10mr893594ugm; Fri, 22 Sep 2006 12:38:03 -0700 (PDT) Received: by 10.66.223.9 with HTTP; Fri, 22 Sep 2006 12:38:02 -0700 (PDT) Message-ID: Date: Fri, 22 Sep 2006 16:38:02 -0300 From: "Marcelo Costa" To: "Tom Lane" Subject: Re: Security Concerns over User 'postgres' Cc: "Lane Van Ingen" , pgsql-admin@postgresql.org In-Reply-To: <9540.1158952105@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17269_15079169.1158953882917" References: <9540.1158952105@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.574 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/249 X-Sequence-Number: 23163 ------=_Part_17269_15079169.1158953882917 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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=B4t forget of rights (INSERT,SELECT,UPDATE,DELETE) on your tables to th= is user. [],s Marcelo Costa DBA Executive Secretary of Education from Par=E1/Amaz=F4nia/Brazil 2006/9/22, Tom Lane : > > "Lane Van Ingen" 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 no= t > > 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 > --=20 Marcelo Costa ------=_Part_17269_15079169.1158953882917 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi,

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

You can change the password of postgresql us= er

In your linux distro type:

su - postgres

psql -U po= stgres

in the prompt of postgres type:

# alter user postgres with p= assword 'your new password';

After this your password of user postgr= es are change.

Create an user to your aplications and give this to a= ll users.

Don=B4t forget of rights (INSERT,SELECT,UPDATE,DELETE) on your tabl= es to this user.

[],s

Marcelo Costa
DBA
Executive Secre= tary of Education from Par=E1/Amaz=F4nia/Brazil



2006/9/22, Tom Lane <tgl@sss.pgh.pa= .us>:
lvani= ngen@esncc.com> writes:
> We created our PostgreSQL instance b= y 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 automatical= ly by the
> compile / install process.

Are you sure it even *h= as* a password?  In the default RPM installation,
user postgre= s is created without any password --- the only way to become
postgres is to su there from root, and if you've got root you hardlyneed to crack into postgres.

      &n= bsp;            = ;     regards, tom lane

-------------------= --------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

   &nb= sp;           http://www.postgresql.org/docs/faq<= br>



--
Marcelo Costa ------=_Part_17269_15079169.1158953882917--