[postgis-users] Installation Error

Zedler, Doug Doug.Zedler at fortworthgov.org
Thu Oct 4 07:43:05 PDT 2007


Thanks for the help and the info.
 

Douglas B. Zedler

IT Programmer/Analyst

Fort Worth Fire Department

817.392.8463
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe,
Regina
Sent: Thursday, October 04, 2007 9:41 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Installation Error


Yes anyone logging on to this computer has full access to the database.
For me it isn't too much of a concern since I manage the servers I have
and for development I'm not too concerned about people I don't know
logging into my computer.  
 
If you are concerned about it, you can always switch the setting back. 
 
Thanks,
Regina
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Zedler, Doug
Sent: Thursday, October 04, 2007 10:34 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Installation Error


Regina,
 
I have a password manager, so each time I enter the password (in pgAdmin
or in the PostGIS installation wizard), I copy it from the password
manager.  Maybe the wizard has a problem with pasting the password in.
 
Your work around worked.  It seems to have installed successfully.  So,
you always have trust authentication for localhost?  Does that mean
anyone logging on to this computer has full access to the database?
 
Douglas B. Zedler

IT Programmer/Analyst

Fort Worth Fire Department

817.392.8463
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe,
Regina
Sent: Thursday, October 04, 2007 9:16 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Installation Error


Doug,
 
Strange.  Not typing in the right password or typing in the password in
the wrong case is the only reason I can think why you would get the
below error.
 
As a work-around - what you could do (which I do anyway) is to set the
authentication to trust for localhost.  To do that do the following
 
1) You can do it from pgAdmin ->Tools -> Server configuration ->
pg_hba.conf   
and add or check the line that says 
 
host   all all 127.0.0.1/32  trust
 
Alternatively which sometimes I find easier - just open up the
pg_hba.conf file usually located in or wherever you chose to store your
data
 
C:\Program Files\PostgreSQL\8.2\data
 
and  make sure you have an uncommented line (comment is #) that reads
 
host    all         all         127.0.0.1/32          trust
 
Then restart your postgresql service from services manager.
 
When you install - as long as you type in a real account and you are
directly on the server, whatever password you type in will be ignored
and the connection will be trusted.
 
Hope that helps,
Regina
 
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Zedler, Doug
Sent: Wednesday, October 03, 2007 11:03 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Installation Error


I'm trying to install PostgreSQL and PostGIS to play with it and learn
about it.  I installed PostgreSQL 8.2.4 just fine.  I am able to connect
using pgAdmin III and such.  When I run the PostGIS 1.3.1 installation
executable, I get the following error:
 
createdb: could not connect to database postgres: FATAL:  password
authentication failed for user "postgres"
 
I am able to connect to the postgres database using pgAdmin III under
the postgres role using the same password I'm putting into the
installation wizard, and I'm not mixing up the password for the database
role with the password for the local account on my machine.  Any
suggestions are appreciated.
 
Thanks,
 

Douglas B. Zedler

IT Programmer/Analyst

Fort Worth Fire Department

817.392.8463
 

________________________________

The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure pursuant
to Massachusetts law. It is intended solely for the addressee. If you
received this in error, please contact the sender and delete the
material from any computer. 

________________________________

The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure pursuant
to Massachusetts law. It is intended solely for the addressee. If you
received this in error, please contact the sender and delete the
material from any computer. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071004/9e7ac16d/attachment.html>


More information about the postgis-users mailing list