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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<