Skip site navigation (1) Skip section navigation (2)

Re: client-server connection

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Ramon Orticio <rporticio(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: client-server connection
Date: 2005-12-15 11:52:01
Message-ID: 1134647521.25886.14.camel@braydb.bray-healthcare.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, 2005-12-15 at 00:34 -0800, Ramon Orticio wrote:
> dear friends,
> 
> how can postgres be set up as a backend database
> server and be accessed
> by client computers. All of the computers are using
> redhat9 OS.
> 
> the client computer has an application software - i'm
> planning to use gambas which has similarity to
> microsoft vb and it will access the postgres database
> from the server.
> 
> can the PGDATA(var/lib/pgsql/data) file be exported
> using NFS and mounted on the client computer? how do i
> connect from the client.

You must not do that.  The data directory is managed by the server
process (postmaster) using shared memory.  Your application should
communicate with the server by a TCP/IP connection on port 5432 (by
default).  Presumably the client library is built into gambas - if not
you will perhaps be able to use ODBC instead.

Oliver Elphick


In response to

pgsql-novice by date

Next:From: meDate: 2005-12-15 12:04:47
Subject: Re: GUID function in pgsql?
Previous:From: Norberto MeijomeDate: 2005-12-15 11:51:14
Subject: Re: GUID function in pgsql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group