Обсуждение: binaries for win2000?
hello. i want to install postgres on a win2000 platform. i don't have the resources to compile the source...i'm just looking for the binaries and any necessary related info. where can i find them? please respond directly to me (chris.markiewicz@commnav.com) ...i'm not a member of the ports list. thanks chris
Chris,
On Mon, Apr 09, 2001 at 10:03:52AM -0400, chris markiewicz wrote:
> hello. i want to install postgres on a win2000 platform. i don't have the
> resources to compile the source...i'm just looking for the binaries and any
> necessary related info. where can i find them?
See the following:
http://cygwin.com/ml/cygwin/2001-04/msg00617.html
Jason
--
Jason Tishler
Director, Software Engineering Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp. Fax: +1 (732) 264-8798
82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Hello we have been trying to run postgres on a win2000 machine. got the latest cygwin stuff today (4/11/2001) and installed it. initdb hangs. i checked the archives and found the following thread (the following link has the final leaf of the thread): http://www.postgresql.org/mhonarc/pgsql-ports/2001-03/msg00124.html i also have debug information (see end of email). Does all of this mean that i need to grab a recent development snapshot of the cygwin1.dll file? IF SO...(i know this is a question for cygwin, but since we're here) i go to the snapshot area and click on the ftp link and i get a "page cannot be displayed" message. what am i doing wrong? thanks chris (debug below) Running with debug mode on. Initdb variables: PGDATA=/usr/bin/data datadir=/usr/share/postgresql PGPATH=/usr/bin TEMPFILE=/tmp/initdb.1096 MULTIBYTE= MULTIBYTEID=0 POSTGRES_SUPERUSERNAME=administrator POSTGRES_SUPERUSERID=500 TEMPLATE1_BKI=/usr/share/postgresql/template1.bki GLOBAL_BKI=/usr/share/postgresql/global.bki TEMPLATE1_DESCR=/usr/share/postgresql/template1.description GLOBAL_DESCR=/usr/share/postgresql/global.description POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample This database system will be initialized with username "administrator". This user will own all the data files and must also own the server process. Fixing permissions on existing directory /usr/bin/data Creating directory /usr/bin/data/base Creating directory /usr/bin/data/global Creating directory /usr/bin/data/pg_xlog Creating template1 database in /usr/bin/data/base/1 Running: /usr/bin/postgres -boot -x1 -C -F -D/usr/bin/data -d template1
Chris, On Wed, Apr 11, 2001 at 02:35:07PM -0400, chris markiewicz wrote: > we have been trying to run postgres on a win2000 machine. got the latest > cygwin stuff today (4/11/2001) and installed it. initdb hangs. i checked > the archives and found the following thread (the following link has the > final leaf of the thread): What does uname -r display? If it indicates "1.1.8...", then you must upgrade to a recent snapshot. > http://www.postgresql.org/mhonarc/pgsql-ports/2001-03/msg00124.html The above is only relevant *if* you are building PostgreSQL yourself -- not if you are using a pre-built version. Just to be sure, are you using the 7.1rc4 that I contributed to Cygwin? > i also have debug information (see end of email). Sorry, but I can't make much out of your debug info. > Does all of this mean that i need to grab a recent development snapshot of > the cygwin1.dll file? Most likely, see the following for one way of replacing your Cygwin DLL: http://www.postgresql.org/mhonarc/pgsql-ports/2001-03/msg00096.html > IF SO...(i know this is a question for cygwin, but since we're here) i go to > the snapshot area and click on the ftp link and i get a "page cannot be > displayed" message. what am i doing wrong? No one can download from the Cygwin FTP site anymore. You must use a mirror. Try the following: ftp://mirrors.rcn.net/mirrors/sources.redhat.com/cygwin/snapshots/ > Running with debug mode on. > > Initdb variables: > PGDATA=/usr/bin/data BTW, the above is a strange value for PGDATA. I would use /usr/share/postgresql/data instead. Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Jason, uname -r returns 1.3.0s(0.37/3/2) is that significant? Looks like we're still having the same problem, even after grabbing the most recent dll and changing our PGDATA value. you are correct that i am not doing any building of my own (i have neither the tools nor the expertise). thanks for the help, btw. chris -----Original Message----- From: Jason Tishler [mailto:Jason.Tishler@dothill.com] Sent: Wednesday, April 11, 2001 5:49 PM To: chris markiewicz Cc: pgsql-ports@postgresql.org; chris.markiewicz@commnav.com Subject: Re: [PORTS] initdb problem... Chris, On Wed, Apr 11, 2001 at 02:35:07PM -0400, chris markiewicz wrote: > we have been trying to run postgres on a win2000 machine. got the latest > cygwin stuff today (4/11/2001) and installed it. initdb hangs. i checked > the archives and found the following thread (the following link has the > final leaf of the thread): What does uname -r display? If it indicates "1.1.8...", then you must upgrade to a recent snapshot. > http://www.postgresql.org/mhonarc/pgsql-ports/2001-03/msg00124.html The above is only relevant *if* you are building PostgreSQL yourself -- not if you are using a pre-built version. Just to be sure, are you using the 7.1rc4 that I contributed to Cygwin? > i also have debug information (see end of email). Sorry, but I can't make much out of your debug info. > Does all of this mean that i need to grab a recent development snapshot of > the cygwin1.dll file? Most likely, see the following for one way of replacing your Cygwin DLL: http://www.postgresql.org/mhonarc/pgsql-ports/2001-03/msg00096.html > IF SO...(i know this is a question for cygwin, but since we're here) i go to > the snapshot area and click on the ftp link and i get a "page cannot be > displayed" message. what am i doing wrong? No one can download from the Cygwin FTP site anymore. You must use a mirror. Try the following: ftp://mirrors.rcn.net/mirrors/sources.redhat.com/cygwin/snapshots/ > Running with debug mode on. > > Initdb variables: > PGDATA=/usr/bin/data BTW, the above is a strange value for PGDATA. I would use /usr/share/postgresql/data instead. Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
On Thu, Apr 12, 2001 at 09:26:48AM -0400, chris markiewicz wrote: > uname -r returns 1.3.0s(0.37/3/2) > > is that significant? Yes, the above indicates that you are running a snapshot -- this is good. > Looks like we're still having the same problem, even after grabbing the most > recent dll and changing our PGDATA value. I think that I know what your problem is. Did you forget to start the ipc-daemon? This must be running whenever postmaster is running. Otherwise, initdb, postmaster, etc. will hang. Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Jason Tishler writes: > I think that I know what your problem is. Did you forget to start the > ipc-daemon? This must be running whenever postmaster is running. > Otherwise, initdb, postmaster, etc. will hang. Isn't there some way this could behave more intelligently? I would think that if ipc-daemon isn't running then there is no SysV IPC and shmget() or semget() should fail with some error. Or it could die horribly, but not hang. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
Peter, On Fri, Apr 13, 2001 at 12:53:05AM +0200, Peter Eisentraut wrote: > Jason Tishler writes: > > > I think that I know what your problem is. Did you forget to start the > > ipc-daemon? This must be running whenever postmaster is running. > > Otherwise, initdb, postmaster, etc. will hang. > > Isn't there some way this could behave more intelligently? I would think > that if ipc-daemon isn't running then there is no SysV IPC and shmget() or > semget() should fail with some error. Or it could die horribly, but not > hang. My WAG is yes, but I haven't looked into the (cygipc) code. Note that with cygipc 1.09 and later (thanks to Fred), ipc-daemon can be installed as an NT service. Once ipc-daemon is installed as such, it is automatically started when NT is booted. Since I always install ipc-daemon as a service, I have little motivation to track down this hang. However, I hope not to discourage anyone else from finding the cause of the hang and fixing it. Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com