Server - Client Application

[chitranjan]

Hello
I am working on PostgreSQL-8.2.4 ,and OS is fedora-6. There are other 3 systems ,having same OS(fedora-6) .Actually, i am new in postgresql .I have already installed postgreSQL-8.2.4 on my system successfully . But I do'nt have any idea that ,how can i make server- clients .There are 4 systems , I want make one system as a server and other as a client .So explain me step by step thatswhile i can make server - client network. I want to make my system(Already having postgresql-8.2.4) as a client and other one as a server.

Explain me in detail ........ or it may be step by step installatins of server and
client........

Thanks in Advance
Chitranjan Singh

[michaelb]

Client/Server application with Postgresql does not need to have multiple database installations.
Unless what you have in mind is some kind of master/slave multi-server system, all you need is just one database server.

Talking about clients there are many different ways to implement the client side, and it is up to you to design the implementation you want, so let's start with how you intend to use your client/server database system, what tools you have at your disposal and what programming languages you are familiar with.

[chitranjan]

Client/Server application with Postgresql does not need to have multiple database installations.
Unless what you have in mind is some kind of master/slave multi-server system, all you need is just one database server.

Talking about clients there are many different ways to implement the client side, and it is up to you to design the implementation you want, so let's start with how you intend to use your client/server database system, what tools you have at your disposal and what programming languages you are familiar with.

Thanks for replying ,please tell me ways to make client . Is there any setting to make client or the same step of installation on client system . I want to fire query and want to use PL/pgSQL from client side and main thing i want to do benchmarking(performance metrics).

Thanks in advance
chitranjan singh

[michaelb]

Anything other than connecting directly to the backend process would make some kind of client/server scenario.
Since you don't seem to have any specific requirements perhaps you should start with psql , which is the simplest client interface to the database, most importantly it does not require anything from you - it's already there and you can use it.

[chitranjan]

Anything other than connecting directly to the backend process would make some kind of client/server scenario.
Since you don't seem to have any specific requirements perhaps you should start with psql , which is the simplest client interface to the database, most importantly it does not require anything from you - it's already there and you can use it.

I am connecting LINUX(Fedora6) based computers through ssh , like SSH 192.168.x.x from client side (SSH IP Address) and then
psql [database]
it is connected and working fine ..
Is it client / server application ?, please explain me..
Through SSH ,I think ,it is accessing my whole PC ,if we given the root login and password or If we given postgres login and password(PC having installed PostgreSQL) it will accessing whole database same as server....please short out my problem.....and explain me step by step...
if we connecting through "SSH" , is it become client/server ? please explain..

Thanks in Advance
Chitranjan Singh.

[michaelb]

SSH, PC and UNIX are not important - client and the server do not have to be on different machines.
Think of it as a two-piece construct; the database server is running and always listening for the clients. The psql terminal that you are using is one such client.
Of course it is more common to have an application, or a web server talking to the database server, but there's nothing wrong with psql. Actually, it is perfect if you're just starting learning Postgresql.