Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group