I am now getting the error: Create DB Setup DB unable to find /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
---- I looked into setup.php and see the line pgsqlRunScriptFile(CONST_Path_Postgresql_Postgis.'/postgis.sql'); This is probably what's defining `/usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql`. However I believe I have postgis 2 installed (yum list postgis2*). /usr/share/postgresql/ does not exist. How should this link be fixed? Thank you once again! :) On Wed, Sep 12, 2012 at 6:18 PM, Sarah Hoffmann <[email protected]> wrote: > On Wed, Sep 12, 2012 at 04:51:05PM -0400, Nyx wrote: > > I tried commenting out the line `passthru('createlang plpgsql > > '.$aDSNInfo['database']);`. When I run the import command, I get the > ouput: > > > > Create DB > > Setup DB > > unable to start pgsql > > > > ---- > > > > When I tried running `psql -p 5432 -d nominatim` I am able to connect to > > the database `nominatim`. > > If that works from the command line then the only other thing I could think > of is that your php configuration does not allow psql to be executed or > cannot > find it. Also the script writes to /dev/null. Make sure that your user and > php are allowed to do that. > > > However when I check the contents of the database `nominatim`, I still do > > not see anything added to the table. > > That is normal because the setup process dies before doing anything useful. > > Sarah > > > > > > On Wed, Sep 12, 2012 at 12:17 PM, Sarah Hoffmann <[email protected]> > wrote: > > > > > On Wed, Sep 12, 2012 at 03:46:47PM +0200, Frederik Ramm wrote: > > > > Hi, > > > > > > > > On 09/12/12 15:34, Nyx wrote: > > > > >Hi, thanks for the help so far. Some how I manage to get past that > > > > >error. Now when doing the import command, I get: > > > > > > > > > >Create DB > > > > >Setup DB > > > > >createlang: language "plpgsql" is already installed in database > > > "nominatim" > > > > > > > > 9.x versions of PostgreSQL have plpgsql activated by default. I > > > > don't know if that is a problem but maybe you should comment out the > > > > line that executes the "createlang" command. > > > > > > This error can be ignored. The setup actually went past it. The > interesting > > > error was this one: > > > > > > > unable to start pgsql > > > > > > This means that psql still does not work correctly. What it tries is > this: > > > > > > psql -p 5432 -d nominatim > > > > > > Sarah > > > >
_______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
