I'd like to install mapnik to serve up a subset of the Open Street Map database on Debian 7.0, Wheezy. In order to do that I need PostgreSQL and PostGIS.
Following the instructions for Wheezy at https://wiki.openstreetmap.org/wiki/PostGIS/Installation, I set up postgreSQL. When I run instructions that use the postgres user "gisuser" I get the following error: Error: Connection to database failed: FATAL: Peer authentication failed for user "gisuser" I then set up a .pgpass file as follows: # hostname:port:database:username:password *:*:gis:gisuser:gisuser and ran: echo "ALTER USER gisuser WITH PASSWORD 'gisuser';" | psql -d gis which ran successfully. Still no joy. Ideas? -- The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no Warrants shall issue, but upon probable cause, supported by Oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. -- U.S. Const. Amendment IV Key fingerprint = CE5C 6645 A45A 64E4 94C0 809C FFF6 4C48 4ECD DFDB /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
