Re: Need help for PostgreSQl installation

Rose,

Please post instead of sending private email.

On Sun, Oct 12, 2003 at 09:25:06PM -0700, xuan luo wrote:
> I want to install PostgreSQL to my computer, but I get error message
> as below:
>
> creating template1 database in /usr/share/postgresql/data/base/1...
> IpcSemapho Create: semget(key=1, num=17, 03600) failed: Function not
> implemented
>
> initdb failed.
> Removing /usr/share/postgresql/data.
>
> In the message, it let me remove /usr/share/postgresql/data. However,
> there is no data folder under /usr/share/postgresql/.
>
> In the user guide, the problem is listed there, but there is no
> solution. Could you take a few minutes to look at my installation
> procedure?
>
> Below are my installation procedure:
>
> Prepare:
>
> 1. Download setup.exe (for cygwin1.5).
>
> 2. Run setup.exe to get Cygwin (root directory).
>
> 3. Download Cygipc and copy it to root Cygwin directory.

The above sounds like you are using an old cygipc version.  cygipc is
installable via Cygwin setup.exe now.

> and
>
> Install:
>
> 1. # ipc-daemon2  --install-as-service
>
> 2. # net  user  postgres  $password  /add  /fullname:postgres  /
> comment:'PostgreSQL  user  account'  /homedir:"$(cygpath  -w
> /hom/postgres)" #
>
> 3. # mkpasswd  -l  -u  postgres  >>/etc/passwd
>
> 4. # cmd  /c  secpol.msc  #
>
> 5. # cygrunsrv  --install  postmaster  --path  /usr/bin/postmaster
> --args "-D  /usr/share/postgresql/data  -i"  --dep  ipc-daemon2
> --termsig  INT --user  postgres  --shutdown  #
>
> 6. # mkdir  /usr/share/postgresql/data
>
> 7. # chown  postgres  /usr/share/postgresql/data  #
>
> 8. # net  start  ipc-daemon2  #
>
> 9.  initdb  -D  /usr/share/postgresql/data
>
> Problem is here:
>
> creating template1 database in /usr/shar
> Create: semget(key=1, num=17, 03600) fai
>
> initdb failed.
> Removing /usr/share/postgresql/data.
>
>
>
> I can't even go down to
>
> 10. # net  start  postmaster  #
>
>  and
>
> 11. # psql  -U  postgres  template1  #
>
> I tried to delete Cygwin folder many times and re-install, but is doesn't
> work.  I really need you to point how to solve the problem.
>
> Could you please help?

I believe your problem is a version mismatch between cygipc and
postgresql.  What versions of cygipc, cygwin, and postgresql are you
using?

You should be using the following:

    $ cygcheck -cd cygipc cygwin postgresql
    Cygwin Package Information
    Package              Version
    cygipc               2.01-2
    cygwin               1.5.5-1
    postgresql           7.3.4-2

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6