Re: "initdb: failed" (invalid argument)?????????????
От | Daniel Secomb |
---|---|
Тема | Re: "initdb: failed" (invalid argument)????????????? |
Дата | |
Msg-id | MCBBIFBENOMGNJNDAAJBAEGDCHAA.dan@ds-d.com обсуждение исходный текст |
Ответ на | "initdb: failed" (invalid argument)????????????? ("Daniel Secomb" <dan@ds-d.com>) |
Ответы |
Re: "initdb: failed" (invalid argument)?????????????
("zuhans@iname.com" <zuhans@iname.com>)
|
Список | pgsql-cygwin |
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@ds-d.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@thegodshalls.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@thegodshalls.com] > Sent: Saturday, July 24, 2004 1:45 PM > To: Daniel Secomb > Cc: pgsql-cygwin@postgresql.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@ds-d.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 >
В списке pgsql-cygwin по дате отправления:
Следующее
От: "zuhans@iname.com"Дата:
Сообщение: Re: "initdb: failed" (invalid argument)?????????????