X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BC5A39FB316 for ; Sun, 30 Jul 2006 18:33:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 65949-04 for ; Sun, 30 Jul 2006 18:33:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.195]) by postgresql.org (Postfix) with ESMTP id ED7BE9FB310 for ; Sun, 30 Jul 2006 18:33:13 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id i11so124551nzi for ; Sun, 30 Jul 2006 14:33:12 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=VgeOsyoyZV0GhygcOITws/gGG6D7hjMGoCH3HmBGsjP3TPUTk5ahqrnB6cY/0VaZnBiw2Zl7kstjKv7ae1M6aGyuTg0NJYSuYTqglHH8rx7D4g0GDPX1tJCF8AzNqPR27g8bbjMGs+BddZtSgwmZfWRCo/O0jVt1gerQqVgLDoU= Received: by 10.65.83.18 with SMTP id k18mr2405420qbl; Sun, 30 Jul 2006 14:33:12 -0700 (PDT) Received: from ?10.1.1.22? ( [203.217.18.65]) by mx.gmail.com with ESMTP id m1sm3203382nzf.2006.07.30.14.33.10; Sun, 30 Jul 2006 14:33:12 -0700 (PDT) Message-ID: <44CD2595.6020304@gmail.com> Date: Mon, 31 Jul 2006 07:33:09 +1000 From: Chris User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Richmond Dyes CC: pgsql-php@postgresql.org Subject: Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 References: <44C8E75A.3030807@monroehosp.org> <44C94FEE.5030205@gmail.com> <8fb205ea0607272156g23c49839idbc9c02917c75b35@mail.gmail.com> <44C9B92C.4070509@gmail.com> <8fb205ea0607280830g2791587ej92175d4903c760fe@mail.gmail.com> In-Reply-To: <8fb205ea0607280830g2791587ej92175d4903c760fe@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.116 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/15 X-Sequence-Number: 3569 Richmond Dyes wrote: > That's the problem. There are no errors persay. That's why I am > looking for basic instructions on how to get that upgrade done with > rpm's from someone who has done it. Assuming you have downloaded the rpm's. Don't know if CentOS has a "yum" or "apt" type program that will handle that for you. What version of postgresql are you upgrading from? If it's from 8.1.X to 8.1.Y then this will work: Take a database dump as a backup. Stop postgresql: /etc/init.d/postgresql stop update the rpms: rpm -Fvh postgresql-* Start postgresql: /etc/init.d/postgresql start If you are doing from 8.0.X to 8.1.Y then you need to: Take a database dump as a backup. Copy or zip your existing files (/var/lib/pgsql/data) somewhere safe. Stop postgresql: /etc/init.d/postgresql stop update the rpms: rpm -Fvh postgresql-* rm -rf /var/lib/pgsql/data or where-ever your postgresql data files are. Of course your backup is somewhere else! Start postgresql: /etc/init.d/postgresql start (that should handle doing an 'initdb') import your backup: su - postgres psql < /path/to/your/database.dump.file If you have made any changes to the postgresql.conf file or pg_hba.conf file then you'll need to copy those back from your backup as well. I'm sure someone will correct me if I have missed any steps. -- Postgresql & php tutorials http://www.designmagick.com/