473,232 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,232 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 1344
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: juglesh | last post by:
at one centraldomain.com, I have central.php, which consists of this: <?php function square($num) { return $num * $num; } ?> at outerdomain.com, I have test.php, which consists of this:...
2
by: Hal Vaughan | last post by:
I think I read something about this and I may just be using the wrong terms in search engines. I thought I read about a process where I could write Java classes that would be stored on a server...
1
by: Jason Cooke | last post by:
I've got a situation where I'm updating a MySQL DB with PHP but because of how the language works I need to do the following. The "main page" will open a remote page where the user will...
4
by: banz | last post by:
Hello I have a problem to resolve: I wrote a Perlscript which caches data from a server (local on my machine) I would like to have a other connection to a remote server but I don't know how to...
4
by: Catherine Jo Morgan | last post by:
I'm making a database using the Developer's Edition. The client will need 2 copies of the runtime edition, one for herself and one for her virtual assistant located in another county. Both of these...
5
by: perspolis | last post by:
Hi all I want to update a remote db on my site. but I don't want to connect to db directly.. How can I do that?? thx
1
by: K Meyer | last post by:
Everything in the deployment works fine with the exception of the address of the database also deployed on the remote server. The string address is found under "oledbconnection" in the ".......
2
by: Chris | last post by:
The situation: We have a remote web server (Server A), where we run our ASP.Net application. There are 3 developers, each working on their pieces of the application and updating Server A...
8
by: robert | last post by:
Hello, I want to put (incrementally) changed/new files from a big file tree "directly,compressed and password-only-encrypted" to a remote backup server incrementally via FTP,SFTP or DAV.... At...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.