pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris <dmagick@gmail.com>
To: Richmond Dyes <rhdyes@gmail.com>
Cc: pgsql-php@postgresql.org
Subject: Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
Date: Mon, 31 Jul 2006 07:33:09 +1000
Message-ID: <44CD2595.6020304@gmail.com> (raw)
In-Reply-To: <8fb205ea0607280830g2791587ej92175d4903c760fe@mail.gmail.com>
References: <44C8E75A.3030807@monroehosp.org>
	<44C94FEE.5030205@gmail.com>
	<8fb205ea0607272156g23c49839idbc9c02917c75b35@mail.gmail.com>
	<44C9B92C.4070509@gmail.com>
	<8fb205ea0607280830g2791587ej92175d4903c760fe@mail.gmail.com>

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/



view thread (7+ messages)  latest in thread

Message-ID: <44CD2595.6020304@gmail.com>
Permalink:  ../44CD2595.6020304@gmail.com/
Also on:    postgresql.org/message-id/44CD2595.6020304@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: dmagick@gmail.com, rhdyes@gmail.com
  Subject: Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
  In-Reply-To: <44CD2595.6020304@gmail.com>
  References: <44C8E75A.3030807@monroehosp.org> <44C94FEE.5030205@gmail.com> <8fb205ea0607272156g23c49839idbc9c02917c75b35@mail.gmail.com> <44C9B92C.4070509@gmail.com> <8fb205ea0607280830g2791587ej92175d4903c760fe@mail.gmail.com> <44CD2595.6020304@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox