Postgres Pro
Downloads
Home   >   mailing lists

Automation again more info.. HELP - Mailing list pgsql-novice

From Jerome Macaranas
Subject Automation again more info.. HELP
Date
Msg-id 00e001c034bd$9d60bd40$5764a8c0@edsamail.com
Whole thread Raw
Responses Re: Automation again more info.. HELP
List pgsql-novice
Tree view
Sorry about the lack of info..
 
OS: Redhat 6.2
mailbox01-->Postgresql 6.5
mailbox02-->Postgresql 7.02
Preferred language-->TCL
 
    I have a database of email users with a lot of tables..... 
EX. BASIC_INFO, ADS_STATS etc....
 
I want to automate the dumping of data..... from mailbox01(name of computer) and append it to to the existing database in mailbox02 (backup of mailbox01) so the marketing dept. can do their job..  I have an idea of just querying... I want to have suggestions ... more idea on how to do this....
I hate typing again and again the query WHERE date is ... bla bla ...
 
ONE BIG PROBLEM....
 
If Im going to create a single script to placed in cron WHAT IF... I want to have the month of October I'll be dumping all the data again.... waste of time... and cpu hours hehehehe...
 
Thanks in advance 
 

pgsql-novice by date:

Previous
From: ghaverla@freenet.edmonton.ab.ca
Date:
Subject: Re: Automation
Next
From: ghaverla@freenet.edmonton.ab.ca
Date:
Subject: Re: Automation again more info.. HELP