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: | 32799.67.87.27.161.1100274267.squirrel@www.ke5in.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
Hi,
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
logout
------------------------------------
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
Username:postgres
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
"127.0.0.1", 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.
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin B. | 2004-11-12 16:22:53 | Re: connecting pgadmin3 to the postgres |
Previous Message | Serdar OKTEM | 2004-11-11 13:26:34 | Win xp installation Help |