Search Postgresql Archives

Re: Howto disable login?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux