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

Re: password

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: "benoit(dot)le-dizes(at)voila(dot)fr" <benoit(dot)le-dizes(at)voila(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: password
Date: 2001-04-16 20:21:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"benoit(dot)le-dizes(at)voila(dot)fr" wrote:
  >I use postgresql 7.x on red hat 7.0
  >I use pgaccess and I have created new users with password
  >but when I want to open a database with a new user which normally needs a pa
      >ssword, if I don't assign the password, the database is open without it.
  >Why ?
Access control is defined by the text file pg_hba.conf.  The default setting
in this file is 

  local all trust

which means that anyone on the local machine can log into any PostgreSQL
database as any user, without having to give a password.

Read the comments in pg_hba.conf and alter it to suit your desired access

Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                    
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
     "But seek ye first the kingdom of God, and his  
      righteousness; and all these things shall be added 
      unto you."     Matthew 6:33 

pgsql-admin by date

Next:From: Oliver ElphickDate: 2001-04-16 22:58:39
Subject: Re: password
Previous:From: benoit.le-dizes@voila.frDate: 2001-04-16 19:50:12
Subject: password

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