Dan99 escribió:
> > Update your pgsql. 7.4.2 is old in two ways. the 7.4 branch is
> > pretty old. plan an upgrade as soon as you can get this backup to
> > work. Secondly, pg 7.4 is up to a number near 20 now, i.e. 7.4.18.
> > There are over two years of bug fixes you're missing, and one of them
> > could well be the solution to your problem.
> >
> > Upgrading from 7.4 to 8.2 requires a dump and reload, but 7.4.2 to
> > 7.4.18 is just an rpm -Uvh or apt-get update away
>
> I currently am running apache + pgsql 7.4.2 + php 4.2. Do you think I
> would have any troubles when upgrading to pgsql 8.2 ~ ie. existing php
> queries not working?
There could be. However, upgrading to 7.4.18 (?) should work without
issues, so short-term it is a very good idea to upgrade to that. Then
you can plan an upgrade to 8.2 or 8.3 in a longer-term future.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support