[maemo-users] Postgress on my N900

[From: Kaj-Michael Lang]

On Thu, 2011-02-03 at 17:59 -0300, Francisco Diaz Trepat - gmail wrote:
> I have successfully built and installed postgres 9.2 on my N900

> It starts. but I cannot connect to it.

afaik, by default postgres listens to unix sockets only. You need to
tell it to listen to tcp/ip connections.

Check your postgresql.conf and the listen_addresses setting.
"If the list is empty, the server does not listen on any IP interface at
all, in which case only Unix-domain sockets can be used to connect to
it."

See:
http://www.postgresql.org/docs/9.0/static/runtime-config-connection.html

All that blaablaa about not enough memory is just crap, imho. I used to
run my web+php+postgresql+mysql+mail+shell etc on much less powerfull
hardware than the N900 back in the day just fine.
There is much memory related that can be tuned for low-memory systems in
the postgres configuration. Check the documentation.

-- 
Kaj-Michael Lang <milang at tal.org>