Re: How to start without password

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joel Burton" <joel(at)joelburton(dot)com>
Cc: "Uros Gruber" <uros(at)sir-mag(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to start without password
Date: 2002-06-08 20:10:44
Message-ID: 15220.1023567044@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Joel Burton" <joel(at)joelburton(dot)com> writes:
> PG server doesn't require a password to start up. How are you starting it up
> so that it requires a password?

The server does not care --- but pg_ctl tries to connect (via psql) in
order to see if the server is up yet. If you want to use password-based
authentication and not supply a password for "pg_ctl start", then you'll
need to specify the don't-wait-for-startup option to pg_ctl.

But my opinion is that password auth is a serious PITA; you are going to
have lots of trouble with backup scripts, not only startup, if you try
to run your installation like that. For local connections you should
consider whether you can't use ident authentication instead (assuming
you have a platform on which we support ident for Unix-socket
connections).

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-06-08 20:18:40 Re: HELP! Cannot access table!!!!
Previous Message cbbrowne 2002-06-08 16:57:45 Re: Alternatives to SQL ...