Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error connecting to PgSQL server

Error connecting to PgSQL server

From
Date:
Hello,
I am writing to you because I need some advice. I have a Mandrake 10 box running PgSQL server, Webmin, PgAdmin, and
PgAccess.I used Webmin to start up the server, configured the allowed hosts and users, connects all ok. The data I
enteredis: 

Allowed Hosts

Local Connections     All databases    All users   No authentication


Users       Requires pass?       Can create databases?              Can create users?            Valid until

postgres         No                                    Yes                                       Yes
      Forever 
root                 No                                    Yes                                       Yes
          Forever 

Webmin detects the server ok, and all works. But pgAdmin tells this error:

Error connecting to the server. Connection refused.
Is the server running on host 127.0.0.1 and accepting TCP/IP connections on port 5432?


I don't know why pgAdmin says this. pgAccess does the same thing.

Hope you can guide me in solving this thing.
Thanks in advance.


Juan

__________________________________________________

Datafull - 100% Internet Gratis
http://www.datafull.com

Re: Error connecting to PgSQL server

From
Devrim GUNDUZ
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Fri, 11 Jun 2004 jcostello@datafull.com wrote:

> I am writing to you because I need some advice. I have a Mandrake 10 box ru=
> nning PgSQL server, Webmin, PgAdmin, and PgAccess.

<snip>

> Webmin detects the server ok, and all works. But pgAdmin tells this error:
>
> Error connecting to the server. Connection refused.
> Is the server running on host 127.0.0.1 and accepting TCP/IP connections on=
>  port 5432?
>
> I don't know why pgAdmin says this. pgAccess does the same thing.

You should edit postgresql.conf and allow tcp_ip socket connections. Don't
forget to restart PostgreSQL server after this change.

BTW, 7.5 will ship with tcp_ip connections enabled for localhost...

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org                devrim.gunduz~linux.org.tr
            http://www.tdmsoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFAyvI6tl86P3SPfQ4RAv0wAKC4FX6DpZ7ep2ZX+2YaAn0kV6BgogCgsLB6
swmMse58XLxt5u+6Dd1ckYc=
=uyM8
-----END PGP SIGNATURE-----