| From: | "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> |
|---|---|
| To: | "Teemu Juntunen" <teemu(dot)juntunen(at)e-ngine(dot)fi>, "PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Howto disable login? |
| Date: | 2008-08-04 18:18:42 |
| Message-ID: | 1A6E6D554222284AB25ABE3229A9276201A195E3@nrtexcus702.int.asurion.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2008-08-04 18:31:30 | Re: pgsql-general@postgresql.org. |
| Previous Message | Rob Adams | 2008-08-04 18:17:09 | Re: recovery via base + WAL replay failure |