Howto disable login?

You can using the pg_hba.conf file. Set the non-local accounts to
reject when you start the database. After you finish your scripts,
change the pg_hba.conf file to enable logins and then use pg_ctl reload
to enable the new pg_hba.conf file.

host all all 0.0.0.0/0 reject

And then change it to:

host all all 0.0.0.0/0 md5

Jon

________________________________

From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Teemu Juntunen
Sent: Monday, August 04, 2008 12:20 PM
To: PostgreSQL
Subject: [GENERAL] Howto disable login?

Hi all,

is there some way to disable and enable login in PostgreSQL? I would
like to have only local login enabled when the server starts and make
some checks before allowing general login.

Best regards and thanks,

Teemu Juntunen

Teemufollow the instructions for implementing SSL in postgreshttp://developer.postgresql.org/pgdocs/postgres/ssl-tcp.htmlbut you'll have to start by compiling in the SSL module into postgres build
http://developer.postgresql.org/pgdocs/postgres/install-procedure.html./configure --with-openssl
kiittääMartin______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.

From: teemu.juntunen@e-ngine.fiTo: pgsql-general@postgresql.orgSubject: [GENERAL] Howto disable login?Date: Mon, 4 Aug 2008 20:19:42 +0300

Hi all,

is there some way to disable and enable login in PostgreSQL? I would like to have only local login enabled when the server starts and make some checks before allowing general login.

Best regards and thanks,
Teemu Juntunen
_________________________________________________________________
Get Windows Live and get whatever you need, wherever you are. Start here.
http://www.windowslive.com/default.html?ocid=TXT_TAGLM_WL_Home_082008