GPSFileDepot Forums

General Category => Map Making Support => Topic started by: dbecks on August 19, 2008, 09:59:54 AM

Title: PostgreSQL Setup Problem
Post by: dbecks on August 19, 2008, 09:59:54 AM

Greetings folks,

First off, thanks for the great tutorial on map creation. I am currently working on the Minnesota Map, and am stuck on the Setup of the PostgreSQL program.   

The tutorial reads as:
"# Open pg_hba.conf (start>all programs>postgresql X.X>Configurations Files>Edit pg_hba.conf
# Change the line reading:
host    all         all         127.0.0.1/32          md5
to
host    all         all         127.0.0.1/32          trust
# Reload the configuration files (start>all programs>postgresql X."

However, when I goto the edit config files, it states that there is no path?

When I also try and load a server, there is nothing available but <remote server>

any help would be greatly appreciated.

Thanks for all the help already

Title: Re: PostgreSQL Setup Problem
Post by: savage on August 19, 2008, 10:37:23 AM

The tutorial is wrong. I think you have to install it as a 'service'.

Title: Re: PostgreSQL Setup Problem
Post by: dbecks on August 19, 2008, 11:14:24 AM

so that worked... but now every time I try and to convert the shapefiles in command prompt I get an access denied error.. any ideas folks?

Title: Re: PostgreSQL Setup Problem
Post by: -Oz- on August 19, 2008, 06:05:29 PM

did you set a password?

And converting shouldn't give you access denied because thats just a command that doesn't access the database at all.  Have you rebooted?  Are you using the same username that installed the program?  Do you have write permissions to wherever is trying to save the file?

and i've updated the tutorial