Andrew,
If you're moving between major versions, a dump/restore is necessary. The
proper procedure is:
1) pg_dump the old database by using the new version of pg_dump (8.1.x)
against the old db server (7.4.9 in your case)
2) stop the old database server (and possibly move/rename the old data dir)
3) initdb the new database server
4) edit postgresql.conf, etc
5) start the new database server
6) pg_restore the old database into the newly initialized data directory
So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use
the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server.
On Wed, 17 Jan 2007, Andrew Edson wrote:
> I was requested to load data (a full copy of the db in question) from one postgres database into another (empty) db
onanother system. Both of these systems are running SuSE 9.2 Linux, for the record. It turned out that the two
systemswere running different versions of postgres; the first system (the one that needed the data) was running version
7.4.9,while the other system was (and is) running 8.1.3. I copied the 8.1.3 installation packet over to the first
computer,and tried to install it.
>
> Originally, when starting the (supposed) 8.1.3 pg_ctl, I got an error about tcpip_socket. A search on the postgres
sitelead me to believe I could remedy the problem by uninstalling the older version of postgres. I proceded in the
followingorder: swap to the installation directory for 8.1.3, make uninstall, make distclean, swap to the 7.4.9
installationdirectory, make uninstall, make distclean, swap back to 8.1.3, configure, make, make install. I still got
theerror, though. I finally found it mentioned in the postgres.conf file, and commented out the line. Next, I was
toldthat my data files were initialized in 7.4, despite my earlier efforts, and after renaming the old folder, I went
backand repeated the steps of (8.1.3)make uninstall, make distclean, configure, make, make install. However, there is
nodata directory in the base postgres directory now, only the older renamed one.
>
> If anyone can tell me what to do to get this system back up and running, I would appreciate it greatly. If more
informationis needed, I will be happy to supply as much as I can.
>
> Thank you for your consideration.
>
>
> ---------------------------------
> Access over 1 million songs - Yahoo! Music Unlimited.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954