Thread: postgresql 8.1.4 to 8.2.3

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,

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

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




--
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...




--
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!


> > > 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/

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