Re: Data Warehousing - Mailing list pgsql-general

From Ken.Colson@sage.com
Subject Re: Data Warehousing
Date
Msg-id 057BEBE753E8AD4D8F202B35578D8169057C2B48@gnvalex004-backup.mmrd.com
Whole thread Raw
In response to Data Warehousing  ("Rob Kirkbride" <rob.kirkbride@gmail.com>)
List pgsql-general
>I am on a Linux platform but I'm going to need some pointers regarding
>the cron job. Are you suggesting that I parse the dump file? I assume I
>would need to switch to using inserts and then parse the dump looking
>for where I need to start from?

Something that you may want to consider is dblink from contrib.  We have a
similar situation for the archiving of collected data and have been able to
implement a fairly easy solution that does not require the parsing of dump
files, just a simple(ish) query based on the time inserted.

-Ken




---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Suggestion for new function on pg_catalog: get_config()
Next
From: Tom Lane
Date:
Subject: Re: Statistics collection question