Thread: postgresql 8.4 on android table with debian installed (Debian Kit APK)

problem:
I have build from source posgresql (8.4) on a android table whith a minimal linux debian installed."configure" process
and"make" (compiling source) and "make install": all are OK!! 
Also initdb works fine (/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data).
but postgresql (launched with "/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data") always says :
LOG:  could not create IPv6 socket: Permission denied
LOG:  could not create IPv4 socket: Permission denied
WARNING:  could not create listen socket for "localhost"
FATAL:  could not create any TCP/IP sockets

can you help me?
(ps: No other process on socket port 5432 is running...)
Thanks very much.
Fabrizio Sacco / Parma / Italy

f-s@libero.it wrote:
> problem:
> I have build from source posgresql (8.4) on a android table whith a minimal linux debian installed."configure"
processand "make" (compiling source) and "make install": all are OK!! 
> Also initdb works fine (/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data).
> but postgresql (launched with "/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data") always says :
> LOG:  could not create IPv6 socket: Permission denied
> LOG:  could not create IPv4 socket: Permission denied
> WARNING:  could not create listen socket for "localhost"
> FATAL:  could not create any TCP/IP sockets

Maybe the Android kernel (or something) is tweaked to prohibit processes
from creating sockets.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

On 01/08/13 09:13, f-s@libero.it wrote:
> problem:
>

>
> LOG:  could not create IPv6 socket: Permission denied
> LOG:  could not create IPv4 socket: Permission denied
> WARNING:  could not create listen socket for "localhost"
> FATAL:  could not create any TCP/IP sockets
>
>
>

See  http://android-dls.com/wiki/index.php?title=Debian_on_G1 near the
bottom they discuss this issue.

Cheers

Mark