pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres database as a client/server architecture
9+ messages / 6 participants
[nested] [flat]
* Postgres database as a client/server architecture
@ 2008-10-06 06:23 Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Mohammed Rashid @ 2008-10-06 06:23 UTC (permalink / raw)
To: pgsql-admin
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.
Please let me know how can I do it.
I am hoping to read soon from you.
Regards,
Rashid
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
@ 2008-10-06 14:08 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Re: Postgres database as a client/server architecture Rich <rhdyes@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Scott Marlowe @ 2008-10-06 14:08 UTC (permalink / raw)
To: Mohammed Rashid <mail4rashid@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-10-06 15:00 ` Rich <rhdyes@gmail.com>
2008-10-06 15:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Rich @ 2008-10-06 15:00 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Mohammed Rashid <mail4rashid@gmail.com>; 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
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Re: Postgres database as a client/server architecture Rich <rhdyes@gmail.com>
@ 2008-10-06 15:08 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 17:54 ` Re: Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 18:34 ` Re: Postgres database as a client/server architecture Montaseri <montaseri@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: Scott Marlowe @ 2008-10-06 15:08 UTC (permalink / raw)
To: Rich <rhdyes@gmail.com>; +Cc: Mohammed Rashid <mail4rashid@gmail.com>; pgsql-admin
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...
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Re: Postgres database as a client/server architecture Rich <rhdyes@gmail.com>
2008-10-06 15:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-10-06 17:54 ` Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 18:45 ` Re: Postgres database as a client/server architecture Jonah H. Harris <jonah.harris@gmail.com>
2008-10-07 17:49 ` Re: Postgres database as a client/server architecture Shane Ambler <pgsql@Sheeky.Biz>
1 sibling, 2 replies; 9+ messages in thread
From: Mohammed Rashid @ 2008-10-06 17:54 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Rich <rhdyes@gmail.com>; pgsql-admin
Hi All,
I think there is some confusion regarding this.
I want postgres to be installed at two different PCs.Then the data
from each postgres should be automatically updated to the third PC
which we call server.
This process should be automatic. It should also take care of network
disconnection between client and server.
After establishment of network connections the remaining data should
be automatically updated to the server.
It is bit different from the mirroring of databases, but the concept is same.
I just want to ask whether the Postgres database supports this or not?
Or I have to write an application to do so.
I am hoping to read soon from you.
Thanks for your response.
Regards,
Rashid
On Mon, Oct 6, 2008 at 7:08 PM, 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...
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Re: Postgres database as a client/server architecture Rich <rhdyes@gmail.com>
2008-10-06 15:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 17:54 ` Re: Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
@ 2008-10-06 18:45 ` Jonah H. Harris <jonah.harris@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Jonah H. Harris @ 2008-10-06 18:45 UTC (permalink / raw)
To: Mohammed Rashid <mail4rashid@gmail.com>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; Rich <rhdyes@gmail.com>; pgsql-admin
On Mon, Oct 6, 2008 at 1:54 PM, Mohammed Rashid <mail4rashid@gmail.com> wrote:
> I just want to ask whether the Postgres database supports this or not?
> Or I have to write an application to do so.
Not natively. You could do it via some Slony trickery, but it would
be very advanced and difficult to manage.
--
Jonah H. Harris, Senior DBA
myYearbook.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Re: Postgres database as a client/server architecture Rich <rhdyes@gmail.com>
2008-10-06 15:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 17:54 ` Re: Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
@ 2008-10-07 17:49 ` Shane Ambler <pgsql@Sheeky.Biz>
1 sibling, 0 replies; 9+ messages in thread
From: Shane Ambler @ 2008-10-07 17:49 UTC (permalink / raw)
To: Mohammed Rashid <mail4rashid@gmail.com>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; Rich <rhdyes@gmail.com>; pgsql-admin
Mohammed Rashid wrote:
> Hi All,
>
> I think there is some confusion regarding this. I want postgres to be
> installed at two different PCs.Then the data from each postgres
> should be automatically updated to the third PC which we call server.
> This process should be automatic. It should also take care of
> network disconnection between client and server. After establishment
> of network connections the remaining data should be automatically
> updated to the server. It is bit different from the mirroring of
> databases, but the concept is same.
>
> I just want to ask whether the Postgres database supports this or
> not? Or I have to write an application to do so.
>
I think this sounds like you want a server in the office and the two
clients are maybe laptops that want to synchronise changes between their
own data and the office server when they come into the office. So they
would send changes to the server as well as receive changes from the server.
This case of intermittent network connections isn't usually handled by
replication options so would be a custom setup by you. To automate the
task you want some sort of heartbeat monitor to detect the presence of
the server and perform the synchronising.
You will either want a list of changed records per client or modified
timestamps to determine what has changed since the last synchronise, as
well as define actions upon conflicts.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Re: Postgres database as a client/server architecture Rich <rhdyes@gmail.com>
2008-10-06 15:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-10-06 18:34 ` Montaseri <montaseri@gmail.com>
2008-10-07 04:40 ` Re: Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Montaseri @ 2008-10-06 18:34 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Rich <rhdyes@gmail.com>; Mohammed Rashid <mail4rashid@gmail.com>; pgsql-admin
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
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres database as a client/server architecture
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Re: Postgres database as a client/server architecture Rich <rhdyes@gmail.com>
2008-10-06 15:08 ` Re: Postgres database as a client/server architecture Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 18:34 ` Re: Postgres database as a client/server architecture Montaseri <montaseri@gmail.com>
@ 2008-10-07 04:40 ` Mohammed Rashid <mail4rashid@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Mohammed Rashid @ 2008-10-07 04:40 UTC (permalink / raw)
To: Montaseri <montaseri@gmail.com>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; Rich <rhdyes@gmail.com>; 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
> >
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2008-10-07 17:49 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-06 06:23 Postgres database as a client/server architecture Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 14:08 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 15:00 ` Rich <rhdyes@gmail.com>
2008-10-06 15:08 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-10-06 17:54 ` Mohammed Rashid <mail4rashid@gmail.com>
2008-10-06 18:45 ` Jonah H. Harris <jonah.harris@gmail.com>
2008-10-07 17:49 ` Shane Ambler <pgsql@Sheeky.Biz>
2008-10-06 18:34 ` Montaseri <montaseri@gmail.com>
2008-10-07 04:40 ` Mohammed Rashid <mail4rashid@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox