Thread: Re: Windows install
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/
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/
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 +
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
+ + +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 +
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
+ +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 +
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
+>+>
>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.