Mighty you! unless you specifically changed default port during configure/build time or when starting, it should listen to its default port 5432. netstat is tricky utility and sometimes it will not show ports though listened by some process, but inaccessible due to firewall... I would try to use telnet just locally (which will be the only way you will use it anyway) like: telnet localhost 5432 (to escape from connection press simultaneously "ctrl" and "]" keys - you will be told about that when/if connection is successfully established). Thanks. Valeri On Thu, February 3, 2011 3:49 pm, Francisco Diaz Trepat - gmail wrote: > Thanks valeri, I actually think I saw a post somewhere which stated that > some guy had his webserver and postgres running on a pentium 2 with 512 of > RAM total, so I think I should be able to run it well. > > In fact the server starts perfectly and very quickly, and also I have ran > the initdb and all perfectly fine. > > The only thing I don't see is it actually listening on the port > > but there is no error so it might be listening on some other port. > > f(t) > > On Thu, Feb 3, 2011 at 6:40 PM, Valeri Galtsev > <galtsev@xxxxxxxxxxxxxxxxx>wrote: > >> Wow! >> >> This is a heavy weight one. I wouldn't dare to run it on pocked >> device... >> But maybe I'm wrong. >> >> My wild guess would be: you don't have enough RAM even to start it. To >> check how much RAM it requires just to load into memory itself and its >> arguments (and reserve space for data residing in RAM) you can run unix >> command >> >> size >> >> (or its equivalent on maemo) on the binary. E.g., this is what I get for >> postgresql on one of my servers: >> >> size /usr/bin/postgres >> >> text data bss dec hex filename >> 2974897 45216 415136 3435249 346af1 /usr/bin/postgres >> >> which says that you need 3.44 MB just to start it successfully. You may >> have to multiply that by the number of postgres processes (which I'm >> sure >> is configurable) that you allowed to be started. >> >> Let us know what you find out. >> >> Good luck! >> >> Valeri >> >> On Thu, February 3, 2011 2:59 pm, 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. >> > >> > Checking netstat there are no entry for port 5432 (postgress default) >> > >> > Postgress does not show any errors starting. >> > >> > I do it by: >> > >> > /usr/local/pgsql/bin/pg_ctl start -l mylog.log >> > >> > Any Ideas on why this might be happening? >> > >> > Has anyone try to install mysql or postgres on the n900? >> > >> > f(t) >> > _______________________________________________ >> > maemo-users mailing list >> > maemo-users@xxxxxxxxx >> > https://lists.maemo.org/mailman/listinfo/maemo-users >> > >> >> >> ++++++++++++++++++++++++++++++++++++++++ >> Valeri Galtsev >> Sr System Administrator >> Department of Astronomy and Astrophysics >> Kavli Institute for Cosmological Physics >> University of Chicago >> Phone: 773-702-4247 >> ++++++++++++++++++++++++++++++++++++++++ >> > ++++++++++++++++++++++++++++++++++++++++ Valeri Galtsev Sr System Administrator Department of Astronomy and Astrophysics Kavli Institute for Cosmological Physics University of Chicago Phone: 773-702-4247 ++++++++++++++++++++++++++++++++++++++++ _______________________________________________ maemo-users mailing list maemo-users@xxxxxxxxx https://lists.maemo.org/mailman/listinfo/maemo-users
