Thread: Re: Windows install

Re: Windows install

From
Antonio Da Silva
Date:
If you want an install version of PostGres
look @
http://208.160.255.143/

or http://208.160.255.143/pgsql/pgsql.exe

Tonio

Steve Jorgensen wrote:
>
> I'm working with a group of people who need to use PostgreSQL on
> Windows, but are not yet knowledgeable hackers.  I am also in this
> category.
>
> I need to be able to install a reasonably recent version of PostgreSQL
> on Windows NT or Windows 2K, and I need to be able to create a list of
> step-by-step instructions for the other group members on how to do the
> same.
>
> All the instructions I have found so far take you just so far, then
> say now just proceed as normal.  What's normal?  Also, I should assume
> most people will be using the Cygwin tools, not VC++, though I'd like
> to be able to send out binaries and not have everyone have to worry
> about compiling at all.
>
> I found a binary package of 7.0 for Windows NT, but the Docs for
> Windows seem to be only how to compile and install one library dll.
> Since i have a binary package, I hope I don't need to compile, but in
> any case, I still don't know how to install.
>
> Thanks in advance for any help.

--
tonio@novadeck.com - http://nioto.com/

Re: Windows install

From
nospam@nospam.nospam (Steve Jorgensen)
Date:
Thanks for the pointer.  Does this isntall require Cygwin and Cygipc
to be installed first, or does it handle all that?

On Wed, 04 Apr 2001 16:41:00 +0200, Antonio Da Silva
<tonio@novadeck.com> wrote:

>If you want an install version of PostGres
>look @
>http://208.160.255.143/
>
>or http://208.160.255.143/pgsql/pgsql.exe
>
>Tonio
>
>Steve Jorgensen wrote:
>>
>> I'm working with a group of people who need to use PostgreSQL on
>> Windows, but are not yet knowledgeable hackers.  I am also in this
>> category.
>>
>> I need to be able to install a reasonably recent version of PostgreSQL
>> on Windows NT or Windows 2K, and I need to be able to create a list of
>> step-by-step instructions for the other group members on how to do the
>> same.
>>
>> All the instructions I have found so far take you just so far, then
>> say now just proceed as normal.  What's normal?  Also, I should assume
>> most people will be using the Cygwin tools, not VC++, though I'd like
>> to be able to send out binaries and not have everyone have to worry
>> about compiling at all.
>>
>> I found a binary package of 7.0 for Windows NT, but the Docs for
>> Windows seem to be only how to compile and install one library dll.
>> Since i have a binary package, I hope I don't need to compile, but in
>> any case, I still don't know how to install.
>>
>> Thanks in advance for any help.
>
>--
>tonio@novadeck.com - http://nioto.com/


RE: Re: Windows install

From
"charlie derr"
Date:
It seems that the cygwin stuff comes with this install (I already had cygwin
configured on my machine, but this install created another one, with all the
details taken care of).

The install went fine.  Then i entered the cygwin shell (that had been
installed with postgreSQL) and did "su postgres"   and then "mkdir
/usr/bin/data" and then "initdb --pgdata /usr/bin/data"  which seemed to
work fine.  Starting the postmaster didn't however:

bash-2.04$ su postgres
$ /usr/bin/pg_ctl -D /usr/bin/data start
postmaster successfully started up.
$ IpcMemoryCreate: shmget failed (Permission denied) key=5432010, size=144,
permission=700
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
IpcMemoryIdGet: shmget failed (Permission denied) key=5432010, size=144,
permission=0
IpcMemoryAttach: shmat failed (Permission denied) id=-2
FATAL 1:  AttachSLockMemory: could not attach segment



I'm on WinNT 4.0 with service pack 6.  Any ideas?


    thanx much for your time,
        ~c



