Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4985737BAE0 for ; Mon, 6 Oct 2008 11:08:40 -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 93218-06 for ; Mon, 6 Oct 2008 11:08:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.228]) by postgresql.org (Postfix) with ESMTP id DB5D337C0C7 for ; Mon, 6 Oct 2008 11:08:26 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so2836380rvf.43 for ; Mon, 06 Oct 2008 07:08:23 -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=g0aYrnoaI6X1ZAA5Gn8TyeTZ9tX7q6/OzpMMJk7nqkc=; b=BtoajoebMxoPgjkecStJSmWwo/Kp4QapUDs9whZ59yH9a6oJV3uuYULbjtKVU36Trw aY7p5T4sFHaIYGuyLYRKCSz0m2411vg7PROCFCOOFlQJSmAfYrPCKh/QuorYfZrzf3kf UkewO9RvCt7Z9Tx5LWUMzyYiUe/d+PhS67cPs= 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=Z4c/Fn94MTXprfEn4tgJFoI/xWLU0Ndw1CrBZu1uqxX5IZII2OLLRPqFRIdzKwqt+T +1G1ALL50lunE2bNFk85lZY7t2oz+He0OE4hNObdUpiM9x3NtOromex8w6fsmJOJtCpL BV+rscyy6HKNPGWI4DWwgC/9viu84/G88VjsU= Received: by 10.140.188.10 with SMTP id l10mr2904492rvf.6.1223302103579; Mon, 06 Oct 2008 07:08:23 -0700 (PDT) Received: by 10.140.248.12 with HTTP; Mon, 6 Oct 2008 07:08:23 -0700 (PDT) Message-ID: Date: Mon, 6 Oct 2008 08:08:23 -0600 From: "Scott Marlowe" To: "Mohammed Rashid" Subject: Re: Postgres database as a client/server architecture Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: 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/26 X-Sequence-Number: 30482 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.