On Wednesday 27 July 2005 11:41 am, Jonathan Villa wrote: > I've been googling a little bit and appears that 7.1 pretty old. Very. > What steps are advised to upgrade from 7.1 to 7.4? Unless there is some reason you really need 7.4, just go straight to 8.0.3. Instructions start on page 230 of the PG8 documentation. Basically you do a pg_dumpall to backup your old database (make sure it is not being updated), stop the old server, install the new server, restore your data: http://www.postgresql.org/docs/8.0/interactive/install-upgrading.html Cheers, Steve ---------------------------(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