Postgres Pro
Downloads
Home   >   mailing lists

Re: Howto disable login? - Mailing list pgsql-general

From Roberts, Jon
Subject Re: Howto disable login?
Date
Msg-id 1A6E6D554222284AB25ABE3229A9276201A195E3@nrtexcus702.int.asurion.com
Whole thread Raw
In response to Howto disable login?  ("Teemu Juntunen" <teemu.juntunen@e-ngine.fi>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Rob Adams
Date:
Subject: Re: recovery via base + WAL replay failure
Next
From: Robert Treat
Date:
Subject: Re: pgsql-general@postgresql.org.