Re: Tape backup, 2 versions, same database name, which is pg_dump

Great, Thanks!
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

This e-mail message and any attachment(s) are for the sole use of the
intended recipient(s) and may contain proprietary and/or confidential
information which may be privileged or otherwise protected from
disclosure. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient(s), please contact the
sender by reply email and destroy the original message and any copies of
the message as well as any attachment(s) to the original message.

Richard Huxton <dev(at)archonet(dot)com> wrote on 08/03/2006 01:45:41 AM:

> Thomas F. O'Connell wrote:
> >
> >
> > On Aug 2, 2006, at 4:27 PM, MargaretGillon(at)chromalloy(dot)com wrote:
> >
> >> You're correct, I cannot use the pg_dump. I get a error message that
> >> the pg_dump is aborting because of a version mismatch, then it says
to
> >> use the i opt. How do I call the pg_dump from the 8.1.4 version?
> >
> > You'll probably need to specify an absolute path. Are both the client
> > and server applications running on the same server? If so, you might
> > need to get your consultant to tell you where the client applications
> > for the 8.1.4 installation were actually installed. By default,
postgres
> > installs both client and server applications into /usr/local/pgsql,
but
> > at least one of your installations must be in a different location;
> > otherwise, you probably couldn't have two versions of the postmaster
> > running concurrently.
>
> Oh, and two other commands you might find useful:
> which pg_dump
> Will show you which version of pg_dump is being run by default
> alias
> Will let you set up pg_dump81 as an alias for the correct binary you
want.
>
> Man pages cover the details.
>
> --
> Richard Huxton
> Archonet Ltd