471,354 Members | 2,085 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Remote updating

Is it possible to have Postgres output changes to tables, i.e.
essentially the WAL log, in the form of SQL statements, that could be
uploaded to another, identical database, on a remote machine.

I have a client that DOES NOT want the whole schema on their website for
the sake of security. Pat will be on the website, part will be on an
office computer.

Both 'mini schemas' will use some common tables, like states, addresses,
etc.

If I could, I would make the changes queue up on the office computer,
and then their local apache server and postgres DB would send up an
update script.

I'm wondering how to keep the two parts of the schemas synchronized.

Is it possible to make a mirrororing system only mirror certain tables
from a schema? Does this sound like a way to go?

Do the writes in the primary master tend to wait until they can
synchronize the slaves before it reflects the changes local to it, i.e.
wait on full commit to all DB's before the transaction is visible?

One other possiblity is that the total data will be pretty small, I
could just upload the entire dataset, with date versioning, and remove
off the end the old ones, 3-4 versions back. I would make all scripts
look at one particular date value in one field saying what the new
version is.

Anyway, thoughts on this appreciated.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
1 1288
Dennis,

This may not be much help, but you might want to take a look into The
eRserver Project
http://gborg.postgresql.org/project/...rojdisplay.php

Jordan S. Jones

--
I am nothing but a poor boy. Please Donate..
https://www.paypal.com/xclick/busine...rency_code=USD

Dennis Gearon wrote:
Is it possible to have Postgres output changes to tables, i.e.
essentially the WAL log, in the form of SQL statements, that could be
uploaded to another, identical database, on a remote machine.

I have a client that DOES NOT want the whole schema on their website
for the sake of security. Pat will be on the website, part will be on
an office computer.

Both 'mini schemas' will use some common tables, like states,
addresses, etc.

If I could, I would make the changes queue up on the office computer,
and then their local apache server and postgres DB would send up an
update script.

I'm wondering how to keep the two parts of the schemas synchronized.

Is it possible to make a mirrororing system only mirror certain tables
from a schema? Does this sound like a way to go?

Do the writes in the primary master tend to wait until they can
synchronize the slaves before it reflects the changes local to it,
i.e. wait on full commit to all DB's before the transaction is visible?

One other possiblity is that the total data will be pretty small, I
could just upload the entire dataset, with date versioning, and remove
off the end the old ones, 3-4 versions back. I would make all scripts
look at one particular date value in one field saying what the new
version is.

Anyway, thoughts on this appreciated.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by juglesh | last post: by
2 posts views Thread by Hal Vaughan | last post: by
1 post views Thread by Jason Cooke | last post: by
4 posts views Thread by Catherine Jo Morgan | last post: by
5 posts views Thread by perspolis | last post: by
2 posts views Thread by Chris | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.