Re: [GENERAL] [general] [general] perpetual dump/restore problem

2007-07-05 Thread wu_zhong_min
You are right. I have now corrected that and I believe that should fix the problem. > >AFAICS it would not be issuing that unless you'd made template0 >connectable on t ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore

Re: [GENERAL] [general] perpetual dump/restore problem

2007-07-05 Thread Tom Lane
[EMAIL PROTECTED] writes: > time? Why won't pg_dump include a line to accept connection for > template0 just before it writes "\connect template0" and then remove > the permission after it is done with template0? AFAICS it would not be issuing that unless you'd made template0 connectable on the s

Re: [GENERAL] [general] perpetual dump/restore problem

2007-07-05 Thread wu_zhong_min
> OK. If you're not in a hurry, and can wait a few months 8.3 will be out. I am moving the database to a new physical server and it makes sense to move to the latest version now. >>for template0 all the >> time? Why won't pg_dump include a line to accept connection for >> template0 just before

Re: [GENERAL] perpetual dump/restore problem

2007-07-05 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Dear List, As many of you know every time one wants to upgrade to a major server version, as I want to do now, there is a need for pg_dumpall and restore. This is a huge undertaking and requires lots of testing and planning. I do hope that in the future this requiremen

[GENERAL] perpetual dump/restore problem

2007-07-04 Thread wu_zhong_min
Dear List, As many of you know every time one wants to upgrade to a major server version, as I want to do now, there is a need for pg_dumpall and restore. This is a huge undertaking and requires lots of testing and planning. I do hope that in the future this requirement will be dropped. I am