Re: "initdb: failed" (invalid argument)?????????????

hi daniel,

i didn't mention this especially but now i see that this could be very
important:
those 3 "scripts" are 3 different files! that means:
1. create a file "pgini" (or whatever you like it to be named), open it
with any editor and type in the commands starting from "#!/bin/sh" until
"./db-stop".
2. create a file "db-start" (or whatever...), open it...editor... from
"#!/bin/sh" until "ps -f".
3. create..."db-stop" (or...), ...editor...from "#!/bin/sh" until "ps -f".

those files are batch-files, i.e. you call the file-name and then the
commands in it will be done line by line.
to call the files (i assume, that they are all in the same dir) you have
to type in at the command prompt:
1. "./pgini" (remember that this is only important the very first time!
2. "./db-start".
then work with postgresql whatever you want.
3. "./db-stop" - at the end of your hard working-day.
important: only type in what is between ""!
important: my solution is working (and for me - for testing and
programming purposes - its very ok so) - but there are more secure and
sophisticated around - have a look at those if you plan to setup a
production-environment!

greetings
hans

Daniel Secomb schrieb:

>Hey Mike (or anybody else that can help me)!
>
>The script below has worked for me up to a point. The part in the script
>where it went off the rails is mentioned below:
>
>
>Basic Cygserver configuration finished. Have fun!
>
>$echo "cygserver starting..."
>cygserver starting...
>$ cygserver &
>[1] 966609
>$ cygserver: Initialization complete. Wating for requests.
>ps -f
> UID PID PPID TTY STIME COMMAND
>Daniel S 942069 1 con 12:52:04 /usr/bin/BASH
>Daniel S 966609 942069 con 13:01:01 /USR/SBIN/CYGSERVER
>Daniel S 937673 942069 con 13:01:35 /usr/bin/PS
>$ ./db-stop
>BASH: ./db-stop: No such file or directory
>$ #./db-stop
>$ now "db-start":
>BASH: now: command not found
>$
>
>
>What do you think???? Any idea why it didn't work??
>
>Another thing too. There were a few lines in the script (see further below
>to see the email that has the original script) that Cygwin didn't recognise.
>For example:
>
>When I typed in:
>my "pgini":
>
>Cygwin said:
>BASH: my: command not found
>
>And when I typed in:
>#!/bin/sh
>
>Cygwin said:
>BASH: !/bin/sh: event not found
>
>This may sound like a stupid question, but was I supposed to type in:
># the first very important set-variable
>
>I am not very clear on what is supposed to be typed in and what is just
>lines of helpful info.
>
>I also thought I spotted some typos in your script, so I changed them to how
>I thought it should be. For example:
>
>You wrote:
>#echo "IPC-Daemon starten..."
>
>I changed it to:
>#echo "cygserver starting..."
>
>{I changed the "IPC-Daemon" to "cyserver" because my version of Cygwin
>(1.5.10-3) no longer uses "IPC-Daemon" and uses "cygserver" instead.}
>
>You wrote:
>echo "sygserver starten..."
>
>I changed it to:
>echo "cygserver starting..."
>
>Was I OK in doing this or was it suppose to be EXACTLY as you have written
>it?
>
>
>I extremely appreciate your help and support!!!
>
>
>Kind Regards,
>
>Daniel Secomb
>Creative Director
>DS Design
>ABN 33 721 455 978
>PO Box 4540,
>Lake Haven NSW 2263
>Australia
>[p] +61 2 4393 6305
>[f] +61 2 4393 6306
>[m] +61414 571 500
>mailto:dan(at)ds-d(dot)com
>http://www.ds-d.com/
>
>Take a look at our latest web development project:
>http://www.specialfx.com.au/
>
>>From the US, UK or Europe? Why not take advantage of the weaker Australian
>dollar? Click the following link http://www.xe.com/ucc/ for a currency
>conversion and find out how much you'll save!!
>
>_________________________________________________________________
>
>The material contained in this email may be confidential, and may also be
>the subject of copyright and/or privileged information. If you are not the
>intended recipient, any use, disclosure or copying of this document is
>prohibited. If you have received this document in error, please advise the
>sender and delete the document.
>
>This email communication does not create or vary any contractual
>relationship between DS Design and you. Internet communications are not
>secure and accordingly DS Design does not accept any legal liability for the
>contents of this message.
>
>Please note that neither DS Design nor the sender accepts any responsibility
>for viruses and it is your responsibility to scan the email and any
>attachments.
>
>
>
>
>-----Original Message-----
>From: mike g [mailto:mike(at)thegodshalls(dot)com]
>Sent: Monday, July 26, 2004 12:26 PM
>To: Daniel Secomb
>Subject: RE: [CYGWIN] "initdb: failed" (invalid argument)?????????????
>
>
>Ok,
>
>I believe 98 works the same way as the XP Home edition.
>
>for everybody who is interested in my functioning scripts (on
>win-xp-home) i give it in here:
>
>at first i do an initiation of my postgresql-db "pgini" and at the end i
>call my script "db-stop" to clean memory of processes (especially
>cygserver).
>
>and after that i call my db with "db-start" every time i need it (i
>don't use it as a service, i don't use it for production just for
>programming), and at the end of my working with my db i call my
>"db-stop" again to clean memory. afterwards i exit cygwin or restart my
>db with "db-start".
>
>now my scripts:
>
>my "pgini":
>
>#!/bin/sh
># the first very important set-variable
>CYGWIN=server
>export CYGWIN
># the second very important set-variable - to unset it worked for me
>(then language-setting is C).
>unset LANG
>echo
># the third very important set-variable
>PATH=/usr/bin:/usr/sbin:$PATH
>export PATH
>#echo "IPC-Daemon starten..."
>echo
>echo "cygserver-config starting..."
>cygserver-config
>echo "sygserver starten..."
>cygserver &
>ps -f
>echo
>echo "initdb starting..."
>initdb -D /var/postgresql/data
>ps -f
>./db-stop
>
>now "db-start":
>
>#!/bin/sh
>CYGWIN=server
>export CYGWIN
>PATH=/usr/bin:/usr/sbin:$PATH
>export PATH
>echo
>echo "sygserver starting..."
>cygserver &
>ps -f
>echo
>echo "PostgreSQL starting..."
>postmaster -i -D /var/postgresql/data &
>ps -f
>
>and finally "db-stop":
>
>#!/bin/sh
>echo
>echo "PostgreSQL finishing..."
>pg_ctl stop -w -D /var/postgresql/data -s -m smart
>ps -f
>echo
>echo "cygserver finishing..."
>kill $(ps -f | grep cygserver | awk '{print $2}')
>ps -f
>
>greetings and thanks to all
>hans
>On Sat, 2004-07-24 at 02:16, Daniel Secomb wrote:
>
>
>>I'm using Windows 98SE, PostgreSQL 7.4.3.1 and Cygwin 1.5.10-3
>>
>>Thank you for your intended help Mike.
>>
>>God bless you!!
>>
>>Dan
>>
>>-----Original Message-----
>>From: mike g [mailto:mike(at)thegodshalls(dot)com]
>>Sent: Saturday, July 24, 2004 1:45 PM
>>To: Daniel Secomb
>>Cc: pgsql-cygwin(at)postgresql(dot)org
>>Subject: Re: [CYGWIN] "initdb: failed" (invalid argument)?????????????
>>
>>
>>What version of Postgresql are you using?
>>
>>What version of Windows?
>>
>>Mike
>>On Fri, 2004-07-23 at 20:18, Daniel Secomb wrote:
>>
>>
>>>Hi,
>>>
>>>For some weird reason, the initialization attempt has spat the dummy and
>>>this is what it did:
>>>
>>>
>>>
>>>$ export CYGWIN=server
>>>$ /usr/sbin/cygserver &
>>>[1] 686417
>>>$ cygserver: Initialization complete. Waiting for requests.
>>>initdb -D /usr/local/pgsql/data -W -E LATIN1
>>>The files belonging to this database system will be owned by user
>>>
>>>
>"Daniel
>
>
>>>Secomb
>>>".
>>>This user must also own the server process.
>>>
>>>The database cluster will be initialized with locale C.
>>>
>>>creating directory /usr/local/pgsql/data... ok
>>>creating directory /usr/local/pgsql/data/base... ok
>>>creating directory /usr/local/pgsql/data/global... ok
>>>creating directory /usr/local/pgsql/data/pg_xlog... ok
>>>creating directory /usr/local/pgsql/data/pg_clog... ok
>>>selecting default max_connections... 10
>>>selecting default shared_buffers... 50
>>>creating configuration files... ok
>>>creating template1 database in /usr/local/pgsql/data/base/1... FATAL:
>>>shmat<id=
>>>1179648> failed: Invalid argument
>>>
>>>initdb: failed
>>>$
>>>
>>>
>>>
>>>Any reason why it has done this?
>>>
>>>Any help will be GREATLY appreciated!!
>>>
>>>Many, many thanks!!
>>>
>>>
>>>Kind Regards,
>>>
>>>Daniel Secomb
>>>Creative Director
>>>DS Design
>>>ABN 33 721 455 978
>>>PO Box 4540,
>>>Lake Haven NSW 2263
>>>Australia
>>>[p] +61 2 4393 6305
>>>[f] +61 2 4393 6306
>>>[m] +61414 571 500
>>>mailto:dan(at)ds-d(dot)com
>>>http://www.ds-d.com/
>>>
>>>Take a look at our latest web development project:
>>>http://www.specialfx.com.au/
>>>
>>>>From the US, UK or Europe? Why not take advantage of the weaker
>>>
>>>
>>Australian
>>
>>
>>>dollar? Click the following link http://www.xe.com/ucc/ for a currency
>>>conversion and find out how much you'll save!!
>>>
>>>_________________________________________________________________
>>>
>>>The material contained in this email may be confidential, and may also
>>>
>>>
>be
>
>
>>>the subject of copyright and/or privileged information. If you are not
>>>
>>>
>the
>
>
>>>intended recipient, any use, disclosure or copying of this document is
>>>prohibited. If you have received this document in error, please advise
>>>
>>>
>the
>
>
>>>sender and delete the document.
>>>
>>>This email communication does not create or vary any contractual
>>>relationship between DS Design and you. Internet communications are not
>>>secure and accordingly DS Design does not accept any legal liability for
>>>
>>>
>>the
>>
>>
>>>contents of this message.
>>>
>>>Please note that neither DS Design nor the sender accepts any
>>>
>>>
>>responsibility
>>
>>
>>>for viruses and it is your responsibility to scan the email and any
>>>attachments.
>>>
>>>
>>>
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 7: don't forget to increase your free space map settings
>>>
>>>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>