On Wed, Aug 4, 2010 at 7:54 PM, andi astowo <andi.astowo@xxxxxxxxx> wrote: > At this oppurtinity we ask for your support to give us informations > regarding the bellow questionaires. First, how can we have our data of the > Postgre 7 under Red Hat Linux 7.2 to be used by the Postgre 8 under RHEL 5?. > Secondly, if above condition need additional software or driver or converter > Please advices how can we get is urgently. Thank you Very much. Well, that's a pretty big step up. Are you running 7.0, 7.1, 7.2, 7.3, or 7.4? Do you want to go to 8.0, 8.1, 8.2, 8.3 or 8.4? The normally recommended procedure is to bring up a new machine while leaving the old one up. So, you'll have a new machine running RHEL 5.latest with PostgreSQL 8.4.4. Your old machine would be running whatever old 7.x version you have. Then you would use pg_dump from the 8.4.4 postgresql install to dump the db from the 7.x db. Something like this: ssh centos5machine createdb mydb pg_dump -h rh72 mydb | psql mydb However, with that big of a gap of versions, you might run into some problems. Try it and let us know how far you can get. Note you may need to edit postgresql.conf for listen address, and pg_hba.conf, both on the old machine, to be able to connect. -- To understand recursion, one must first understand recursion. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
