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