I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server,
the other Windows XP Pro); I have Postgres up and running as a service on
both machines, no problem. I'm even able to go into psql and putz around.
However, I am not able to log on remotely using pgAdmin III. Whenever I
attempt to add a server, I get the following message:
An error has occurred:
Error connecting to the server: could not connect to the server: Connection
refused (0x0000274D/10061)
Is the server running on host "nnn.nnn.nnn.nnn" and accepting
TCP/IP connections on port 5432?
The answer is, yes the server is running on the host, and there are no
restrictions on either machine for port 5432. It fails in both directions.
The machines can see each other on the network.
Thanks in advance for all your help.
Mark Taber
State of California
Department of Finance
Infrastructure & Architecture Unit
916.323.3104 x2945 2 3974
"Taber, Mark" <Ma********@dof.ca.gov> writes: Error connecting to the server: could not connect to the server: Connection refused (0x0000274D/10061)
That means the operating system rejected the connection, which probably
means a firewall/packet filter problem. If the request had made it as
far as the postmaster, you'd have gotten a different response.
The answer is, yes the server is running on the host, and there are no restrictions on either machine for port 5432.
I think you're dead wrong on that last assertion.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Taber, Mark wrote: I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the other Windows XP Pro); I have Postgres up and running as a service on both machines, no problem. I’m even able to go into psql and putz around. However, I am not able to log on remotely using pgAdmin III. Whenever I attempt to add a server, I get the following message:
An error has occurred:
Error connecting to the server: could not connect to the server: Connection refused (0x0000274D/10061)
Is the server running on host “nnn.nnn.nnn.nnn” and accepting
TCP/IP connections on port 5432?
The answer is, yes the server is running on the host, and there are no restrictions on either machine for port 5432. It fails in both directions. The machines can see each other on the network.
Thanks in advance for all your help.
**Mark Taber**
State of California
Department of Finance
Infrastructure & Architecture Unit
916.323.3104 //x//294
On the off-chance that you're running ZoneAlarm, make sure that postgres
is allowed to run as a server.
Ron
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: wibawanto |
last post by:
Can I install Posgresql on slackware linux? This package doesn't
include with slackware. I have visited on postgresql website, but it
only for Red Hat linux. Where can I get postgresql for Slack?
|
by: Bill Grigg |
last post by:
Gentlemen,
I am hoping to be able to use GForge on my windows PC. To that end I
have installed:
1. cygwin
2. reinstalled cygwin and selected cygipc, postgreSQL and a few other
things
3. PHP...
|
by: NK |
last post by:
Trying to install Postgresql 7.3.4 using the Cygwin(the last version) , I followed all the instructions.
After typing the "" ./configure "" command, I typed "" make "" (i have installed the GNU...
|
by: Carmen Wai |
last post by:
Hello:
I would like to know whether there is any different in installing Postgresql
on the Linux system with file system of EXT2 or EXT3. I have two machines
with idential OS (Red Hat 7.3...
|
by: Wei Wang |
last post by:
hi,
I just took over a project done by somebody else of some C extension of
Postgresql 7.1.3. And now I have to port it to pl/pgsql. The guy who
developed it said he didn't get it running under...
|
by: phil campaigne |
last post by:
Tom Lane wrote:
> phil campaigne <pcampaigne@charter.net> writes:
>
>
>> when I login to linux and check the env's I see:
>>...
|
by: Mike Cox |
last post by:
Has anyone created something like that for Postgresql? It would be
really handy to encrypt credit card numbers and other information so
it stays secure.
If no one has created anything such as...
|
by: Karl O. Pinc |
last post by:
These seem to work. I'm posting them now before I'm done with
them before I start messing them up with specifics to my database.
Any comment is welcome. However, I've no intention of publishing...
|
by: SmoothJazz |
last post by:
Hi All!
I am wanting to setup/run PostgreSQL on my server (a SuSE Linux 9.2 distro)
but I'm not quite sure which way to go.
I have a few books on PostgreSQL but they don't seem to match the...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |