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_dumpalland restore. This is a huge undertaking and requires lots of testing and planning. I do hope that in the
futurethis requirement will be dropped.
I am now upgrading from 8.1.9 to 8.2.4 and pg_dumpall gives a dump file which has a command "\connect template0"
Normally template0 does not accept connection but I found a way to make that happen in the documentation on postgresql
website. But is it generally safe to accept the connection for template0 all the time? Why won't pg_dump include a
lineto accept connection for template0 just before it writes "\connect template0" and then remove the permission after
itis done with template0?
thanks
Wu Z-m