Tom Lane wrote: > Bruce Momjian <br...@momjian.us> writes: > > Tom Lane wrote: > >> One problem that just occurred to me is that this solution may not be > >> adequate for pg_migrator. It will need to check that the new database > >> has the same "default" settings (where "default" means "those of > >> template0") as the old installation did. I think that's probably doable > >> but we'll have to check. > > > I have already coded pg_migrator to get the 8.4 template0 locale and > > check for a match of that against pg_controldata of 8.3. Are you saying > > I need to spin through all the databases after they are created and > > check again? > > No, that sounds like it should be sufficient ... but you need to check > the template0 encodings match too, assuming that we make encoding and > locale work the same here.
OK, are you suggesting checking the pg_database.encoding for template0 for both servers because that information isn't in either pg_controldatas? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers