Обсуждение: Re: [general] perpetual dump/restore problem

> 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 it writes "\connect template0" and then remove
>> the permission after it is done with template0?

> Might be a bug, but first; did you dump using 8.2's pg_dumpall?

Yes.  I tried both 8.1 and 8.2 pg_dumpall many times.  I think that, with one try with 8.1, it does not give "connect
template0". 

wu_zhong_min@vrane.com 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 source database.  That is not a good thing;
undo it.

            regards, tom lane