Re: How to start without password
От | Joel Burton |
---|---|
Тема | Re: How to start without password |
Дата | |
Msg-id | 000801c20f0d$9bf632b0$63eebed1@jburtonsat3005 обсуждение исходный текст |
Ответ на | How to start without password (Uros Gruber <uros@sir-mag.com>) |
Ответы |
Re: How to start without password
|
Список | pgsql-general |
> -----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.
В списке pgsql-general по дате отправления: