Re: db security; user identification

On Tuesday 27 January 2004 13:30, Marcin Gil wrote:
> I have switched identification method from 'trust' to 'md5'
> for all local requests, ie:
>
> - local all all trust
> + local all all md5

try something like (untested)

- local all all trust
+ local all postgres 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.

the startup script should su to the user postgres and then start the
postmaster.

> 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.

- Martin -
--
"If we don't succeed, we run the risk of failure."
--Bill Clinton, President