Postgres Pro
Downloads
Home   >   mailing lists

upgrading from 8.3 to 9.0 - Mailing list pgsql-general

From Pedro Doria Meunier
Subject upgrading from 8.3 to 9.0
Date
Msg-id 201111171140.45540.pdoria@netmadeira.com
Whole thread Raw
Responses Re: upgrading from 8.3 to 9.0  (David Morton <davidmorton@xtra.co.nz>)
List pgsql-general
Tree view 
Hi,

I'm on the verge of upgrading a server (Fedora 8 ehehe) running postgresql 8.3

It also has postgis 1.3 installed.

Thinking of using pgadmin3 to perform the backup and then restore it after
I've upgraded the server to fedora 15/16 and thus upgrading postgresql to 9.0.

I seem to remember problems with restoring from a pgadmin's .backup file in the
past... :S

Any pitfalls I should be aware of?

Btw: it's a reasonably large DB with 30mil+ rows...

Already thankful for any insight,

--
Pedro Doria Meunier
GSM: +351 91 581 88 23
Skype: pdoriam
Attachment

pgsql-general by date:

Previous
From: Yan Chunlu
Date:
Subject: Re: how could duplicate pkey exist in psql?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: How could I find the last modified procedure in the database?