Replication of a small portion of data to another database
От | Paul |
---|---|
Тема | Replication of a small portion of data to another database |
Дата | |
Msg-id | 3A47475E@operamail.com обсуждение исходный текст |
Список | pgsql-hackers |
Hi there, [I sent this email to pgsql-general yesterday, but it seems to be horked and this looks like the next best place] I have a set of structually identical databases which are functionally independant. However, I now want to be able to do a full text index search on a single (two field) record across all of these databases. At the moment I only have a few of these databases and connecting to and scanning each one sequentially is sufficient. In the long term I expect the number of databases that will exist to make this unfeasable. Thus I'd like to create a centralised database whose sole task is to enable full text searches of this record across all the other databases. I believe that Postgres doesn't do cross-database stuff as it stands. I currently have this harebrained scheme whereby I write my own SQL function in C that links to libpq so that any of the other databases can connect to the central DB and perform the required insert/update/delete when triggered to do so. Does that seem to be a reasonable thing to try? Has anyone else done such a thing? Is there a better way of doing it? Paul. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com ------------------------------------------------------------
В списке pgsql-hackers по дате отправления: