Re: More activity in pg_stat_activity - Mailing list pgsql-general

From Erik Jones
Subject Re: More activity in pg_stat_activity
Date
Msg-id 45A2782E.6080503@myemma.com
Whole thread Raw
In response to Re: More activity in pg_stat_activity  ("Thomas F. O'Connell" <tf@o.ptimized.com>)
List 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@myemma.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@myemma.com>
software development
emma(r)


pgsql-general by date:

Previous
From: "Michael Nolan"
Date:
Subject: Re: Discovering time of last database write
Next
From: "A. Kretschmer"
Date:
Subject: Re: Sorting