Welcome, Guest. Please login or register.

Login with username, password and session length
Forums Search:  


Author Topic: PostgreSQL Setup Problem  (Read 3859 times)

dbecks

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
    • View Profile
PostgreSQL Setup Problem
« 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

savage

  • Mapper
  • ***
  • Posts: 113
  • Karma: 0
    • View Profile
Re: PostgreSQL Setup Problem
« Reply #1 on: August 19, 2008, 10:37:23 AM »
The tutorial is wrong. I think you have to install it as a 'service'.

dbecks

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
    • View Profile
Re: PostgreSQL Setup Problem
« Reply #2 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?

-Oz-

  • Map Maker!
  • Administrator
  • Expert Advisor
  • *****
  • Posts: 1577
  • Karma: 27
    • View Profile
    • GPSFileDepot
Re: PostgreSQL Setup Problem
« Reply #3 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
« Last Edit: August 19, 2008, 06:08:01 PM by -Oz- »
Dan Blomberg
Administrator - GPSFileDepot
GPS Units: Garmin Dakota 20, Garmin GPSMap 60csx, Nuvi 255W, Nuvi 250W, ForeRunner 110, Fenix 2, Tactix Bravo, Foretrex 401
See/Download My Maps!

 

anything