From: | "Gnanakumar" <gnanam(at)zoniac(dot)com> |
---|---|
To: | "'Kevin Grittner'" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <pgsql-admin(at)postgresql(dot)org> |
Cc: | <raghuchennuru(at)gmail(dot)com> |
Subject: | Re: DB Import Error... |
Date: | 2011-04-05 06:47:22 |
Message-ID: | 002501cbf35d$54246310$fc6d2930$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> If you're upgrading to 9.0, I would start by following the
> recommended upgrade procedure and seeing whether these problems then
> exist in the new database. Fixing old issues like this is one big
> reason for using the newer version of pg_dump.
How do I use the newer version of pg_dump (9.0.3 in this case) to take SQL
dump, when v8.2.3 is already installed in my server? BTW, originally we've
installed v8.2.3 from the source (./configure, gmake, gmake install). Even
if I try to install the new version 9.0.3 from source, will that not
overwrite existing directories, files, binaries, etc.?
Our current v8.2.3 setup:
Installation directory: /usr/local/pgsql
Port: 5432
Any procedure/steps/advice/suggestion to take dump using latest version of
pg_dump without disturbing old database cluster is appreciated.
NOTE: It's not one single database server, we've multiple onsite customer
servers that has to be upgraded, hence I would like to address this issue in
general.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2011-04-05 14:48:37 | Re: DB Import Error... |
Previous Message | Glyn Astill | 2011-04-04 19:35:17 | Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?) |