[Talk-GB] Help with postgres

I've been working through all the disjointed installation guides in order to set up mapnik to run my own server, but while I'm fairly happy that everything is now in place, generate_tiles.py is giving me an authentication error. I had some fun at various points, and I'm installing onto an

Re: [Talk-GB] Help with postgres

When I did this, many years ago, I used something like: createuser -S -D -R apache echo GRANT ALL ON SCHEMA PUBLIC TO apache; | psql gis echo grant all on geometry_columns to apache; | psql gis echo grant all on spatial_ref_sys to apache; | psql gis I'm using

Re: [Talk-GB] Help with postgres

Keith Sharp wrote: When I did this, many years ago, I used something like: createuser -S -D -R apache echo GRANT ALL ON SCHEMA PUBLIC TO apache; | psql gis echo grant all on geometry_columns to apache; | psql gis echo grant all on spatial_ref_sys to apache; |

Re: [Talk-GB] Help with postgres

Lester Caine wrote: Not helping :( Panic over! Just needed to re-read the http://wiki.openstreetmap.org/wiki/Mapnik#Authentication_failure note ... I'd missed that the xml file was generated without a -user setting ;) Up to level 9 already ... -- Lester Caine - G8HFL

Re: [Talk-GB] Help with postgres

Tom Hughes wrote: On 10/07/13 09:24, Lester Caine wrote: Not helping :( I used http://wiki.openstreetmap.org/wiki/PostGIS/Installation#openSUSE_11.2 to set up, and http://wiki.openstreetmap.org/wiki/Mapnik#Authentication_failure kicked in, but 'psql gis' gets me in and I can play with the

[Talk-GB] bbox coordinates

Anybody got an 'optimal' bbox setting for the UK and Ireland including the Scottish Isles. I'm running (-14.5, 49, 3, 61) but I'm sure that the -14.5 is overkill? -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services