Re: Upgrade db format without older version of PostgreSQL

Devrim GÜNDÜZ wrote:
> Also, however, I bet 7.2 cannot be compiled on Fedora 11. The oldest PG
> version that I could build on Fedora 11 was 8.0, IIRC. Apart from these,
> dump/restore from 7.2 to 8.3 will probably not work.
>

oh, thats going to be fun. fyi, the 7.2 sources are here...
ftp://ftp-archives.postgresql.org/pub/source/v7.2.8/postgresql-7.2.8.tar.bz2

I'm giving a try building on centos 5 (rhel5) just for the fun of it.
this uses gcc 4.1.2 by default. it also has a gcc 3.4.6 -compat
version I could try if this fails. lotsa compile warnings so far.

this actually seems to have worked... as user 'pierce'...

$ ./configure --prefix=/home/pierce/pg72 --with-pgport=5433
$ make
$ make install
$ /home/pierce/pg72/bin/initdb -D /home/pierce/pg72/data
$ vi /home/pierce/pg72/data/postgresql.conf ## change port=5433
$ /home/pierce/pg72/bin/pg_ctl -D /home/pierce/pg72/data -l logfile
start
$ /home/pierce/pg72/bin/psql -U pierce -p 5433 template1
Welcome to psql, the PostgreSQL interactive terminal.

template1=# \l
List of databases
Name | Owner
-----------+--------
template0 | pierce
template1 | pierce
(2 rows)

template1=# select version();

version

----------------------------------------------------------------------------------------------------
PostgreSQL 7.2.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20080704 (Red Hat 4.1.2-44)
(1 row)

template1=# \q

like, holy karap.

> Apart from these, dump/restore from 7.2 to 8.3 will probably not work.

thats going to be a bigger problem. dunno how you'd get around that,
or how many intermediate versions youd have to go through. wild guess
says, 7.2 -> 7.4 -> 8.3 may work.