> 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". ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
