Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A609837BC88 for ; Tue, 7 Oct 2008 01:40:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77727-05 for ; Tue, 7 Oct 2008 01:40:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.186]) by postgresql.org (Postfix) with ESMTP id 3FA2837BAC0 for ; Tue, 7 Oct 2008 01:40:19 -0300 (ADT) Received: by ti-out-0910.google.com with SMTP id y8so1721199tia.5 for ; Mon, 06 Oct 2008 21:40:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=rt+EVDejl9adiQTVbnVE5Q7xrPOndQxOJwh7np0pjfM=; b=ZNUEtSGpHDLR2oKSAiJgzcx7WVCggFrpYRL0JQ6+gYCBUKfWXGG9MOkY76RErsQX4q ncY+p7vNj1TPXqTAip09pmQXZryC+z/Q3PtR12omKsmmNfZcLmTT83rPj9Nt91OxX+vv iJDVmTlzE0S7CuxiE0uQ5/vkBXh9ed9l3x898= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=tFrBWsHfysA77s+avD0sh7neFXiR0a9ZUvukuDBMd3Rdjay2aTnXCCP3k2dEtSL9Nq r2ItvQBj9zSt+33LCMHmmd1jKYDw8wHDb0dO930x3/4VlFf+9dhy94inoasse18YTzIz BTigvp9iaCZiCMpq4gcVtaz9YngvmAJgBO2uc= Received: by 10.110.33.15 with SMTP id g15mr7582968tig.35.1223354418458; Mon, 06 Oct 2008 21:40:18 -0700 (PDT) Received: by 10.110.52.16 with HTTP; Mon, 6 Oct 2008 21:40:18 -0700 (PDT) Message-ID: Date: Tue, 7 Oct 2008 10:10:18 +0530 From: "Mohammed Rashid" To: Montaseri Subject: Re: Postgres database as a client/server architecture Cc: "Scott Marlowe" , Rich , pgsql-admin@postgresql.org In-Reply-To: <8078a1730810061134w5ef858d3g59a719ae558a63c5@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8fb205ea0810060800t6a14d70bo85bc55dd8db32914@mail.gmail.com> <8078a1730810061134w5ef858d3g59a719ae558a63c5@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/39 X-Sequence-Number: 30495 Hi Medi, I have use thick client. I want data processing on the client side. Regards, Rashid On 10/7/08, Montaseri wrote: > I'd say, don't overwhelm the original ask-er. Let him explain this problem > statement again. > So far we know he wants a client server. > Rashid, > Do you want thin client (like web based) or thick like X11 or Java or VB > client? > Do you want the data processing be on the server (more reliable but > slower), or do you want some of the processing on the client (faster but > more complex)? > > Medi > > > On Mon, Oct 6, 2008 at 8:08 AM, Scott Marlowe > wrote: > > > > > > > On Mon, Oct 6, 2008 at 9:00 AM, Rich wrote: > > > On Mon, Oct 6, 2008 at 10:08 AM, Scott Marlowe > wrote: > > >> On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid > wrote: > > >>> Hi All, > > >>> > > >>> I have use the Postgres database as a client/server architecture. > > >>> I mean I want to run the clients on different PCs and want that all > > >>> the transactions should get automatically updated in the server. > > >>> It should also take care of network disconnections and update the > > >>> server after network connections automatically. > > >> > > >> PostgreSQL already is a client server architecture. However, it > > >> sounds like what you're actually looking for is some kind of client AS > > >> server method where the clients can operate independently then update > > >> the database at some later date. > > >> > > >> PostgreSQL has no facilities to do this on its own. > > > > > > Actually it does have those facilities to do such an architecture. > > > Its callled psql. Postgresql's verison of sql. just write sql > > > statements to update, delete or add records accordingly. You can do > > > this using a web interface, another client db like access or paradox. > > > There are tons of ways to do it. you can use an odbc interface. So > > > postgress does come with everything you need. > > > > Not if what the OP wants is the lotus notes type functionality where > > things are updated on the client, and at some later date updated on > > the main server and all data inconsistencies are automagically taken > > care of. > > > > OTOH, if all the OP wanted was to just have plain old client - server > > architecture, yeah, that's built right in to psql / libpq... > > > > -- > > > > > > > > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-admin > > > >