postgresql 8.1.4 to 8.2.3

thanks for the info.
anyway i was thinking to do that, but i wanted to be sure.

On 4/14/07, Anton Melser <melser.anton@gmail.com> wrote:

On 14/04/07, Alain Roger <raf.news@gmail.com> wrote:

Hi,

My web host upgrade his postgreSQL version to 8.2.3 so i would like to

do

the same on my local computer where i develop.
Is there something particular to do ?
or can I just run the exe file (on windows) without doing a complete

backup

(pgdump) before ?

thanks a lot,

RTFM :-). Between major versions (8.1 -> 8.2) you DO need to dump and
reload. So do that...
Cheers
Anton

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5

On Apr 14, 2007, at 11:38 AM, Alain Roger wrote:

thanks for the info.
anyway i was thinking to do that, but i wanted to be sure.

On 4/14/07, Anton Melser < melser.anton@gmail.com> wrote:On
14/04/07, Alain Roger < raf.news@gmail.com> wrote:

Hi,

My web host upgrade his postgreSQL version to 8.2.3 so i would

like to do

the same on my local computer where i develop.
Is there something particular to do ?
or can I just run the exe file (on windows) without doing a

complete backup

(pgdump) before ?

thanks a lot,

RTFM :-). Between major versions (8.1 -> 8.2) you DO need to dump and
reload. So do that...

Actually, this isn't strictly true: http://pgfoundry.org/projects/pg-
migrator/

erik jones <erik@myemma.com>
software developer
615-296-0838
emma(r)

After clicking on your link i got "invalid project" page :-(
and the whole page is empty...

On 4/14/07, Erik Jones <erik@myemma.com> wrote:

On Apr 14, 2007, at 11:38 AM, Alain Roger wrote:

thanks for the info.
anyway i was thinking to do that, but i wanted to be sure.

On 4/14/07, Anton Melser < melser.anton@gmail.com> wrote:On
14/04/07, Alain Roger < raf.news@gmail.com> wrote:

Hi,

My web host upgrade his postgreSQL version to 8.2.3 so i would

like to do

the same on my local computer where i develop.
Is there something particular to do ?
or can I just run the exe file (on windows) without doing a

complete backup

(pgdump) before ?

thanks a lot,

RTFM :-). Between major versions (8.1 -> 8.2) you DO need to dump and
reload. So do that...

Actually, this isn't strictly true: http://pgfoundry.org/projects/pg-
migrator/

erik jones <erik@myemma.com>
software developer
615-296-0838
emma(r)

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5

On 14/04/07, Alain Roger <raf.news@gmail.com> wrote:

After clicking on your link i got "invalid project" page :-(
and the whole page is empty...

Ouch Alain...
Try
http://pgfoundry.org/projects/pg-migrator/
:-)
But ask a single postgres oldskool cat (which I am patently not!) and
you will get exactly the same answer "Do you value your data?". This
is for people who want to tinker, or who simply can't dump/reload.
Until it gets included in postgres core of course!

On Sat, 2007-04-14 at 22:01 +0200, Anton Melser wrote:

On 14/04/07, Alain Roger <raf.news@gmail.com> wrote:

After clicking on your link i got "invalid project" page :-(
and the whole page is empty...

Ouch Alain...
Try
http://pgfoundry.org/projects/pg-migrator/
:-)
But ask a single postgres oldskool cat (which I am patently not!) and
you will get exactly the same answer "Do you value your data?". This
is for people who want to tinker, or who simply can't dump/reload.
Until it gets included in postgres core of course!

RTFM :-). Between major versions (8.1 -> 8.2) you DO need to dump and
reload. So do that...

Actually, this isn't strictly true:

http://pgfoundry.org/projects/pg-

migrator/

So from the docs of pg-migrator:
"PostgreSQL version 8.2 changes the layout for values of type INET and
CIDR" - thus any tables with columns of those data types would have to
be dump/restored.

My questions would be a) are there any other data types that have had
changes made to their on-disk representation? and b) have there been any
changes made to the table infrastucture layout from 8.1.x to 8.2 (that
would cause pg-migrator not to work) ?

Sven