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?
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
------=_Part_2245_26416358.1154062605614
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On 7/27/06, Chris
>
> 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
>
------=_Part_2245_26416358.1154062605614
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On 7/27/06, Chris <> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
------=_Part_2245_26416358.1154062605614--
Richmond Dyes wrote:
>
>
> On 7/27/06, *Chris*
>
> 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/
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
------=_Part_15492_15190529.1154100639222
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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
>
> Richmond Dyes wrote:
> >
> >
> > On 7/27/06, *Chris*
> 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/
>
>
>
------=_Part_15492_15190529.1154100639222
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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 <> wrote:Richmond Dyes wrote:
>
>
> On 7/27/06, *Chris* <>> 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
------=_Part_15492_15190529.1154100639222--
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/
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
--=-yusPyQkYYXxeYqw8TFi+
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
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,
--=20
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/
--=-yusPyQkYYXxeYqw8TFi+
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (GNU/Linux)
iD8DBQBEza50pme12CBXnxERApAxAJ0WYb0haGDnd89FAo88AJBewUPK1wCg qPZF
SMCRaAA9p38rxQVw2S1uM1M=
=N9tG
-----END PGP SIGNATURE-----
--=-yusPyQkYYXxeYqw8TFi+--