| From: | Aarni Ruuhimäki <aarni(at)kymi(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Recommendations for a datasync scenario ? |
| Date: | 2007-11-30 07:02:25 |
| Message-ID: | 200711300902.25109.aarni@kymi.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello good folks,
Our php application uses browser clients and magnetic card readers to collect
workmen's working times from a number of physical construction or project
sites to the main database at the head office, which is online with a private
ip-address.
Now we have a situation where not all construction sites' offices are online
or have so poor / instable connections that we can't rely on them. So we need
to install a local server to collect the data.
What would be a proper way to load the work time data up to the main database
when a local server is online again ?
Also, all the workers and sites are created and maintained at the head office
so we need to get this data down. There may / will be corrections to the
uploaded work time data as well.
I imagine all this could be done with unique row identifiers, temp tables and
shell- / sql-scripts, but why re-invent the wheel ...
All servers are linux + Pg8.2.
I followed the recent thread about 'replication in Postgres' but still any
info on experience of similar circumstances and pointers / comments /
recommendations are more than welcome.
BR,
--
Aarni Ruuhimäki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2007-11-30 07:10:11 | Re: hibernate + postgresql ? |
| Previous Message | Robert Treat | 2007-11-30 06:59:40 | Re: PostgresSQL vs Ingress |