Thread: client-server connection
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. thanks for any idea. ramon __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
am 15.12.2005, um 0:34:45 -0800 mailte Ramon Orticio folgendes: > 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. Yes. > > 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. I don't know gambas, but i found via Google and 'gambas postgresql' many sites like http://packages.debian.org/unstable/libdevel/gambas-gb-db-postgresql > > can the PGDATA(var/lib/pgsql/data) file be exported > using NFS and mounted on the client computer? how do i No, bad idea. > connect from the client. http://www.binara.com/gambas-wiki/bin/view/Gambas/WebSiteFAQ HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
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