No title
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.
On 5 August 2010 11:54, andi astowo <andi.astowo@ymail.com> 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.
The documentation covers the upgrading procedure between major versions:
http://www.postgresql.org/docs/current/interactive/install-upgrading.html
If you have any specific questions, let us know.
On Wed, Aug 4, 2010 at 7:54 PM, andi astowo <andi.astowo@ymail.com> 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.
On Thu, Aug 5, 2010 at 10:00 PM, andi astowo <andi.astowo@ymail.com> wrote:
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?We are running at 7.1 and to go to 8.3.
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:We are sorry but our Postgre 8.3 is bundled with our new RHEL 5. So that how
can we change from 8.3 to 8.4.4? Thank You Very Much
You can run 8.3 and you should be just fine. If you run into issues
trying to dump 7.1 with the pg_dump from 8.3 and then restoring to
8.3, you might have to install an intermediate postgresql version
(7.4, 8.0, 8.1, or 8.2) and see if they can then be used to dump and
restore the 7.1 database. Best of luck, hollar if you get stuck.
Import Notes
Reply to msg id not found: 871520.59949.qm@web77114.mail.sg1.yahoo.com
Scott Marlowe <scott.marlowe@gmail.com> writes:
On Thu, Aug 5, 2010 at 10:00 PM, andi astowo <andi.astowo@ymail.com> wrote:
We are sorry but our Postgre 8.3 is bundled with our new RHEL 5.
Say what? Red Hat has never shipped Postgres 8.3 in RHEL.
Currently you can get 8.1 or 8.4 in RHEL-5 (and I'd definitely recommend
using 8.4).
regards, tom lane