From: | Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |
Date: | 2010-06-10 14:02:20 |
Message-ID: | 4C10F06C.1070208@goebel-consult.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Am 10.06.2010 15:48, schrieb Robert Haas:
> Maybe so, but I don't give either method high marks for convenience.
> Suppose I have a server running 8.2 and I'm going to wipe it and
> install the latest version of $DISTRIBUTION which bundles 8.4. What
> our current policy essentially means is that I have to get 8.4 running
> on the old server before I wipe it (presumably compiling by hand,
> since the old version of the distro doesn't ship it), or else manually
> frobnicate the dump after I wipe it, or else find another server
> someplace to install 8.4 on and run the dump there prior to the OS
> upgrade. This really sucks. It's a huge pain in the tail, especially
> for people who aren't used to compiling PG from source at the drop of
> a hat.
+1
> I'm sure someone will tell me my system administration practices suck,
> but people do these kinds of things, in real life, all the time.
+1
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consult.de
Monatliche Kolumne: http://www.cissp-gefluester.de/
Goebel Consult mit Mitglied bei http://www.7-it.de
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2010-06-10 14:18:36 | Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |
Previous Message | Stefan Kaltenbrunner | 2010-06-10 13:50:38 | Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |