Re: Why pg_hba not in table?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Why pg_hba not in table?
Date: 2006-02-07 21:37:42
Message-ID: 20060207213742.GA10654@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 07, 2006 at 03:24:01PM -0500, Tom Lane wrote:
> One other small point is the bootstrapping problem: if you can't get
> into the database to modify the config table, you've got trouble.

Hence MySQL's --skip-grant-tables option; if you've locked yourself
out then you have to disable security entirely to get back in and
fix the problem. With a configuration that you can edit from outside
the database, you can usually get back in without having to punch
as big a hole.

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-02-07 21:39:22 Re: Why pg_hba not in table?
Previous Message John D. Burger 2006-02-07 21:27:31 Re: Primary keys for companies and people