Re: [Re: Password?]

On Jul 8, 2009, at 10:25 AM, Raymond O'Donnell wrote:

> On 08/07/2009 18:14, Steve Atkins wrote:
>> Typically the postgres operating system user is allowed to
>> connect to the database as the postgres database user without a
>> password.
>
> Is this really so? I don't think so - I think it depends on
> pg_hba.conf
> settings, just like any other user.

It does, yes. But most of the distributions I've seen tend to set it
up that way (as otherwise there's not really a good way to do
automated maintenance and backups, nor any easy way to
bootstrap the database).

So it's not hardwired that way, just typically set up that way (on
non-Windows OSes anyway - Windows has issues that likely
mean it's setup differently there).

Cheers,
Steve