[Geocoding] Nominatim Install Problems

[Brian Quinion]

On Mon, Jul 5, 2010 at 11:12 PM, Gavin Jackson <gavinj at lesmills.com.au> wrote:
> Hi guys,
>
> I think I've hit the same problem on SLES 11 (running Enterprise DB
> Postgresql 8.4).
>
> This is the second time I have hit this error (I upgraded the ram from
> 4gb to 8gb to see if it would help resolve the problem).
>
> Are there any specific postgres settings I need to set, or additional debug
> information that I can provide to help figure out why this is occurring?
>
> I am using the latest osm2psql code out of subversion.

The trouble is there are various problems that can present like this.

First off I'll say that I now suggest sticking with postgresql 8.3
when using nominatim - I've now seen a number of index and performance
problems on 8.4 and a late series 8.3 seems more stable and reliable.

That said:

Are you using a stock postgresql.conf or have you tweaked the values
to make better use of the memory?  If you have tewaked them it is
possible you have told postgresql to use more memory than is actually
available.

If this isn't the case then the second most likely cause is a problem
with postgis - as I've said earlier in the thread there seem to be
various memory problems.  You might want to try upgrading to the
latest version (1.5.1 I think) which so far I've found fairly stable.

If you continue to have problems let me know exactly what versions you
are running and I'll try to suggest somewhere to go.

--
 Brian