Re: bug found in 8.3 beta 3.

Hi,

Le Monday 17 December 2007 19:05:36 chris wood, vous avez écrit :
> Hi, I found this bug? In beta 3. I am not a Linux guru so installing any
> betas in Debian is very painful for me. Perhaps you could check to see if
> it is still there in beta 4??

The experimental sources of debian already provides postgresql-8.3 beta4, so
installing it is as easy as adding experimental to your testing server
sources.list, or if you want to take no risk of upgrading other experimental
packages, adding the deb-src experimental source and backporting:
apt-get update
apt-get build-dep postgresql-common postgresql-client-common postgresql-8.3
apt-get source -b postgresql-common postgresql-client-common postgresql-8.3
dpkg -i ...

http://packages.debian.org/postgresql-8.3

Install at least the -common packages, libpq and the wanted components.
Those -common packages contain the infamous debian wrappers which makes debian
differs from other PostgreSQL installations, but allows to easily use several
version at a time, including binary choice without messing with PATH manually
(adding --cluster 8.3/main to "official" options --- version/clustername).

Please note that 8.3b2 to 8.3b4 needs an initdb, and the debian packaging has
no support for beta to beta upgrading. You'll certainly want to do it
manually:
pg_dumpall > backup.file
apt-get remove postgresql-8.3
rm -rf $PGDATA/* (defaults to /var/lib/postgresql/8.3/main)
<install new version, either apt-get install or dpkg -i>
psql -f backup.file

Hope this helps,
--
dim