Problem Adding A PostgreSQL Server in Debian

Поиск
Список
Период
Сортировка
От Sunburned Surveyor
Тема Problem Adding A PostgreSQL Server in Debian
Дата
Msg-id 71097ae20512161457p31bf483ar401936d060274c3c@mail.gmail.com
обсуждение исходный текст
Ответы Re: Problem Adding A PostgreSQL Server in Debian
Список pgadmin-support
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial">I'veinstalled PostgreSQL, and set it up with a user that has the same user name and password as one of the Linux
Users.I have no problem logging into the psql terminal with the user via the command line. Once I am logged into psql,
Ican execute the CREATE DATABASE and CREATE TABLE commands with no problem. </span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font><font face="Arial" size="2"><span
style="FONT-SIZE:10pt; FONT-FAMILY: Arial">However, when I tried to add a server in pgAdmin3 with the same user and
password,I get this error: </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt;
FONT-FAMILY:Arial"> </span></font><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">"An
errorhas occurred:</span> </font><p class="MsoNormal"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt;
FONT-FAMILY:Arial"></span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt;
FONT-FAMILY:Arial">Error connecting to the server: FATAL:IDENT authentication failed for user "myuser"
"</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY:
Arial"> </span></font><fontface="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have checked my
pg_hba.conffile and everything appears to be as it should be. (Although I'm not an expert, and I could be missing
something.)It is set up to accepts all connections from the local machine. </span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font><font face="Arial" size="2"><span
style="FONT-SIZE:10pt; FONT-FAMILY: Arial">Do you guys have any suggestions for me? I'm thinking the problem is with
pgAdmin3,since I can connect to PostgreSQL via the psql terminal with no problems, but I'm not sure. </span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I'm running the latest
stableversion of both PostgreSQL and pgAdmin3. </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="FONT-SIZE:10pt; FONT-FAMILY: Arial"></span></font><font face="Arial" size="2"><span style="FONT-SIZE: 10pt;
FONT-FAMILY:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt;
FONT-FAMILY:Arial">The Sunburned Surveyor</span></font><p class="MsoNormal"> </div> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: PgAdmin3 1.4.1 on Mac OSX 1.4.1 is unusable....
Следующее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: PgAdmin3 1.4.1 on Mac OSX 1.4.1 is