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

Re: Postgresql iPhone

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Andrew Hoyt <hoytandrew540(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgresql iPhone
Date: 2011-03-18 12:11:37
Message-ID: AANLkTinkxUF2mcW84u6ysvhU+ZN_4s-3P9GFrfjB1jBv@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: raghu ramDate: 2011-03-18 12:14:38
Subject: Re: Postgresql iPhone
Previous:From: java4devDate: 2011-03-18 12:09:01
Subject: how to call stored procedures with output parameters

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