| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | Bjørn T Johansen <btj(at)havleik(dot)no> |
| Cc: | pgsql-general List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Upgrading from 8.3 to 8.4 and Integer datatimes? |
| Date: | 2009-07-28 13:25:28 |
| Message-ID: | A3B18E74-BB20-4477-A266-07FBE0FB2E7A@seespotcode.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jul 28, 2009, at 8:48 , Bjørn T Johansen wrote:
> Will a dump and restore take care of this change or do I have to do
> some manual converting when upgrading?
Dump and reload should be fine. While the binary format of the
timestamp values is different in the *database*, the text output of
pg_dump is independent of the binary format: timestamps (and other
values) are literal representations.
As always, for your own edification and assurance, I'd test this with
both a small, toy database and with your production database before
your final upgrade.
Michael Glaesemann
grzm seespotcode net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2009-07-28 13:27:35 | Re: selecting all columns but one |
| Previous Message | Thomas Kellerer | 2009-07-28 13:25:02 | Re: selecting all columns but one |