Skip site navigation (1) Skip section navigation (2)

Re: I neen help establishing a connection to my PostgreSQL database.

From: "Bender, Cheryl" <cbender(at)mriresearch(dot)org>
To: "Maurice Menefee" <maurice(dot)menefee(at)briteskies(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: I neen help establishing a connection to my PostgreSQL database.
Date: 2005-02-02 00:20:24
Message-ID: 12A8E91E9D5E804DA82CA5199BC4C56211ED7F@exchtemp.mri-kc.int (view raw or flat)
Thread:
Lists: pgsql-admin
By default the postmaster in Windows listens for TCP/IP connections only
on the loopback interface.  

 

Take a look at your conf files (postgresql.conf and pg_hba.conf).
Postgresql.conf probably needs to have a line added something like this:

 

listen_addresses = '*'     # what IP interface(s) to listen on; 

                                                # defaults to localhost,
'*' = any

 

I suspect when you try to connect via ODBC it is not using 'Localhost'
even if it is on the same machine. 

 

Cheryl Bender

  _____  

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Maurice Menefee
Sent: Monday, January 31, 2005 2:28 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] I neen help establishing a connection to my PostgreSQL
database.

 

Any help that you could give would be greatly appreciated.

 

I'm running PostgreSQL 8.0 on Windows 2003.

 

When I attempt to connect to the database using Access and ODBC from a
Windows 2000 host I get:

            "Could not connect to remote socket"

 

I believe that this problem is due to the fact that postmaster was not
ran with the -i option.

 

How do I run postmaster with the -i option on Windows 2003?

 

 Thanks.

 

 

pgsql-admin by date

Next:From: Dave VieglaisDate: 2005-02-02 00:42:59
Subject: client authentication problem
Previous:From: Pallav KalvaDate: 2005-02-01 19:47:40
Subject: Re: Online Backup and WAL archives

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group