| From: | Reece Hart <reece(at)harts(dot)net> |
|---|---|
| To: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Multiple versions on same box |
| Date: | 2007-10-09 05:06:20 |
| Message-ID: | 1191906380.16578.8.camel@snafu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2007-10-08 at 17:34 -0700, Ralph Smith wrote:
> What is the best way to upgrade? Use pg_dumpall (using 8.2's
> program), afterwards redirect that file into v8.2 via psql v8.2?
There are lots of ways to do this. My favorite is to bring a new cluster
on port 5433 and then pipe data between them, roughly like this:
$ /path/to/7.4/pg_dumpall -p5432 ... | /path/to/8.2/psql -p5433 -qaf-
>restore.log 2>&1
This obviates the intermediate dump file, which can be large.
As a precaution, I remove the PATH elements that locate pg (thus
requiring that I specify the full path) and I unsetl PG* variables.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2007-10-09 05:29:55 | Re: Request: Anyone using bogus / "humorous" X-Message-Flag headers, could we please turn them off |
| Previous Message | Rajarshi Guha | 2007-10-09 02:15:36 | Re: speeding up CUBE queries |