From: Gnanakumar <gnanam@zoniac.com>
To: 'Kevin Grittner' <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
Cc: raghuchennuru@gmail.com
Subject: Re: DB Import Error...
Date: Tue, 5 Apr 2011 12:17:22 +0530
Message-ID: <002501cbf35d$54246310$fc6d2930$@com> (raw)
In-Reply-To: <4D99A788020000250003C21A@gw.wicourts.gov>
References: <201104011542.p31Fg6L3025075@rs73.luxsci.com>
<006201cbf2d1$1ea55730$5bf00590$@com>
<4D99A788020000250003C21A@gw.wicourts.gov>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gnanam@zoniac.com, Kevin.Grittner@wicourts.gov, raghuchennuru@gmail.com
Subject: Re: DB Import Error...
In-Reply-To: <002501cbf35d$54246310$fc6d2930$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox