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

db security; user identification

From: Marcin Gil <marcin(dot)gil(at)audax(dot)com(dot)pl>
To: pgsql-novice(at)postgresql(dot)org
Subject: db security; user identification
Date: 2004-01-27 10:30:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I have switched identification method from 'trust' to 'md5'
for all local requests, ie:

- local all all trust
+ local all all md5

But that creates a problem:
- when restarting postgresql it waits for password;
   how can I work it around?

My target is that pgsql restarts (or starst with system init)
properly without need of entering password but every connection
should require it.

If there is no password requirement within local system,
than every user could do createdb -d dbname -U postgres and
create a database..

If I am mistaken, please point it out.

   Marcin Gil :: marcin(dot)gil(at)audax(dot)com(dot)pl


pgsql-novice by date

Next:From: Marcin GilDate: 2004-01-27 10:41:03
Subject: unexpected eof
Previous:From: April CarvalhoDate: 2004-01-26 22:26:04
Subject: Another issue with pg_hba.conf file & dumpall

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