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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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/...-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/bi...bas/WebSiteFAQ


HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org