Thread: 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
follow the instructions for implementing SSL in postgres
http://developer.postgresql.org/pgdocs/postgres/ssl-tcp.html
but 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.fi
To: pgsql-general@postgresql.org
Subject: [GENERAL] Howto disable login?
Date: Mon, 4 Aug 2008 20:19:42 +0300
Get Windows Live and get whatever you need, wherever you are. Start here.