| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tim Gustafson <tjg(at)ucsc(dot)edu> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Changing Character Sets |
| Date: | 2013-02-12 18:30:38 |
| Message-ID: | 25383.1360693838@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tim Gustafson <tjg(at)ucsc(dot)edu> writes:
> I'm curious why a pg_dumpall from 8.4 followed by a restore in 9.2
> caused the character sets to change at all. Was there some change in
> the default character sets between 8.4 and 9.2?
I was wondering that too. You did use pg_dumpall, and not individual
pg_dumps per database? In the latter case it's not hard to imagine
making a mistake, but pg_dumpall has been careful about database
properties for a long time.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2013-02-12 19:18:53 | Re: How to store version number of database layout |
| Previous Message | Little, Douglas | 2013-02-12 17:45:22 | design question - repeated updates on temp or perm table. |