X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6C0FDDA48D for ; Wed, 19 Oct 2005 13:20:13 -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 58372-04 for ; Wed, 19 Oct 2005 16:20:10 +0000 (GMT) Received: from netbox.unitech.com.ar (unknown [200.32.92.34]) by svr1.postgresql.org (Postfix) with ESMTP id 0B7D5DA508 for ; Wed, 19 Oct 2005 13:20:09 -0300 (ADT) Received: from yahoo.com.ar (dariop.unitech.com.ar [192.168.1.237]) by netbox.unitech.com.ar (8.11.6/8.11.6) with ESMTP id j9JHHrp11688; Wed, 19 Oct 2005 14:17:54 -0300 Received: from 127.0.0.1 (AVG SMTP 7.0.344 [267.12.4]); Wed, 19 Oct 2005 13:22:31 -0300 From: "Dario" To: "FM" , "Mailing List Postgres-Admin" Subject: Re: install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ? Date: Wed, 19 Oct 2005 13:22:31 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <43566A7D.9010001@lexum.umontreal.ca> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.056 required=5 tests=[AWL=0.006, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/220 X-Sequence-Number: 19292 The new version will update your postgresql packages. It shouldn't wipe = your data files, since /etc/init.d/postgresql script checks if there are = data in the specified directory. Then you must erase those postgresql = (rpm -qa|grep postgres will list packages installed), and install yours. But, if new subversion is the same (example 7._4_.8 and 7._4_.9 but it's = and unchecked and probably not real example), the script could run and = the engine will run (it won't delete your files). I would perform a backup anyway. -----Mensaje original----- De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]En nombre de FM Enviado el: mi=C3=A9rcoles, 19 de octubre de 2005 12:47 Para: Mailing List Postgres-Admin Asunto: [ADMIN] install new version of Redhat without deleting /var/lib/pgsql ? Is it enough ? Hello erverybody, I need to install a new version of Redhat on my server. On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on=20 its own partition). Can I "just" install the new version of Redhat, reinstall the same=20 version of Postgresql (7.4.8) ? I'll do a pgdump all just in case Thanks ! ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq