Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 83D049FA3AD for ; Fri, 10 Nov 2006 23:16:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 66906-05 for ; Fri, 10 Nov 2006 23:16:49 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.224]) by postgresql.org (Postfix) with ESMTP id 3DF789F9858 for ; Fri, 10 Nov 2006 23:16:49 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so640625wxd for ; Fri, 10 Nov 2006 19:16:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=JwJfuP/hHe2pRhj1/mHqtOGKu7hXUceCuD+DKGQi0VmHI26VYkb7m4R/JcjKQRYQm6yOvbXDrIZg5GDtZf3ZkiWrdLsHCDdDdgOQ/C0XI7G+YaUYsjySVerPwIAR0aWQ3KboFzcSkkQBGYPlEeQH0q+NVRJOrfF0jQ3wfjHOBRo= Received: by 10.70.57.2 with SMTP id f2mr4389292wxa.1163215007728; Fri, 10 Nov 2006 19:16:47 -0800 (PST) Received: by 10.70.28.16 with HTTP; Fri, 10 Nov 2006 19:16:47 -0800 (PST) Message-ID: <9e0a28690611101916h4a17fdads1ce87022881eace2@mail.gmail.com> Date: Fri, 10 Nov 2006 23:16:47 -0400 From: "Juan Miguel Paredes" To: pgsql-php@postgresql.org Subject: Re: PgSQL and integration between 2 PHP programs and a Java program In-Reply-To: <7b872b430611101717s1adafc50o207f53c19d8da138@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7b872b430611101717s1adafc50o207f53c19d8da138@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/39 X-Sequence-Number: 3656 Hi, Amir! On 11/10/06, Servers24 Network wrote: I don't really > know how this DBI-Link works, but the way Juan said, maybe I can have > Liferay write user information to a PgSQL DB and have DBI-Link propagates > the data (username, password, first_name, last_name, city, state, country, > zipcode and ... ) inside Liferay's DB to all appropriate DBs. > Also I will disable ANY modification to the above mentioned fields in other > applications so that a user need to change for e.g his name in Liferay, and > then it will take effect in other applications as well. > So in this method, I will use a PgSQL server with 2 databases ( one for > DBI-Link and one for Liferay ) and a MySQL server with maybe 10 databases > for other applications. In this case, CAS will read authentication > information from Liferay DB in PgSQL. > Any comments or ideas ?! For how DBI-Link works, maybe pgfoundry docs (like http://pgfoundry.org/docman/view.php/1000045/48/IMPLEMENTATION.txt) can give a good big picture. Reading the mentioned document, it seems like there could be better performance when reading through DBI-Link from other datasources than writing to several other datasources from PostgreSQL "DBI-linked" tables (just guessing, there can be some other factors involved, and, as always, experiences and benchmarks are welcome). If this is true, maybe it would be better to have the other 10 DBs in PostgreSQL reading from the centralized datasource, but of course that might not be practical in your case, if it means a lot of code rewriting. Anyway, I hope this helps and any feedback will be followed with interest! ;) Greetings!