Re: Postgresql iPhone

On Fri, Mar 18, 2011 at 5:41 PM, raghu ram <raghuchennuru(at)gmail(dot)com> wrote:

>
>
> 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
>
>
> *Typo errors

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

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

--Raghu Ram