Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3D99D37C17D for ; Mon, 6 Oct 2008 12:01:11 -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 08031-09 for ; Mon, 6 Oct 2008 12:00:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 662FC37C0C7 for ; Mon, 6 Oct 2008 12:00:57 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id c7so1029116nfi.23 for ; Mon, 06 Oct 2008 08:00:56 -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=D4nWvXH4oyyf6xCfMeAvynJwWtcc6cjCKL6kpq5TzNM=; b=PHTV3C7izaPO/+QXF592cjF5hc2Oce/uFlXJQyYKOF+dp8VJcu0rkrjPeyHfcRTzfH eDn6KFAlM+7Cb2o0/rwPkdpBT0MOz5UmY9VIyKxfDCh+nvm2Ezi2vcb4+mJ6kZLoM8sm fxKhg7FwEQKEFppQD/OHtP+68VVrr+k4L0OIU= 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=H2NIEyfDjrYCoDIMmEOa4Tyz2bbLsEOZYW3G74LmzvRKpMw0og/lws0W3S7Uu9InEi g2/X7kaHcStCX2unbllJRRHzvbtCoBHG90jdrQpiBsUDTWn/8ZAIL8DujveVv6ceDjMU 97BsVrET7ESPek2zYVJCBuOSLEVgALTNRHXD0= Received: by 10.210.25.18 with SMTP id 18mr6466078eby.78.1223305255967; Mon, 06 Oct 2008 08:00:55 -0700 (PDT) Received: by 10.210.128.15 with HTTP; Mon, 6 Oct 2008 08:00:55 -0700 (PDT) Message-ID: <8fb205ea0810060800t6a14d70bo85bc55dd8db32914@mail.gmail.com> Date: Mon, 6 Oct 2008 11:00:55 -0400 From: Rich To: "Scott Marlowe" Subject: Re: Postgres database as a client/server architecture Cc: "Mohammed Rashid" , 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/28 X-Sequence-Number: 30484 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. > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >