Re: Have problems with 7.1 -> 7.2 upgrade

> They must in fact have been different!
>


They are, as you pointed out below.



> 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?


Only that 7.1 wants peer and 7.2 doesn't.  Perhaps the postgresql-dump
script show detect the change from 7.1 to 7.2 and generate a temporary
pg_hba.conf file with trust set, dump the db, reimport the db and then
restore the pg_hba.conf file?


I did eventually get this to work, it just took a bit longer than expected
(which was exaserbated by running out of space on the device I was dumping
to)


Thanks for you help,





AJFC.