Re: [postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

2011-03-05 Thread William Kyngesburye
My PostGIS distribution is made for my Postgres distribution. It will not install for the EnterpriseDB distribution, and even if you could extract PostGIS and install it where EnterpriseDB wants it, it probably won't work. I think they have a build of PostGIS that works with their Postgres. On

Re: [postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

2011-03-05 Thread Rosemary Alles
I believe I figured it out, the Mac OS X install wiz for postgresql defaults to /Library/PostgreSQL/ (which I accepted) and the install wiz for postgis appears to *only* look in /usr/local/ to determine if postgresql has *already* been installed, hence one of two things must happen: 1. postgres

Re: [postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

2011-03-05 Thread Rosemary Alles
Thanks William. I redid the installation (by *actually* reading the readme -duh- and things appear to be working). The installation, uses an install wiz which asks for the password, etc. (system password for the user postgres vs the db password) - the installation proceeds ok as long as shared me

Re: [postgis-users] images in postgresql

2011-03-05 Thread Paragon Corporation
Robert, Is there a reason why you have the points in a separate table or do you have points in both tables and you want to relate by a spatial join? If its a 1 to 1 relationship, we would just put them in the same table. As far as foreign keys go, you should have some identifier the same in

Re: [postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

2011-03-05 Thread William Kyngesburye
On Mar 5, 2011, at 4:38 AM, Rosemary Alles wrote: > Hullo all, > > After running around in circles for a bit, I decide I would ask. The > installation of PostgreSQL from > http://www.enterprisedb.com/products-services-training/pgdownload#osx > apparently created a user "postgres" (with no home

Re: [postgis-users] Error when importing raster table

2011-03-05 Thread Jorge Arévalo
2011/3/1 Andreas Forø Tollefsen : > Hi. As you say the sql file has been generated, and i can load it. > I was just curious why i got a warning? > Thanks for the reminder. I will update my PostGIS.. > Andreas > Hi Andreas, Honestly, I'm not sure. It may be related with the "pack" function of your

[postgis-users] images in postgresql

2011-03-05 Thread Robert Buckley
Hi, I am just experimenting at the moment with a project and could do with some advice. I have created a database which contains photos of Windturbines. I also have a postgis database with the locations (points) of the wind turbines and would like join the photos to the points via a link tab

[postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

2011-03-05 Thread Rosemary Alles
Hullo all, After running around in circles for a bit, I decide I would ask. The installation of PostgreSQL from http://www.enterprisedb.com/products-services-training/pgdownload#osxapparently created a user "postgres" (with no home directory - but that's ok) and if there's a password (maybe there