+-----Original Message-----
+From: pgsql-general-owner@postgresql.org
+[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Jorgensen
+Sent: Wednesday, April 04, 2001 6:55 PM
+To: pgsql-general@postgresql.org
+Subject: [GENERAL] Re: Windows install
+
+
+Thanks for the pointer.  Does this isntall require Cygwin and Cygipc
+to be installed first, or does it handle all that?
+
+On Wed, 04 Apr 2001 16:41:00 +0200, Antonio Da Silva
+<tonio@novadeck.com> wrote:
+
+>If you want an install version of PostGres
+>look @
+>http://208.160.255.143/
+>
+>or http://208.160.255.143/pgsql/pgsql.exe
+>
+>Tonio
+>
+>Steve Jorgensen wrote:
+>>
+>> I'm working with a group of people who need to use PostgreSQL on
+>> Windows, but are not yet knowledgeable hackers.  I am also in this
+>> category.
+>>
+>> I need to be able to install a reasonably recent version of PostgreSQL
+>> on Windows NT or Windows 2K, and I need to be able to create a list of
+>> step-by-step instructions for the other group members on how to do the
+>> same.
+>>
+>> All the instructions I have found so far take you just so far, then
+>> say now just proceed as normal.  What's normal?  Also, I should assume
+>> most people will be using the Cygwin tools, not VC++, though I'd like
+>> to be able to send out binaries and not have everyone have to worry
+>> about compiling at all.
+>>
+>> I found a binary package of 7.0 for Windows NT, but the Docs for
+>> Windows seem to be only how to compile and install one library dll.
+>> Since i have a binary package, I hope I don't need to compile, but in
+>> any case, I still don't know how to install.
+>>
+>> Thanks in advance for any help.
+>
+>--
+>tonio@novadeck.com - http://nioto.com/
+
+
+---------------------------(end of broadcast)---------------------------
+TIP 4: Don't 'kill -9' the postmaster
+


Re: Windows install

From
nospam@nospam.nospam (Steve Jorgensen)
Date:
Well, I have questions about your post, and a possible suggestion on
your problem.

1.  I tried what you just described, but I folloed the instructions in
the INSTALL document and ran ./configure.  This failed with an error,
and I had exactly the same problem on both W2K and W98.

$ ./configure
creating cache ./config.cache
checking host system type... i686-pc-cygwin
checking which template to use... win
checking whether to build with locale support... no
checking whether to build with recode support... no
checking whether to build with multibyte character support... no
checking whether to build with Unicode conversion support... no
checking for default port number... 5432
checking for default soft limit on number of connections... 32
checking for gcc... gcc
checking whether the C compiler (gcc  ) works... yes
checking whether the C compiler (gcc  ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
using CFLAGS=-O2
checking whether the C compiler (gcc -O2 ) works... no
configure: error: installation or configuration problem: C compiler
cannot create executables.

2.  Supposedly, PostgreSQL requires Cygipc to be running.  Cygipc does
not seem to be included with Cywin even though PostgreSQL is included
and requires Cygipc.  I found Cygipc at
http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/index.html

On Mon, 9 Apr 2001 17:35:04 +0000 (UTC),
webmindforever@organicmeat.net ("charlie derr") wrote:

>It seems that the cygwin stuff comes with this install (I already had cygwin
>configured on my machine, but this install created another one, with all the
>details taken care of).
>
>The install went fine.  Then i entered the cygwin shell (that had been
>installed with postgreSQL) and did "su postgres"   and then "mkdir
>/usr/bin/data" and then "initdb --pgdata /usr/bin/data"  which seemed to
>work fine.  Starting the postmaster didn't however:
>
>bash-2.04$ su postgres
>$ /usr/bin/pg_ctl -D /usr/bin/data start
>postmaster successfully started up.
>$ IpcMemoryCreate: shmget failed (Permission denied) key=5432010, size=144,
>permission=700
>This type of error is usually caused by an improper
>shared memory or System V IPC semaphore configuration.
>For more information, see the FAQ and platform-specific
>FAQ's in the source directory pgsql/doc or on our
>web site at http://www.postgresql.org.
>IpcMemoryIdGet: shmget failed (Permission denied) key=5432010, size=144,
>permission=0
>IpcMemoryAttach: shmat failed (Permission denied) id=-2
>FATAL 1:  AttachSLockMemory: could not attach segment
>
>
>
>I'm on WinNT 4.0 with service pack 6.  Any ideas?
>
>
>    thanx much for your time,
>        ~c
>
>
>
>+-----Original Message-----
>+From: pgsql-general-owner@postgresql.org
>+[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Jorgensen
>+Sent: Wednesday, April 04, 2001 6:55 PM
>+To: pgsql-general@postgresql.org
>+Subject: [GENERAL] Re: Windows install
>+
>+
>+Thanks for the pointer.  Does this isntall require Cygwin and Cygipc
>+to be installed first, or does it handle all that?
>+
>+On Wed, 04 Apr 2001 16:41:00 +0200, Antonio Da Silva
>+<tonio@novadeck.com> wrote:
>+
>+>If you want an install version of PostGres
>+>look @
>+>http://208.160.255.143/
>+>
>+>or http://208.160.255.143/pgsql/pgsql.exe
>+>
>+>Tonio
>+>
>+>Steve Jorgensen wrote:
>+>>
>+>> I'm working with a group of people who need to use PostgreSQL on
>+>> Windows, but are not yet knowledgeable hackers.  I am also in this
>+>> category.
>+>>
>+>> I need to be able to install a reasonably recent version of PostgreSQL
>+>> on Windows NT or Windows 2K, and I need to be able to create a list of
>+>> step-by-step instructions for the other group members on how to do the
>+>> same.
>+>>
>+>> All the instructions I have found so far take you just so far, then
>+>> say now just proceed as normal.  What's normal?  Also, I should assume
>+>> most people will be using the Cygwin tools, not VC++, though I'd like
>+>> to be able to send out binaries and not have everyone have to worry
>+>> about compiling at all.
>+>>
>+>> I found a binary package of 7.0 for Windows NT, but the Docs for
>+>> Windows seem to be only how to compile and install one library dll.
>+>> Since i have a binary package, I hope I don't need to compile, but in
>+>> any case, I still don't know how to install.
>+>>
>+>> Thanks in advance for any help.
>+>
>+>--
>+>tonio@novadeck.com - http://nioto.com/
>+
>+
>+---------------------------(end of broadcast)---------------------------
>+TIP 4: Don't 'kill -9' the postmaster
>+
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly


RE: Re: Windows install

From
"charlie derr"
Date:

+
+
+Well, I have questions about your post, and a possible suggestion on
+your problem.
+
+1.  I tried what you just described, but I folloed the instructions in
+the INSTALL document and ran ./configure.  This failed with an error,
+and I had exactly the same problem on both W2K and W98.


I'm confused.  I don't find an INSTALL document anywhere.  Nor do I find a
configure file.


+
+$ ./configure
+creating cache ./config.cache
+checking host system type... i686-pc-cygwin
+checking which template to use... win
+checking whether to build with locale support... no
+checking whether to build with recode support... no
+checking whether to build with multibyte character support... no
+checking whether to build with Unicode conversion support... no
+checking for default port number... 5432
+checking for default soft limit on number of connections... 32
+checking for gcc... gcc
+checking whether the C compiler (gcc  ) works... yes
+checking whether the C compiler (gcc  ) is a cross-compiler... no
+checking whether we are using GNU C... yes
+checking whether gcc accepts -g... yes
+using CFLAGS=-O2
+checking whether the C compiler (gcc -O2 ) works... no
+configure: error: installation or configuration problem: C compiler
+cannot create executables.
+
+2.  Supposedly, PostgreSQL requires Cygipc to be running.  Cygipc does
+not seem to be included with Cywin even though PostgreSQL is included
+and requires Cygipc.  I found Cygipc at
+http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/index.html



I'm trying this one out now.  Thank you for the info.

    ~c


+
+On Mon, 9 Apr 2001 17:35:04 +0000 (UTC),
+webmindforever@organicmeat.net ("charlie derr") wrote:
+
+>It seems that the cygwin stuff comes with this install (I already
+had cygwin
+>configured on my machine, but this install created another one,
+with all the
+>details taken care of).
+>
+>The install went fine.  Then i entered the cygwin shell (that had been
+>installed with postgreSQL) and did "su postgres"   and then "mkdir
+>/usr/bin/data" and then "initdb --pgdata /usr/bin/data"  which seemed to
+>work fine.  Starting the postmaster didn't however:
+>
+>bash-2.04$ su postgres
+>$ /usr/bin/pg_ctl -D /usr/bin/data start
+>postmaster successfully started up.
+>$ IpcMemoryCreate: shmget failed (Permission denied) key=5432010,
+size=144,
+>permission=700
+>This type of error is usually caused by an improper
+>shared memory or System V IPC semaphore configuration.
+>For more information, see the FAQ and platform-specific
+>FAQ's in the source directory pgsql/doc or on our
+>web site at http://www.postgresql.org.
+>IpcMemoryIdGet: shmget failed (Permission denied) key=5432010, size=144,
+>permission=0
+>IpcMemoryAttach: shmat failed (Permission denied) id=-2
+>FATAL 1:  AttachSLockMemory: could not attach segment
+>
+>
+>
+>I'm on WinNT 4.0 with service pack 6.  Any ideas?
+>
+>
+>    thanx much for your time,
+>        ~c
+>
+>
+>
+>+-----Original Message-----
+>+From: pgsql-general-owner@postgresql.org
+>+[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Jorgensen
+>+Sent: Wednesday, April 04, 2001 6:55 PM
+>+To: pgsql-general@postgresql.org
+>+Subject: [GENERAL] Re: Windows install
+>+
+>+
+>+Thanks for the pointer.  Does this isntall require Cygwin and Cygipc
+>+to be installed first, or does it handle all that?
+>+
+>+On Wed, 04 Apr 2001 16:41:00 +0200, Antonio Da Silva
+>+<tonio@novadeck.com> wrote:
+>+
+>+>If you want an install version of PostGres
+>+>look @
+>+>http://208.160.255.143/
+>+>
+>+>or http://208.160.255.143/pgsql/pgsql.exe
+>+>
+>+>Tonio
+>+>
+>+>Steve Jorgensen wrote:
+>+>>
+>+>> I'm working with a group of people who need to use PostgreSQL on
+>+>> Windows, but are not yet knowledgeable hackers.  I am also in this
+>+>> category.
+>+>>
+>+>> I need to be able to install a reasonably recent version of PostgreSQL
+>+>> on Windows NT or Windows 2K, and I need to be able to create a list of
+>+>> step-by-step instructions for the other group members on how to do the
+>+>> same.
+>+>>
+>+>> All the instructions I have found so far take you just so far, then
+>+>> say now just proceed as normal.  What's normal?  Also, I should assume
+>+>> most people will be using the Cygwin tools, not VC++, though I'd like
+>+>> to be able to send out binaries and not have everyone have to worry
+>+>> about compiling at all.
+>+>>
+>+>> I found a binary package of 7.0 for Windows NT, but the Docs for
+>+>> Windows seem to be only how to compile and install one library dll.
+>+>> Since i have a binary package, I hope I don't need to compile, but in
+>+>> any case, I still don't know how to install.
+>+>>
+>+>> Thanks in advance for any help.
+>+>
+>+>--
+>+>tonio@novadeck.com - http://nioto.com/
+>+
+>+
+>+---------------------------(end of broadcast)---------------------------
+>+TIP 4: Don't 'kill -9' the postmaster
+>+
+>
+>
+>---------------------------(end of broadcast)---------------------------
+>TIP 3: if posting/reading through Usenet, please send an appropriate
+>subscribe-nomail command to majordomo@postgresql.org so that your
+>message can get through to the mailing list cleanly
+
+
+---------------------------(end of broadcast)---------------------------
+TIP 5: Have you checked our extensive FAQ?
+
+http://www.postgresql.org/users-lounge/docs/faq.html
+


Re: Windows install

From
nospam@nospam.nospam (Steve Jorgensen)
Date:
After I install Cygwin, I look in the cygwin root, and there's a
folder called postgresql-7.1RC2.  This folder appears to contain the
files for installing Cygwin including the INSTALL document I referred
to.  What did you find in your Cygwin install?

On Tue, 10 Apr 2001 00:43:57 +0000 (UTC), wrong@crosswinds.net
("charlie derr") wrote:

>
>
>+
>+
>+Well, I have questions about your post, and a possible suggestion on
>+your problem.
>+
>+1.  I tried what you just described, but I folloed the instructions in
>+the INSTALL document and ran ./configure.  This failed with an error,
>+and I had exactly the same problem on both W2K and W98.
>
>
>I'm confused.  I don't find an INSTALL document anywhere.  Nor do I find a
>configure file.
>
>
>+
>+$ ./configure
>+creating cache ./config.cache
>+checking host system type... i686-pc-cygwin
>+checking which template to use... win
>+checking whether to build with locale support... no
>+checking whether to build with recode support... no
>+checking whether to build with multibyte character support... no
>+checking whether to build with Unicode conversion support... no
>+checking for default port number... 5432
>+checking for default soft limit on number of connections... 32
>+checking for gcc... gcc
>+checking whether the C compiler (gcc  ) works... yes
>+checking whether the C compiler (gcc  ) is a cross-compiler... no
>+checking whether we are using GNU C... yes
>+checking whether gcc accepts -g... yes
>+using CFLAGS=-O2
>+checking whether the C compiler (gcc -O2 ) works... no
>+configure: error: installation or configuration problem: C compiler
>+cannot create executables.
>+
>+2.  Supposedly, PostgreSQL requires Cygipc to be running.  Cygipc does
>+not seem to be included with Cywin even though PostgreSQL is included
>+and requires Cygipc.  I found Cygipc at
>+http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/index.html
>
>
>
>I'm trying this one out now.  Thank you for the info.
>
>    ~c
>
>
>+
>+On Mon, 9 Apr 2001 17:35:04 +0000 (UTC),
>+webmindforever@organicmeat.net ("charlie derr") wrote:
>+
>+>It seems that the cygwin stuff comes with this install (I already
>+had cygwin
>+>configured on my machine, but this install created another one,
>+with all the
>+>details taken care of).
>+>
>+>The install went fine.  Then i entered the cygwin shell (that had been
>+>installed with postgreSQL) and did "su postgres"   and then "mkdir
>+>/usr/bin/data" and then "initdb --pgdata /usr/bin/data"  which seemed to
>+>work fine.  Starting the postmaster didn't however:
>+>
>+>bash-2.04$ su postgres
>+>$ /usr/bin/pg_ctl -D /usr/bin/data start
>+>postmaster successfully started up.
>+>$ IpcMemoryCreate: shmget failed (Permission denied) key=5432010,
>+size=144,
>+>permission=700
>+>This type of error is usually caused by an improper
>+>shared memory or System V IPC semaphore configuration.
>+>For more information, see the FAQ and platform-specific
>+>FAQ's in the source directory pgsql/doc or on our
>+>web site at http://www.postgresql.org.
>+>IpcMemoryIdGet: shmget failed (Permission denied) key=5432010, size=144,
>+>permission=0
>+>IpcMemoryAttach: shmat failed (Permission denied) id=-2
>+>FATAL 1:  AttachSLockMemory: could not attach segment
>+>
>+>
>+>
>+>I'm on WinNT 4.0 with service pack 6.  Any ideas?
>+>
>+>
>+>    thanx much for your time,
>+>        ~c
>+>
>+>
>+>
>+>+-----Original Message-----
>+>+From: pgsql-general-owner@postgresql.org
>+>+[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Jorgensen
>+>+Sent: Wednesday, April 04, 2001 6:55 PM
>+>+To: pgsql-general@postgresql.org
>+>+Subject: [GENERAL] Re: Windows install
>+>+
>+>+
>+>+Thanks for the pointer.  Does this isntall require Cygwin and Cygipc
>+>+to be installed first, or does it handle all that?
>+>+
>+>+On Wed, 04 Apr 2001 16:41:00 +0200, Antonio Da Silva
>+>+<tonio@novadeck.com> wrote:
>+>+
>+>+>If you want an install version of PostGres
>+>+>look @
>+>+>http://208.160.255.143/
>+>+>
>+>+>or http://208.160.255.143/pgsql/pgsql.exe
>+>+>
>+>+>Tonio
>+>+>
>+>+>Steve Jorgensen wrote:
>+>+>>
>+>+>> I'm working with a group of people who need to use PostgreSQL on
>+>+>> Windows, but are not yet knowledgeable hackers.  I am also in this
>+>+>> category.
>+>+>>
>+>+>> I need to be able to install a reasonably recent version of PostgreSQL
>+>+>> on Windows NT or Windows 2K, and I need to be able to create a list of
>+>+>> step-by-step instructions for the other group members on how to do the
>+>+>> same.
>+>+>>
>+>+>> All the instructions I have found so far take you just so far, then
>+>+>> say now just proceed as normal.  What's normal?  Also, I should assume
>+>+>> most people will be using the Cygwin tools, not VC++, though I'd like
>+>+>> to be able to send out binaries and not have everyone have to worry
>+>+>> about compiling at all.
>+>+>>
>+>+>> I found a binary package of 7.0 for Windows NT, but the Docs for
>+>+>> Windows seem to be only how to compile and install one library dll.
>+>+>> Since i have a binary package, I hope I don't need to compile, but in
>+>+>> any case, I still don't know how to install.
>+>+>>
>+>+>> Thanks in advance for any help.
>+>+>
>+>+>--
>+>+>tonio@novadeck.com - http://nioto.com/
>+>+
>+>+
>+>+---------------------------(end of broadcast)---------------------------
>+>+TIP 4: Don't 'kill -9' the postmaster
>+>+
>+>
>+>
>+>---------------------------(end of broadcast)---------------------------
>+>TIP 3: if posting/reading through Usenet, please send an appropriate
>+>subscribe-nomail command to majordomo@postgresql.org so that your
>+>message can get through to the mailing list cleanly
>+
>+
>+---------------------------(end of broadcast)---------------------------
>+TIP 5: Have you checked our extensive FAQ?
>+
>+http://www.postgresql.org/users-lounge/docs/faq.html
>+
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://www.postgresql.org/search.mpl


RE: Re: Windows install

From
"charlie derr"
Date:
+
+After I install Cygwin, I look in the cygwin root, and there's a
+folder called postgresql-7.1RC2.  This folder appears to contain the
+files for installing Cygwin including the INSTALL document I referred
+to.  What did you find in your Cygwin install?

I had cygwin installed previously (from many months, if not years ago).
When I ran the pgsql.exe file mentioned at the bottom of all the quoted
stuff in this post, it unzipped 10 files.  One of those was a setup.exe, so
i ran that.  This seemed to install everything that is necessary (including
cygwin, and now that i look closer, an ipc-daemon.exe file as well).   I
believe we must be talking about two completely different installs, as the
file I'm working with seemed to install 7.0.3, not 7.1RC2.  It sure looks
from the quoted stuff that you got your file from
http://208.160.255.143/pgsql/pgsql.exe.  That's where I got what I'm working
with.

    ~c

+
+On Tue, 10 Apr 2001 00:43:57 +0000 (UTC), wrong@crosswinds.net
+("charlie derr") wrote:
+
+>
+>
+>+
+>+
+>+Well, I have questions about your post, and a possible suggestion on
+>+your problem.
+>+
+>+1.  I tried what you just described, but I folloed the instructions in
+>+the INSTALL document and ran ./configure.  This failed with an error,
+>+and I had exactly the same problem on both W2K and W98.
+>
+>
+>I'm confused.  I don't find an INSTALL document anywhere.  Nor do I find a
+>configure file.
+>
+>
+>+
+>+$ ./configure
+>+creating cache ./config.cache
+>+checking host system type... i686-pc-cygwin
+>+checking which template to use... win
+>+checking whether to build with locale support... no
+>+checking whether to build with recode support... no
+>+checking whether to build with multibyte character support... no
+>+checking whether to build with Unicode conversion support... no
+>+checking for default port number... 5432
+>+checking for default soft limit on number of connections... 32
+>+checking for gcc... gcc
+>+checking whether the C compiler (gcc  ) works... yes
+>+checking whether the C compiler (gcc  ) is a cross-compiler... no
+>+checking whether we are using GNU C... yes
+>+checking whether gcc accepts -g... yes
+>+using CFLAGS=-O2
+>+checking whether the C compiler (gcc -O2 ) works... no
+>+configure: error: installation or configuration problem: C compiler
+>+cannot create executables.
+>+
+>+2.  Supposedly, PostgreSQL requires Cygipc to be running.  Cygipc does
+>+not seem to be included with Cywin even though PostgreSQL is included
+>+and requires Cygipc.  I found Cygipc at
+>+http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/index.html
+>
+>
+>
+>I'm trying this one out now.  Thank you for the info.
+>
+>    ~c
+>
+>
+>+
+>+On Mon, 9 Apr 2001 17:35:04 +0000 (UTC),
+>+webmindforever@organicmeat.net ("charlie derr") wrote:
+>+
+>+>It seems that the cygwin stuff comes with this install (I already
+>+had cygwin
+>+>configured on my machine, but this install created another one,
+>+with all the
+>+>details taken care of).
+>+>
+>+>The install went fine.  Then i entered the cygwin shell (that had been
+>+>installed with postgreSQL) and did "su postgres"   and then "mkdir
+>+>/usr/bin/data" and then "initdb --pgdata /usr/bin/data"  which seemed to
+>+>work fine.  Starting the postmaster didn't however:
+>+>
+>+>bash-2.04$ su postgres
+>+>$ /usr/bin/pg_ctl -D /usr/bin/data start
+>+>postmaster successfully started up.
+>+>$ IpcMemoryCreate: shmget failed (Permission denied) key=5432010,
+>+size=144,
+>+>permission=700
+>+>This type of error is usually caused by an improper
+>+>shared memory or System V IPC semaphore configuration.
+>+>For more information, see the FAQ and platform-specific
+>+>FAQ's in the source directory pgsql/doc or on our
+>+>web site at http://www.postgresql.org.
+>+>IpcMemoryIdGet: shmget failed (Permission denied) key=5432010, size=144,
+>+>permission=0
+>+>IpcMemoryAttach: shmat failed (Permission denied) id=-2
+>+>FATAL 1:  AttachSLockMemory: could not attach segment
+>+>
+>+>
+>+>
+>+>I'm on WinNT 4.0 with service pack 6.  Any ideas?
+>+>
+>+>
+>+>    thanx much for your time,
+>+>        ~c
+>+>
+>+>
+>+>
+>+>+-----Original Message-----
+>+>+From: pgsql-general-owner@postgresql.org
+>+>+[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Jorgensen
+>+>+Sent: Wednesday, April 04, 2001 6:55 PM
+>+>+To: pgsql-general@postgresql.org
+>+>+Subject: [GENERAL] Re: Windows install
+>+>+
+>+>+
+>+>+Thanks for the pointer.  Does this isntall require Cygwin and Cygipc
+>+>+to be installed first, or does it handle all that?
+>+>+
+>+>+On Wed, 04 Apr 2001 16:41:00 +0200, Antonio Da Silva
+>+>+<tonio@novadeck.com> wrote:
+>+>+
+>+>+>If you want an install version of PostGres
+>+>+>look @
+>+>+>http://208.160.255.143/
+>+>+>
+>+>+>or http://208.160.255.143/pgsql/pgsql.exe
+>+>+>
+>+>+>Tonio
+>+>+>
+>+>+>Steve Jorgensen wrote:
+>+>+>>
+>+>+>> I'm working with a group of people who need to use PostgreSQL on
+>+>+>> Windows, but are not yet knowledgeable hackers.  I am also in this
+>+>+>> category.
+>+>+>>
+>+>+>> I need to be able to install a reasonably recent version of
+PostgreSQL
+>+>+>> on Windows NT or Windows 2K, and I need to be able to
+create a list of
+>+>+>> step-by-step instructions for the other group members on
+how to do the
+>+>+>> same.
+>+>+>>
+>+>+>> All the instructions I have found so far take you just so far, then
+>+>+>> say now just proceed as normal.  What's normal?  Also, I
+should assume
+>+>+>> most people will be using the Cygwin tools, not VC++,
+though I'd like
+>+>+>> to be able to send out binaries and not have everyone have to worry
+>+>+>> about compiling at all.
+>+>+>>
+>+>+>> I found a binary package of 7.0 for Windows NT, but the Docs for
+>+>+>> Windows seem to be only how to compile and install one library dll.
+>+>+>> Since i have a binary package, I hope I don't need to
+compile, but in
+>+>+>> any case, I still don't know how to install.
+>+>+>>
+>+>+>> Thanks in advance for any help.
+>+>+>
+>+>+>--
+>+>+>tonio@novadeck.com - http://nioto.com/
+>+>+
+>+>+
+>+>+---------------------------(end of
+broadcast)---------------------------
+>+>+TIP 4: Don't 'kill -9' the postmaster
+>+>+
+>+>
+>+>
+>+>---------------------------(end of broadcast)---------------------------
+>+>TIP 3: if posting/reading through Usenet, please send an appropriate
+>+>subscribe-nomail command to majordomo@postgresql.org so that your
+>+>message can get through to the mailing list cleanly
+>+
+>+
+>+---------------------------(end of broadcast)---------------------------
+>+TIP 5: Have you checked our extensive FAQ?
+>+
+>+http://www.postgresql.org/users-lounge/docs/faq.html
+>+
+>
+>
+>---------------------------(end of broadcast)---------------------------
+>TIP 6: Have you searched our list archives?
+>
+>http://www.postgresql.org/search.mpl
+
+
+---------------------------(end of broadcast)---------------------------
+TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
+


RE: Re: Windows install

From
"charlie derr"
Date:
After further fussing, I found that this install works just fine.  It is a
7.0.3 version, not 7.1, but when I finally figured out that the default user
is "sysdba" instead of the "postgres" I expected, I was able to get it to
work.  None of the machinations I suggested earlier like "initdb" were
necessary.  Cygwin and Cygipc both get installed and configured properly
(though there are some stray registry keys that need to be manually deleted
if you uninstall, and then try to install again).

    sorry for any confusion i might have caused,
        ~c




+>+-----Original Message-----
+>+From: pgsql-general-owner@postgresql.org
+>+[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Steve Jorgensen
+>+Sent: Wednesday, April 04, 2001 6:55 PM
+>+To: pgsql-general@postgresql.org
+>+Subject: [GENERAL] Re: Windows install
+>+
+>+
+>+Thanks for the pointer.  Does this isntall require Cygwin and Cygipc
+>+to be installed first, or does it handle all that?
+>+
+>+On Wed, 04 Apr 2001 16:41:00 +0200, Antonio Da Silva
+>+<tonio@novadeck.com> wrote:
+>+
+>+>If you want an install version of PostGres
+>+>look @
+>+>http://208.160.255.143/
+>+>
+>+>or http://208.160.255.143/pgsql/pgsql.exe
+>+>
+>+>Tonio
+>+>


Re: Windows install

From
nospam@nospam.nospam (Steve Jorgensen)
Date:
>http://208.160.255.143/pgsql/pgsql.exe.  That's where I got what I'm working
>with.

Ah - that's the confusion.  I gave up on the pgsql.exe because it did
seem to run the server for me, but behaved badly on the system.  It
starts up when the user logs on, and it only works if you log on as
the same user who installed it.

After giving up on that, I noticed that they just added PostgreSQL to
the Cygwin download from Red Hat - http://sources.redhat.com/cygwin/.
My previous post is based on this as a starting point.