Re: How to start without password

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Uros Gruber
> Sent: Saturday, June 08, 2002 12:39 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] How to start without password
> Importance: High
>
>
> Hi!
>
> I want to make very secure postgresql and not allow
> connections witout passwords. I also remove all trusts
> from pg_hba.conf.
>
> Whe i start server i have to type my password. I want to know
> how can i then start at boot. I can't try because I can't
> boot whenever i want. I just want to be sure that if server
> crash would start postgre at boot time without that pass.

PG server doesn't require a password to start up. How are you starting it up
so that it requires a password?

Normally, in your startup script (which presumably run as root), you'll have
a line like:

su -c postgres "/usr/local/pgsql/bin/pg_ctl start"

to run pg_start as the user postgres. Since root can su to any user, no
password is required.

This has nothing to do with whether passwords are required to *connect* to
PG; you're right, this is controlled by pg_hba.conf.

- J.