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.