Re: [GENERAL] DB upgrade

2007-10-10 Thread Andrew Kelly
On Tue, 2007-10-09 at 11:46 +0200, Andrew Kelly wrote: Hi folks, please forgive what feels like a no-brainer even as I ask it, but... snip Just wanted to thank everybody who's provided feedback. I'm squared away now, and very appreciative of all the help. Andy

[GENERAL] DB upgrade

2007-10-09 Thread Andrew Kelly
Hi folks, please forgive what feels like a no-brainer even as I ask it, but... I've read dozens of times in these lists that when one is upgrading from an older to newer version of PG, the DB being dumped (older version) should be done so using pg_dump from the newer version. I think I've

Re: [GENERAL] DB upgrade

2007-10-09 Thread Peter Eisentraut
Am Dienstag, 9. Oktober 2007 schrieb Andrew Kelly: Unless my installation is unique in some way of which I'm yet unaware, Yes, it's a Debian package. pg_dump seems to be just a handful of lines in a perl script. In fact, pg_dump, pg_restore and pg_dumpall are all simlinks to the same simple

Re: [GENERAL] DB upgrade

2007-10-09 Thread Albe Laurenz
Andrew Kelly wrote: I've read dozens of times in these lists that when one is upgrading from an older to newer version of PG, the DB being dumped (older version) should be done so using pg_dump from the newer version. [...] Which bit exactly are we supposed to use from the newer version?

Re: [GENERAL] DB upgrade

2007-10-09 Thread Andrew Kelly
On Tue, 2007-10-09 at 13:58 +0200, Peter Eisentraut wrote: Am Dienstag, 9. Oktober 2007 schrieb Andrew Kelly: Unless my installation is unique in some way of which I'm yet unaware, Yes, it's a Debian package. Indeed, yes. Where can I read what that means in the great scheme of things?

Re: [GENERAL] DB upgrade

2007-10-09 Thread Dimitri Fontaine
Le mardi 09 octobre 2007, Andrew Kelly a écrit : On Tue, 2007-10-09 at 13:58 +0200, Peter Eisentraut wrote: Where can I read what that means in the great scheme of things? Are you saying that Deb is markedly different from other packages (.rpm) or that any packaged version of PG is different

Re: [GENERAL] DB upgrade

2007-10-09 Thread Richard Huxton
Andrew Kelly wrote: On Tue, 2007-10-09 at 13:58 +0200, Peter Eisentraut wrote: Am Dienstag, 9. Oktober 2007 schrieb Andrew Kelly: Unless my installation is unique in some way of which I'm yet unaware, Yes, it's a Debian package. Indeed, yes. Where can I read what that means in the great