Re: postgres upgrade for dummies? [solved]

2002-02-17 Thread Andreas Goesele
Andreas Goesele <[EMAIL PROTECTED]> writes: > "J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]> writes: > > > 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. > > Thi

Re: postgres upgrade for dummies?

2002-02-17 Thread Andreas Goesele
"J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]> writes: > 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 helped. Thanks. But now I have a new problem: The encodin

Re: postgres upgrade for dummies?

2002-02-17 Thread Oliver Elphick
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

Re: postgres upgrade for dummies?

2002-02-17 Thread J.H.M. Dassen \(Ray\)
On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote: > I now did a new try, again without any success. The automatic > upgrading process first looks promising but than ends with the > following error message: > You are now connected to database template1 as user user. > create database u

postgres upgrade for dummies?

2002-02-16 Thread Andreas Goesele
Hi, Short story: Is there an easy way to upgrade from postgresql 6.5 to 7.1? An easy to follow document explaining how to do it? Long story: Many tries, no success: I have a nicely working postgresql 6.5 on Debian woody. When I first upgraded to woody I too tried to upgrade to postgresql 7.1, bu