| From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> | 
|---|---|
| To: | wwwadmin(at)wizard(dot)ca, pgsql-admin(at)hub(dot)org, pqsql-questions(at)hub(dot)org | 
| Subject: | RE: [ADMIN] Trying to communicate to remote host via PG | 
| Date: | 1998-05-11 15:08:58 | 
| Message-ID: | F10BB1FAF801D111829B0060971D839F278ABA@dal_cps.cpsgroup.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
Are you running the postmaster with the -i option?
It needed to do TCP/IP connections.  Without the -i option postgres will
only accept Unix socket communication which as I understand it can only
be done from localhost.
Hope this helps,
		-DEJ
> Well, I have a nice little database that runs quite well, via a web
> interface..
> Moved the webpages and Cgi's to my production machaine, and can't
> access
> 
> the postmaster server...
> I edited the pg_hba.conf file to allow access from the IP, and used
> the
> trust method to get it up and running..(Do I need it in my
> /etc/services
> 
> file?)
> I have changed the connect line in my script to include the dbhost=
> option as below..
> $conn=PG::connectdb("dbhost=<xxx.xxx.xxx.xxx>, dbname=<name>");
> ------------
> I can access it via the command line, as the same user....
> psql -h <xxx.xxx.xxx.xxx> -d <name>
> 
> Any help?
> 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernhard Ertl | 1998-05-11 15:09:04 | [Fwd: psql binaries] | 
| Previous Message | The Web Administrator | 1998-05-11 14:32:27 | Trying to communicate to remote host via PG |