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

From Mohammed Rashid
Subject Re: Postgres database as a client/server architecture
Date
Msg-id b1bef36d0810062140y1d42f5e5xc851dbd537f4a157@mail.gmail.com
Whole thread Raw
In response to Re: Postgres database as a client/server architecture  (Montaseri <montaseri@gmail.com>)
List pgsql-admin
Hi Medi,

I have use thick client. I want data processing on the client side.

Regards,
Rashid



On 10/7/08, Montaseri <montaseri@gmail.com> 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 <scott.marlowe@gmail.com>
> wrote:
>
> >
> >
> > On Mon, Oct 6, 2008 at 9:00 AM, Rich <rhdyes@gmail.com> wrote:
> > > 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.
> >
> > 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
> >
>
>

pgsql-admin by date:

Previous
From: paulo matadr
Date:
Subject: pg_hotbackup
Next
From: "Prestige Makanga"
Date:
Subject: Installing PostGre SQL