X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E6A025E37D0 for ; Thu, 12 Aug 2004 14:37:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71910-06 for ; Thu, 12 Aug 2004 17:37:48 +0000 (GMT) Received: from pop.sanbrunocable.com (pop.sanbrunocable.com [65.172.230.120]) by svr1.postgresql.org (Postfix) with ESMTP id 684705E46D2 for ; Thu, 12 Aug 2004 14:37:47 -0300 (ADT) Received: from oss4u.com (cpe-65-172-234-54.sanbrunocable.com [65.172.234.54]) by pop.sanbrunocable.com (8.11.6/8.11.6) with SMTP id i7CHacl15232 for ; Thu, 12 Aug 2004 10:36:40 -0700 Received: (qmail 3414 invoked from network); 12 Aug 2004 17:33:41 -0000 Received: from tiburon.oss4u.com (192.168.1.4) by gw.oss4u.com (192.168.1.1) with ESMTP; 12 Aug 2004 17:33:41 -0000 From: "Uwe C. Schroeder" Organization: OSS4U, LLC To: MPaule Torre , pgsql-admin@postgresql.org Subject: Re: redhat Ent3 et postegresql v7.4.3 Date: Thu, 12 Aug 2004 10:37:42 -0700 User-Agent: KMail/1.5.3 References: <5.0.2.1.2.20040812144528.00a76858@oceane.obs-vlfr.fr> In-Reply-To: <5.0.2.1.2.20040812144528.00a76858@oceane.obs-vlfr.fr> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200408121037.42940.uwe@oss4u.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/91 X-Sequence-Number: 14486 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Usually the RPM's work fine if they're build for that version of operating= =20 system. What I tend to do is not trust RPM to do the update correctly (particularly= =20 with postgres). So normally for an upgrade I: pg_dumpall > backup.dump shut down the postmaster make a backup copy of the old data directory (usually /var/lib/pgsql) do an rpm -e on all postgres and libpq packages. make sure /var/lib/pgsql is gone now install the new version from the rpms which should create a complete setup = and=20 also do the initdb for you. then restore the databases as postgres user with psql template1 < backup.dump do a vacuum full analyze verbose on all databases If that went all well you should have all your data back in place. You may= =20 have to fiddle with the postgres.conf and pg_hba.conf settings, because=20 removing the old postgres version will also erase those files. So you may= =20 want to keep a copy around for reference. Hope that helps UC On Thursday 12 August 2004 05:51 am, MPaule Torre wrote: > Hello everybody > > I have a red hat ent.3 operationg system. It has been delivered with > postgresql v7.3.6-1 > > I would like to use a new stable version : v7.4.3 > (server on linux and an ontother PC under windows 2000 to test and develop > > : with cygwin =3D> v7.4.3 or v7.4.2 available) > > Do you have any information about installing postgresql v7.4.3 rpm on this > redhat ent 3 operating system ? is it working well ? > Do I have to delete the oldest package (rpm too) ? > > > More thanks in advance > > > -------------------------------------------------------------------------= -- >---------------- TORRE MPaule > Observatoire Oceanologique -OOV > PROOF Base de Donn=E9es/Web > Quai de la Darse, BP8,Cas. Nicolas > 06238 VILLEFRANCHE sur MER > FRANCE > TEL (33)4.93.76.38.77 > FAX (33)4.93.76.38.73 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html - --=20 UC - -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFBG6rmjqGXBvRToM4RAusjAKCdWQUpxNd5aZsdavUhzw8h7hua1ACdH7t6 ojvcu1GTOIIC3VA/bkhYyMw=3D =3Deib4 -----END PGP SIGNATURE-----