By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

Remote updating

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.