Re: Postgresql iPhone

On Fri, Mar 18, 2011 at 5:21 PM, Andrew Hoyt <hoytandrew540(at)gmail(dot)com>wrote:

> Hello, im trying to get postgresql working on iPhone. Everything builds
> fine, ./configure no flags. I have all binaries compiled, but when running
> initdb I get the familiar problem with "Bad System Call"
>
>
>
> #############################################################################################################################################################################
>
>
> wifininja:~ root# su -c "/usr/local/pgsql/bin/initdb -D
> /usr/local/pgsql/data" mobile
> The files belonging to this database system will be owned by user "mobile".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
> The default database encoding has accordingly been set to SQL_ASCII.
> The default text search configuration will be set to "english".
>
> creating directory /usr/local/pgsql/data ... ok
> creating subdirectories ... ok
> selecting default max_connections ... sh: line 1: 566 Bad system
> call "/usr/local/pgsql/bin/postgres" --boot -x0 -F -c
> max_connections=100 -c shared_buffers=1000 < "/dev/null" > "/dev/null" 2>&1
> sh: line 1: 568 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=50 -c shared_buffers=500 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 570 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=40 -c shared_buffers=400 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 572 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=30 -c shared_buffers=300 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 574 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=20 -c shared_buffers=200 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 576 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=100 < "/dev/null" >
> "/dev/null" 2>&1
> 10
> selecting default shared_buffers ... sh: line 1: 578 Bad system
> call "/usr/local/pgsql/bin/postgres" --boot -x0 -F -c
> max_connections=10 -c shared_buffers=4096 < "/dev/null" > "/dev/null" 2>&1
> sh: line 1: 580 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=3584 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 582 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=3072 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 584 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=2560 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 586 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=2048 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 588 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=1536 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 590 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=1000 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 592 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=900 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 594 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=800 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 596 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=700 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 598 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=600 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 600 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=500 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 602 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=400 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 604 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=300 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 606 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=200 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 608 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=100 < "/dev/null" >
> "/dev/null" 2>&1
> sh: line 1: 610 Bad system call "/usr/local/pgsql/bin/postgres"
> --boot -x0 -F -c max_connections=10 -c shared_buffers=50 < "/dev/null" >
> "/dev/null" 2>&1
> 400kB
> creating configuration files ... ok
> creating template1 database in /usr/local/pgsql/data/base/1 ... child
> process was terminated by signal 12: Bad system call
> initdb: removing data directory "/usr/local/pgsql/data"
>
>
> #########################################################################################################################################################################
>
> here is youtube video:
>
> http://www.youtube.com/watch?v=XN5WTGIcgYk
>
>
>
>
> Familiar errors I know, thats why I put it in the novice mailing list. But
> all documentation regarding this points to Cygwin. Would Bonjour be
> conflicting? Even when I build with bonjour support it still fails like
> this. I have tried all versions of postgres. If anyone could point me in
> the right direction, much appreciated.
>

Could you please try to set environmental variable::
env CYWIN=server

and then connect to "postgres" user and run "initdb" binary to create a new
cluster.

--Raghu Ram

env CYGWIN=server