Re: Have problems with 7.1 -> 7.2 upgrade

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: andrew(dot)clark(at)sge(dot)net
Cc: Darren Ferguson <darren(at)crystalballinc(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Have problems with 7.1 -> 7.2 upgrade
Date: 2002-03-07 12:08:21
Message-ID: 1015502902.21922.196.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2002-03-07 at 00:32, andrew(dot)clark(at)sge(dot)net wrote:
>
> Don't worry, fixed it... Copied /etc/postgresql/pg_hba.conf.dpkg-old over
> /etc/postgresql/pg_hba.conf and everything started working... I'm a bit
> confused as to why though, seeing as they both contain the same three
> lines...

They must in fact have been different!

The Debian release of 7.1 used 'peer' authentication, which has now been
adopted into mainstream PostgreSQL as 'ident' authentication on Unix
sockets. Therefore 'peer' is no longer valid in the Debian package and
the new distributed pg_hba.conf has changed it to 'ident'. However,
since this is a conffile, package installation will not touch it without
permission.

The postinst package installation script should have offered to change
it for you. Is there a bug there?

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"Go ye therefore, and teach all nations, baptizing them
in the name of the Father, and of the Son, and of the
Holy Ghost; Teaching them to observe all things
whatsoever I have commanded you; and, lo, I am with
you alway, even unto the end of the world. Amen."
Matthew 28:19,20

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Anto 2002-03-07 12:26:28 "select myfunc(fields) from my table" inside plpgslq proc
Previous Message Oliver Elphick 2002-03-07 12:03:11 Re: Have problems with 7.1 -> 7.2 upgrade