Search Postgresql Archives

Re: Upgrade db format without older version of PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux