[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: postgres upgrade for dummies?



On Sun, 2002-02-17 at 14:20, J.H.M. Dassen (Ray) wrote:
> On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote:
> > So I did read README.Debian.migration.gz and then run postgresql-dump
> > with the options in the README. This is what I got:
> > 
> > Stopping and restarting the postmaster
> > /usr/lib/postgresql/dumpall/6.5/postmaster -D /var/lib/postgres/data  -p 5431 -o -d0
> > Dumping the database to db.out
> > process_hba_record: invalid syntax in pg_hba.conf file
> 
> Switch back to the pg_hba.conf file you used with 6.5. 7.1 has a new
> authentication method "peer" which 6.5 doesn't understand and which 7.1's
> default configuration employs IIRC.


This particular issue will go away in 7.2.  The peer authentication
method (checking ownership of a Unix socket connection) has been adopted
upstream but is now called ident, although its method of operation is
actually different from TCP/IP ident authentication.

So, in 7.2, "peer" will again be invalid.

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

     "Surely he took up our infirmities and carried our 
      sorrows; yet we considered him stricken by God,
      smitten by him, and afflicted. But he was pierced for
      our transgressions, he was crushed for our iniquities;
      the punishment that brought us peace was upon him, and
      by his wounds we are healed."        Isaiah 53:4,5 



Reply to: