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

connecting pgadmin3 to the postgres

From: "Kevin B(dot)" <db(at)ke5in(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: connecting pgadmin3 to the postgres
Date: 2004-11-12 15:44:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Date:   	Fri, November 12, 2004 10:33 am
To:   	pgadmin-support(at)postgresql(dot)orgc
Priority:   	Normal
Options:   	View Full Header |  View Printable Version


I'm trying connect pgadmin3 to the postgres 7.4.2 server running on the
same computer but I am unable to do it. I am using the default fc2 install
of postgresql.  The postgres service is running and from the terminal I am
able to connect via psql.
[root(at)localhost root]# su - postgres
-bash-2.05b$ psql test
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

test=# exit
test-# \q
-bash-2.05b$ exit

I started pgadmin3 from a root terminal and into the "Connected to a
server"  dailog I entered:
Description: x
Server: localhost
Port: 5432
Inital database: test
Trusted: UNchecked
Password: (left it blank)

Upon clicking the OK button I got:
An error has occured:
Error connecting to the server: FATAL: no pg_hba.conf entry for host
"", user "postgres", database "test", SSL off

But in the pg_hba.conf file there is this line:
local  all    all             ident   sameuser
which I thought would allow any type of connection to the postgres server
from the local machine.

Thanks for any help.


pgadmin-support by date

Next:From: Kevin B.Date: 2004-11-12 16:22:53
Subject: Re: connecting pgadmin3 to the postgres
Previous:From: Serdar OKTEMDate: 2004-11-11 13:26:34
Subject: Win xp installation Help

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