upgrading from 8.3 to 9.0

From: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: upgrading from 8.3 to 9.0
Date: 2011-11-17 11:40:36
Message-ID: 201111171140.45540.pdoria@netmadeira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-11-17 12:15:39 Re: How could I find the last modified procedure in the database?
Previous Message Yan Chunlu 2011-11-17 11:21:40 Re: how could duplicate pkey exist in psql?