Re: More activity in pg_stat_activity

From: Erik Jones <erik(at)myemma(dot)com>
To: "Thomas F(dot) O'Connell" <tf(at)o(dot)ptimized(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: More activity in pg_stat_activity
Date: 2007-01-08 16:58:22
Message-ID: 45A2782E.6080503@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ah, I'd been looking at the following from Ch. 23.5 Backup and Restore
and was hoping it would go in both directions:

"It is recommended that you use the pg_dump and pg_dumpall programs from
the newer version of PostgreSQL, to take advantage of any enhancements
that may have been made in these programs. Current releases of the dump
programs can read data from any server version back to 7.0."

Thomas F. O'Connell wrote:
>
> On Jan 8, 2007, at 10:32 AM, Erik Jones wrote:
>
>>> Erik Jones <erik(at)myemma(dot)com> writes:
>>>
>> One question regarding my previous thread about the 8.2 client
>> tools. We have yet to have time (personal as well as usage pattern
>> constraints) to dump our schema to analyze it for any possible
>> discrepencies and clock schema queries. Is there any reason we
>> couldn't use the 8.1 pg_dump facility until such a time as we can
>> figure out our issues with the 8.2 pg_dump client (and psql, etc...)?
>
> If I recall correctly, older pg_dump clients won't work at all with
> newer postmasters. In fact, I think it will error out.
>
> --
> Thomas F. O'Connell
>
> optimizing modern web applications
> : for search engines, for usability, and for performance :
>
> http://o.ptimized.com/
> 615-260-0005
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/

--
erik jones <erik(at)myemma(dot)com>
software development
emma(r)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-01-08 16:59:05 Re: Sorting
Previous Message Michael Nolan 2007-01-08 16:54:48 Re: Discovering time of last database write