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

[MargaretGillon@xxxxxxxxxxxxxx]

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@xxxxxxxxxxxx> wrote on 08/03/2006
01:45:41 AM:

> Thomas F. O'Connell wrote:
> > 
> > 
> > On Aug 2, 2006, at 4:27 PM, MargaretGillon@xxxxxxxxxxxxxx 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