Re: PG_DUMP not working

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