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 servers from 3

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 it would help. Say

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-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-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, not after,

[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

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

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 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 point about

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

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 a

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

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

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

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

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