Postgresql iPhone

From: Andrew Hoyt <hoytandrew540(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgresql iPhone
Date: 2011-03-18 11:51:54
Message-ID: AANLkTinrhpgHXkihC01kUXpcfj7XZmzAbG07igNSvUZt@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message java4dev 2011-03-18 12:09:01 how to call stored procedures with output parameters
Previous Message Eric McKeeth 2011-03-18 05:23:55 Re: foreign key