HI -
I am looking to upgrade our postgresql 9 to 9,2 using pg_upgrade.
We have postgis installed on the current cluster (9).
Both postgresql and postgis was installed using the pg repos.
Will I need to re-install postgis after running pg_upgrade?
Thanks for any guidance,
Ronit
wrote:
> On Tue, Sep 11, 2012 at 04:15:31PM +0300, Ronit Allen wrote:
> > HI -
> >
> > I am looking to upgrade our postgresql 9 to 9,2 using pg_upgrade.
> >
> > We have postgis installed on the current cluster (9).
> >
> > Both postgresql and postgis was insta
Hi -
I have the following query on pg_stat_all_tables to look at updates,
inserts, and deletes:
SELECT relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_all_tables;
How can I add a date range to the WHERE clause to show data from a
specified date range?
I don't see anything in the table or
s for the last 7 days? 30 days? all time?..
I don't see the answer to this in
http://www.postgresql.org/docs/9.1/static/monitoring-stats.html (or maybe
it is there and I am not understanding).
Thanks once again,
Ronit
On Tue, Nov 13, 2012 at 10:54 AM, Albe Laurenz wrote:
> Ronit Allen
Hi -
Thank you Laurnez.
Ronit
On Fri, Nov 16, 2012 at 11:56 AM, Albe Laurenz wrote:
> Ronit Allen wrote:
> > On 9.1 with postgresql.conf left at defaults, what period of time does
> a query on pg_stat_all_tables
> > cover?
> >
> > Let's say my database ha
