From: | typing80wpm(at)aol(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | p2p ip connection problems |
Date: | 2005-04-29 20:40:57 |
Message-ID: | 8C71B12E1B5E483-BF8-22849@MBLK-M29.sysops.aol.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I can connect to the database on the server machine using pgadminIII
and, it installed as a windows service. And I created one test database called usfo
I have not succeeded in getting it to work yet using pg explorer from another client machine on the p2p.
I followed Tony's suggestions
namely
In pg_hba.conf
I added
host all all 192.0.0.101/32 md5
(my client machine is 192.0.0.101)
and I changed postgresql.conf to say
listen_addresses = '*'
========================
PG Explorer on my client is asking for:
COMMON NAME: ??? (I am uncertain about this)
HOST: 192.0.0.9
Default database: ??? (I am uncertain about this)
Database port: 5432
======================================
I know absolutely ZERO about any of this stuff.
All I know is to go to the DOS prompt and key in
IPCONFIG and it tells me, on the machine I want to
use as client, IP Address 192.0.0.101, subnet mask
255.255.255.0 default gateway 192.0.0.254
and on the machine which has postgresql for
windows, if I do ipconfig, it says...
IP address 192.0.0.9
subnet mask 255.255.255.0
default gateway 192.0.0.254
Our company has ZERO money to give to consultants,
so please dont suggest that. If I cant figure out
how to make this work, then we just live without
it. But it would give me a tremendous sense of
personal satisfaction to prove to myself that
postgresql can work on this little p2p network, and
I could do one or two useful things to help the
office.
There MUST be some little command I can run to tell
me the secret numbers and how to plug them into the
config files for postgresql. It can be rocket
science.
I can tell you that we have a Xyzel router to bring
in the DSL, and a Cisco Linksys hub... if that gives
any clues.
From | Date | Subject | |
---|---|---|---|
Next Message | typing80wpm | 2005-04-29 21:28:09 | more experiments with p2p ip connection |
Previous Message | Joshua D. Drake | 2005-04-29 19:50:47 | Re: Tuning queries inside a function |