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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
