pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
7+ messages / 4 participants
[nested] [flat]

* How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
@ 2006-07-27 16:18 Richmond Dyes <rdyes@monroehosp.org>
  2006-07-27 23:44 ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Richmond Dyes @ 2006-07-27 16:18 UTC (permalink / raw)
  To: pgsql-php

I am having a hard time upgrading my Centos 4.2 server to use PHP 5.1 
and Postgresql 8.1.  Has anyone done this?




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
  2006-07-27 16:18 How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rdyes@monroehosp.org>
@ 2006-07-27 23:44 ` Chris <dmagick@gmail.com>
  2006-07-28 04:56   ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Chris @ 2006-07-27 23:44 UTC (permalink / raw)
  To: Richmond.Dyes@monroehosp.org; +Cc: pgsql-php

Richmond Dyes wrote:
> I am having a hard time upgrading my Centos 4.2 server to use PHP 5.1 
> and Postgresql 8.1.  Has anyone done this?

That's based on redhat or fedora isn't it (can't remember which)...

Are you using the packages or compiling your own source?

What problems are you having exactly?

-- 
Postgresql & php tutorials
http://www.designmagick.com/



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
  2006-07-27 16:18 How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rdyes@monroehosp.org>
  2006-07-27 23:44 ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
@ 2006-07-28 04:56   ` Richmond Dyes <rhdyes@gmail.com>
  2006-07-28 07:13     ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Richmond Dyes @ 2006-07-28 04:56 UTC (permalink / raw)
  To: Chris <dmagick@gmail.com>; +Cc: pgsql-php

On 7/27/06, Chris <dmagick@gmail.com> wrote:
>
> Richmond Dyes wrote:
> > I am having a hard time upgrading my Centos 4.2 server to use PHP 5.1
> > and Postgresql 8.1.  Has anyone done this?
>
> That's based on redhat or fedora isn't it (can't remember which)...
>
> Are you using the packages or compiling your own source?
>
> What problems are you having exactly?
> It is based on  Redhat AS4. I tried to upgrade it using the rpms and I
> can't get the php to upgrade the server.  So I wiped it and am starting all
> over again. I would rather use rpms
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
  2006-07-27 16:18 How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rdyes@monroehosp.org>
  2006-07-27 23:44 ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  2006-07-28 04:56   ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
@ 2006-07-28 07:13     ` Chris <dmagick@gmail.com>
  2006-07-28 15:30       ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
  0 siblings, 1 reply; 7+ messages in thread

From: Chris @ 2006-07-28 07:13 UTC (permalink / raw)
  To: Richmond Dyes <rhdyes@gmail.com>; +Cc: pgsql-php

Richmond Dyes wrote:
> 
> 
> On 7/27/06, *Chris* <dmagick@gmail.com <mailto:dmagick@gmail.com>> wrote:
> 
>     Richmond Dyes wrote:
>      > I am having a hard time upgrading my Centos 4.2 server to use PHP 5.1
>      > and Postgresql 8.1.  Has anyone done this?
> 
>     That's based on redhat or fedora isn't it (can't remember which)...
> 
>     Are you using the packages or compiling your own source?
> 
>     What problems are you having exactly?
>     It is based on  Redhat AS4. I tried to upgrade it using the rpms and
>     I can't get the php to upgrade the server.  So I wiped it and am
>     starting all over again. I would rather use rpms

and the errors are.... ??

-- 
Postgresql & php tutorials
http://www.designmagick.com/





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
  2006-07-27 16:18 How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rdyes@monroehosp.org>
  2006-07-27 23:44 ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  2006-07-28 04:56   ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
  2006-07-28 07:13     ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
@ 2006-07-28 15:30       ` Richmond Dyes <rhdyes@gmail.com>
  2006-07-30 21:33         ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  2006-07-31 07:17         ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Devrim GUNDUZ <devrim@commandprompt.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Richmond Dyes @ 2006-07-28 15:30 UTC (permalink / raw)
  To: Chris <dmagick@gmail.com>; +Cc: pgsql-php

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.

On 7/28/06, Chris <dmagick@gmail.com> wrote:
>
> Richmond Dyes wrote:
> >
> >
> > On 7/27/06, *Chris* <dmagick@gmail.com <mailto:dmagick@gmail.com>>
> wrote:
> >
> >     Richmond Dyes wrote:
> >      > I am having a hard time upgrading my Centos 4.2 server to use PHP
> 5.1
> >      > and Postgresql 8.1.  Has anyone done this?
> >
> >     That's based on redhat or fedora isn't it (can't remember which)...
> >
> >     Are you using the packages or compiling your own source?
> >
> >     What problems are you having exactly?
> >     It is based on  Redhat AS4. I tried to upgrade it using the rpms and
> >     I can't get the php to upgrade the server.  So I wiped it and am
> >     starting all over again. I would rather use rpms
>
> and the errors are.... ??
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
  2006-07-27 16:18 How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rdyes@monroehosp.org>
  2006-07-27 23:44 ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  2006-07-28 04:56   ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
  2006-07-28 07:13     ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  2006-07-28 15:30       ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
@ 2006-07-30 21:33         ` Chris <dmagick@gmail.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Chris @ 2006-07-30 21:33 UTC (permalink / raw)
  To: Richmond Dyes <rhdyes@gmail.com>; +Cc: pgsql-php

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/



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1
  2006-07-27 16:18 How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rdyes@monroehosp.org>
  2006-07-27 23:44 ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  2006-07-28 04:56   ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
  2006-07-28 07:13     ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Chris <dmagick@gmail.com>
  2006-07-28 15:30       ` Re: How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rhdyes@gmail.com>
@ 2006-07-31 07:17         ` Devrim GUNDUZ <devrim@commandprompt.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Devrim GUNDUZ @ 2006-07-31 07:17 UTC (permalink / raw)
  To: Richmond Dyes <rhdyes@gmail.com>; +Cc: pgsql-php

Hi,

On Fri, 2006-07-28 at 11:30 -0400, 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.

No way actually. PHP will depend on Apache, Apache will depend on some
other binaries... So an RPM upgrade will either likely break many
things, or take too much time to rebuild each RPM.

So, the easy way is to install PHP5 from sources or use Fedora Core 5. I
don't know RHEL 5 (so CentOS 5) schedule yet, but it will have PHP 5.

To compile PHP5 from sources, first install httpd-devel rpm.

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Attachments:

  signature.asc (application/pgp-signature, 188B) download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2006-07-31 07:17 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-27 16:18 How to upgrade Centos 4.3 to PHP 5.1 and Postgresql 8.1 Richmond Dyes <rdyes@monroehosp.org>
2006-07-27 23:44 ` Chris <dmagick@gmail.com>
2006-07-28 04:56   ` Richmond Dyes <rhdyes@gmail.com>
2006-07-28 07:13     ` Chris <dmagick@gmail.com>
2006-07-28 15:30       ` Richmond Dyes <rhdyes@gmail.com>
2006-07-30 21:33         ` Chris <dmagick@gmail.com>
2006-07-31 07:17         ` Devrim GUNDUZ <devrim@commandprompt.com>

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