[vwnc] Store & PostgreSQL

Hi all
I've been using PostgreSQL (locally on WinXP) together with Store. Currently my PostgreSQL is at
version 8.2.3. I now need to install PostgreSQL on another computer and I've been contemplating to
install the latest version of PostgreSQL (8.3.3). To be in sync I'd need to upgrade the older
installation. Any hints, catches or tips from the "VW point of view" (i.e. anything else than what
"www.postgresql.org" says in their release notes)???

Thanks in advance
Mike

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

I've done a number of upgrades and standard dump and restore always worked well.

Cheers!

-Boris (via BlackBerry)

----- Original Message -----
From: [hidden email] <[hidden email]>
To: [hidden email] <[hidden email]>
Sent: Wed Jun 18 06:36:57 2008
Subject: [vwnc] Store & PostgreSQL

Hi all
I've been using PostgreSQL (locally on WinXP) together with Store. Currently my PostgreSQL is at
version 8.2.3. I now need to install PostgreSQL on another computer and I've been contemplating to
install the latest version of PostgreSQL (8.3.3). To be in sync I'd need to upgrade the older
installation. Any hints, catches or tips from the "VW point of view" (i.e. anything else than what
"www.postgresql.org" says in their release notes)???

Thanks in advance
Mike

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

On 18.06.2008 16:05, Boris Popov wrote:
> I've done a number of upgrades and standard dump and restore always
> worked well.
>
> Cheers!
>
> -Boris (via BlackBerry)

Thanks! Well, then I'll just upgrade and give it a try... still got the other computer, just in case ;)

Mike

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

I've got to say that I had a bit of trouble with dump and restore in the past. Maybe it's a question of using the right options or something. But invariably when I restored a repository from a dump, the new one was functional but significantly slower for some reason. No amount of vacuuming seemed to help. In the end I always deleted the restored one and used a store replicator to restore the repository from another one (I run two replicated repositories here). It takes much longer to replicate an entire repository, but the result was as snappy as before. I never figured out what it was. I still back up my repository with pgdump, because the restore is functional after all, but for upgrades I always end up replicating.

HTH,

Martin

Boris Popov wrote:
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

I would suggest you do the following, install the latest version on the
new computer, connect it to the old and perform dump using the latest
version of PostgreSQL binaries (pg_dump_all or pg_dump, use -i option).
  Then import the database(s)into the new version...

I do it often when I do replicate the store from Unix server to my WinXp
laptop, causally my laptop has newer version of postgres installed.

Mike Bielser wrote: _______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

On 18.06.2008 17:20, Martin Kobetic wrote:
 > I've got to say that I had a bit of trouble with dump and restore in the
 > past. Maybe it's a question of using the right options or something.

I've used dump/restore between Mac OS X and WinXP and there (at least for me) it DID matter what
options I used...

 > But invariably when I restored a repository from a dump, the new one was
 > functional but significantly slower for some reason. No amount of
 > vacuuming seemed to help. In the end I always deleted the restored one
 > and used a store replicator to restore the repository from another one
 > (I run two replicated repositories here).

I'll look into this then, so far I've never used it

 > It takes much longer to replicate an entire repository, but the result
 > was as snappy as before. I never figured out what it was. I still back
 > up my repository with pgdump, because the restore is functional after all,
 > but for upgrades I always end up replicating.
 >
 > HTH,
 >
 > Martin

Thanks for the hint!
Mike

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc