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

[MargaretGillon@xxxxxxxxxxxxxx]

> Your confirmation is correct with one slight
technical exception: 
> specifying the port doesn't technically cause the system to know 
> which version of postgres to use.
> 
> In my previous post, I forgot to mention a related note: the version
> of pg_dump that you're using matters slightly. pg_dump can typically
> be used with older postgres installations, but not newer ones. So
> you should prefer using the 8.1.4 version of pg_dump to dump at 
> least your 8.1.4 postmaster, but probably also your 7.3.4 postmaster.
> 
> A 7.3.4 pg_dump client will probably not be able to run against an
> 8.1.4 postmaster.
> 
> Otherwise, pg_dump doesn't really care about the version as much as
> it cares about being able to connect to a postmaster. That's what
> specifying the port helps it do. When you don't specify the port,
it
> just tries port 5432. If it finds a postmaster listening there, 
> great, it will try to dump it; otherwise, it will fail with a 
> complaint that it couldn't connect to anything on 5432.
> 
> --
> Thomas F. O'Connell
> Sitening, LLC
> 
> http://www.sitening.com/
> 3004B Poston Avenue
> Nashville, TN 37203-1314
> 615-469-5150 x802
> 615-469-5151 (fax)
> 

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?

*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
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.