Search Postgresql Archives

Re: Data Warehousing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux