Re: [GENERAL] Pains in upgrading to 8.3

2008-02-19 Thread Dave Page
On Feb 19, 2008 8:48 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Mon, Feb 18, 2008 at 06:35:11PM -0300, Alvaro Herrera wrote: > > Bruce Momjian escribió: > > > Magnus Hagander wrote: > > > > > > For the case of upgrading, it wouldn't work. But there are certainly > > > > other cases where i

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-19 Thread Magnus Hagander
On Mon, Feb 18, 2008 at 06:35:11PM -0300, Alvaro Herrera wrote: > Bruce Momjian escribió: > > Magnus Hagander wrote: > > > > For the case of upgrading, it wouldn't work. But there are certainly > > > other cases where it would help. Say from your central pgadmin console > > > administering 10 se

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-18 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Bruce Momjian escribió: >> What cases on the past have needed the new pg_dump? > Dependency handling IIRC in 7.3 (or was it 7.2?) was a big change for > pg_dump, and I don't think we would have liked to backpatch the pg_dump > changes. Also, AFAIK the

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-18 Thread Alvaro Herrera
Bruce Momjian escribió: > Magnus Hagander wrote: > > For the case of upgrading, it wouldn't work. But there are certainly > > other cases where it would help. Say from your central pgadmin console > > administering 10 servers from 3 different major release trees :-( What's wrong with providing

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-16 Thread Bruce Momjian
Magnus Hagander wrote: > Dave Page wrote: > > On Fri, Feb 15, 2008 at 4:21 PM, Tony Caduto > > <[EMAIL PROTECTED]> wrote: > >> paul rivers wrote: > >> >> > >> > Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. > >> > However, unlike the blogger you cite, I read the directions before

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Tony Caduto
Magnus Hagander wrote: For the case of upgrading, it wouldn't work. But there are certainly other cases where it would help. Say from your central pgadmin console administering 10 servers from 3 different major release trees :-( It can be done with commandline pg_dump, but it means you have

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Greg Smith
On Fri, 15 Feb 2008, Tom Lane wrote: He claims it didn't work, but there's no details about what went wrong. He also seems entirely misinformed on the difference between "portable" and "PG-specific" pg_dump output. I just left a note on this and related subjects on the blog. If you search f

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Tony Caduto
paul rivers wrote: Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. However, unlike the blogger you cite, I read the directions before, not after, attempting it. The blogger has a point about pg_dump and restore, it could be much better, for example the backup process could b

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Scott Marlowe
On Fri, Feb 15, 2008 at 8:21 AM, Phoenix Kiula <[EMAIL PROTECTED]> wrote: > I'm glad I didn't go from 8.2.3 to 8.3 straight! > > http://ogasawalrus.com/blog/node/462 If only he were on debian or ubuntu, he could run pg_upgradecluster and he'd have been done. ---(end of br

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Magnus Hagander
Dave Page wrote: On Fri, Feb 15, 2008 at 4:21 PM, Tony Caduto <[EMAIL PROTECTED]> wrote: paul rivers wrote: >> > Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. > However, unlike the blogger you cite, I read the directions before, > not after, attempting it. The blogger has

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Ray Stell
On Fri, Feb 15, 2008 at 10:21:16PM +0800, Phoenix Kiula wrote: > > http://ogasawalrus.com/blog/node/462 "Reading more carefully" sounds like it was the first read to me. ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Dave Page
On Fri, Feb 15, 2008 at 4:21 PM, Tony Caduto <[EMAIL PROTECTED]> wrote: > paul rivers wrote: > >> > > Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. > > However, unlike the blogger you cite, I read the directions before, > > not after, attempting it. > > > The blogger has a poin

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Tom Lane
Tony Caduto <[EMAIL PROTECTED]> writes: > paul rivers wrote: >> However, unlike the blogger you cite, I read the directions before, >> not after, attempting it. > The blogger has a point about pg_dump and restore, Does he? He claims it didn't work, but there's no details about what went wrong.

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread paul rivers
Tony Caduto wrote: paul rivers wrote: Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. However, unlike the blogger you cite, I read the directions before, not after, attempting it. The blogger has a point about pg_dump and restore, it could be much better, for example the bac

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread paul rivers
Phoenix Kiula wrote: I'm glad I didn't go from 8.2.3 to 8.3 straight! http://ogasawalrus.com/blog/node/462 Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me. However, unlike the blogger you cite, I read the directions before, not after, attempting it. Paul -

Re: [GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Scott Marlowe
On Fri, Feb 15, 2008 at 8:21 AM, Phoenix Kiula <[EMAIL PROTECTED]> wrote: > I'm glad I didn't go from 8.2.3 to 8.3 straight! ither way, you need to update to 8.2.6 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an app

[GENERAL] Pains in upgrading to 8.3

2008-02-15 Thread Phoenix Kiula
I'm glad I didn't go from 8.2.3 to 8.3 straight! http://ogasawalrus.com/blog/node/462 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq