Re: Postgres database as a client/server architecture - Mailing list pgsql-admin

From Rich
Subject Re: Postgres database as a client/server architecture
Date
Msg-id 8fb205ea0810060800t6a14d70bo85bc55dd8db32914@mail.gmail.com
Whole thread Raw
In response to Re: Postgres database as a client/server architecture  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Postgres database as a client/server architecture  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
On Mon, Oct 6, 2008 at 10:08 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid <mail4rashid@gmail.com> 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
>

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: sql command strange behaviour
Next
From: "Scott Marlowe"
Date:
Subject: Re: Postgres database as a client/server architecture