Re: [GENERAL] Two Machines - Question - Mailing list pgsql-general

From James Thompson
Subject Re: [GENERAL] Two Machines - Question
Date
Msg-id Pine.LNX.4.10.9902151048250.619-100000@hobbes.math.ksu.edu
Whole thread Raw
In response to Two Machines - Question  ("Paul Nelson" <pjnelson@iwaynet.net>)
List pgsql-general
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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<



pgsql-general by date:

Previous
From: "Paul Nelson"
Date:
Subject: Two Machines - Question
Next
From: Gilles Darold
Date:
Subject: Re: [GENERAL] Two Machines - Question