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 по дате отправления: