Re: [GENERAL] Two Machines - Question

On Mon, 15 Feb 1999, Paul Nelson wrote:

> Can I run Postgres on one machine (Linux) and access it from another
> machine (Linux / Apache web server)?
>

I haven't tried the Apache interface but it can't image there being any
troubles. I myself have used libpg, ecpg, and psql from remote clients
without trouble once the postgresql server is configured to accept remote
connections from that client.

The libpg, ecpg both accept the server name or IP address as part of their
connect string, I bet that the apache module does as well.

psql works like this

psql -h servername.domain.org -u databasename
-h provides the host name or ip address
-u forces pgsl to request username/password (I need this since I use
crypt authentication)

Hope this helps

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561
Kansas State University Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<