Thread: Re: Bug Report: PgAdmin -> pg_hba.conf Editor
Hello: I am new to PostgreSQL, though I have been working with several databases since I began developing distributed systems (SQLServer, Oracle, Sybase). I have been interested in PostgreSQL as an alternative to the commercial level engines I have used. I finally began working with it the other day and successfully installed it on my Windows 2003 Server at home. Along withit I also installed PgAdmin for database administration and development purposes. Once everything was up and running I then installed PgAdmin on my primary workstation so that I could use it to develop mydatabase associated components along with my projects in .NET. Here is where my problems began with the connectivity. Practically all of the issues were related to a damaged pg_hba.conf file on my server. However, try as I might to correctthe settings via the corresponding editor, my connection problems on my workstation persisted. I had noticed that the pg_hba.conf editor in PgAdmin was not responding properly to saves and edits of my entries as manytimes when I brought the data back up, entries I had just made were missing. I finally decided to look at the pg_hba.conf file in a text editor since I couldn't seem to eliminate my connection issuewhich was always reporting errors with this configuration file. What I found was a file that contained entries thatI had previously deleted while also showing an entry that appeared to be incorrectly formatted. I cleaned up the filemanually and was able to eliminate the connectivity issue and successfully connect from my workstation. As a person new to the PostgreSQL database this issue should be of concern since it involves connectivity. I would recommendthe following: 1) Review the processing of the pg_hba.conf file editor in PGAdmin for its accuracy since it appears to be rather inaccurate currently. 2) Provide more in-depth documentation in terms of working with this particular configuration file. Right now the most important set of parameters, the IP address and the mask, are poorly clarified. There shouldbe far more examples than those already being shown along with concise descriptions how to provide IP addressesfor a multitude of scenarios along with descriptions as to how to associate them with the correct mask. Steve Naidamast blackfalconsoftware@ix.netcom.com
On Wed, Jun 11, 2008 at 5:50 PM, Black Falcon Software, Inc. <blackfalconsoftware@ix.netcom.com> wrote: > 1) Review the processing of the pg_hba.conf file editor in PGAdmin for its accuracy since it appears to be rather inaccurate > currently. I've just spent the last 20 minutes trying to break it and have so far failed. What sort of edits have you been making? Anything particularly unusual? What pgAdmin version are you running, and on what OS & version on your primary workstation? Are you editing the file via the filesystem (ie. from the File menu), or via a database connection (ie. from the Tools menu)? > 2) Provide more in-depth documentation in terms of working with this particular configuration file. Right now the mostimportant > set of parameters, the IP address and the mask, are poorly clarified. There should be far more examples than thosealready being > shown along with concise descriptions how to provide IP addresses for a multitude of scenarios along with descriptionsas to how to > associate them with the correct mask. The pgAdmin team are not responsible for the documentation of the server so you're complaining in the wrong place I'm afraid. What do you need clarification on the address for though? It's just standard CIDR notation for matching an address or subnet of addresses and is documented quite thoroughly in the docs (http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
> 1) Review the processing of the pg_hba.conf file editor in PGAdmin for its accuracy since it appears to be rather inaccurate
> currently.
Long back, I also came across similar type of problem and did the same thing(look at the pg_hba.conf file in a text editor and delete unwanted entries), here is the thread wherein i posted similar type of solution for Jose, who had similar kind of problem.
http://www.mail-archive.com/pgadmin-support@postgresql.org/msg08003.html
.would be great if Jose Esquivel could share his View.
Thanks
> currently.
Long back, I also came across similar type of problem and did the same thing(look at the pg_hba.conf file in a text editor and delete unwanted entries), here is the thread wherein i posted similar type of solution for Jose, who had similar kind of problem.
http://www.mail-archive.com/pgadmin-support@postgresql.org/msg08003.html
.would be great if Jose Esquivel could share his View.
Thanks
On Wed, Jun 11, 2008 at 9:47 PM, Dave Page <dpage@pgadmin.org> wrote:
On Wed, Jun 11, 2008 at 5:50 PM, Black Falcon Software, Inc.I've just spent the last 20 minutes trying to break it and have so far
<blackfalconsoftware@ix.netcom.com> wrote:
> 1) Review the processing of the pg_hba.conf file editor in PGAdmin for its accuracy since it appears to be rather inaccurate
> currently.
failed. What sort of edits have you been making? Anything particularly
unusual? What pgAdmin version are you running, and on what OS &
version on your primary workstation? Are you editing the file via the
filesystem (ie. from the File menu), or via a database connection (ie.
from the Tools menu)?The pgAdmin team are not responsible for the documentation of the
> 2) Provide more in-depth documentation in terms of working with this particular configuration file. Right now the most important
> set of parameters, the IP address and the mask, are poorly clarified. There should be far more examples than those already being
> shown along with concise descriptions how to provide IP addresses for a multitude of scenarios along with descriptions as to how to
> associate them with the correct mask.
server so you're complaining in the wrong place I'm afraid. What do
you need clarification on the address for though? It's just standard
CIDR notation for matching an address or subnet of addresses and is
documented quite thoroughly in the docs
(http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html).
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support