Re: Postgresql iPhone - Mailing list pgsql-novice

On Fri, Mar 18, 2011 at 5:21 PM, Andrew Hoyt <hoytandrew540@gmail.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