Обсуждение: PostgreSQL on NT
I'm all new the PostgreSQL system, so please excuse me if this is the wrong list. I want to check how I can use PostgreSQL on a WEB-server (NT, IIS). Is there a pre-build binary NT distribution of PostgreSQL (+ tools needed), or do I have to build it from scratch myself. If it does exist, where to I find it. Thanks for any help / hints. Nikolai Kirsebom
Kirsebom Nikolai wrote: > I'm all new the PostgreSQL system, so please excuse me if this is the wrong > list. > > I want to check how I can use PostgreSQL on a WEB-server (NT, IIS). > > Is there a pre-build binary NT distribution of PostgreSQL (+ tools needed), > or do I have to build it from scratch myself. If it does exist, where to I > find it. I don't put pre-build binary NT in PostgreSQL ftp site. But you would see my page for building binary yourself :-) http://people.freebsd.org/~kevlo/postgres/portNT.html > Thanks for any help / hints. > > Nikolai Kirsebom Hope this helps, Kevin.
I will host it on my site. I have plenty of HD space... Fredrick Bartlett Kevin Lo wrote: > Kirsebom Nikolai wrote: > > > I'm all new the PostgreSQL system, so please excuse me if this is the wrong > > list. > > > > I want to check how I can use PostgreSQL on a WEB-server (NT, IIS). > > > > Is there a pre-build binary NT distribution of PostgreSQL (+ tools needed), > > or do I have to build it from scratch myself. If it does exist, where to I > > find it. > > I don't put pre-build binary NT in PostgreSQL ftp site. > But you would see my page for building binary yourself :-) > > http://people.freebsd.org/~kevlo/postgres/portNT.html > > > Thanks for any help / hints. > > > > Nikolai Kirsebom > > Hope this helps, > Kevin.
Fredrick, On Thu, Nov 09, 2000 at 08:02:52AM -0800, Fredrick Bartlett wrote: > I will host it on my site. I have plenty of HD space... I can provide you with postgresql-7.0.2-10.tar.gz (about 2.7 MB) or you can use the attached instructions and script. Thanks, Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corporation Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com # apply patch cd postgresql-7.0.2 patch -p1 <patch.diff # configure cd src time configure 2>&1 | tee configure.out # make time make 2>&1 | tee make.out # make install time make POSTGRESDIR=/tmp/pgsql/usr/local/pgsql install 2>&1 | tee make-install.out # strip executables strip /tmp/pgsql/usr/local/pgsql/bin/*.exe # copy pq.dll to bin cp /tmp/pgsql/usr/local/pgsql/lib/pq.dll /tmp/pgsql/usr/local/pgsql/bin # make install (docs) cd ../doc time make POSTGRESDIR=/tmp/pgsql/usr/local/pgsql install 2>&1 | tee make-install.out # create man cat dirs mkdir /tmp/pgsql/usr/local/pgsql/man/cat1 /tmp/pgsql/usr/local/pgsql/man/catl # fix doc symlinks cd /tmp/pgsql/usr/local/pgsql/doc fixdoc.sh # create package cd /tmp/pgsql tar -cvzf postgresql-7.0.2-X.tar.gz usr
Вложения
Fredrick, On Thu, Nov 09, 2000 at 07:16:18PM -0800, Fredrick Bartlett wrote: > I was refering to hosting a "compiled" binary. That is what people are > asking for... > > Jason Tishler wrote: > > On Thu, Nov 09, 2000 at 08:02:52AM -0800, Fredrick Bartlett wrote: > > > I will host it on my site. I have plenty of HD space... > > > > I can provide you with postgresql-7.0.2-10.tar.gz (about 2.7 MB) or you can > > use the attached instructions and script. Sorry that I was not precise enough. But, the above mentioned postgresql-7.0.2-10.tar.gz *is* a pre-compiled binary. I wasn't sure that you would accept a binary built by someone else. So, I was also providing you with my build recipe just in case you wanted to build it yourself. Anyway, I'll willing to email or ftp postgresql-7.0.2-10.tar.gz if you want it. Let me know how you would like to proceed. Thanks, Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corporation Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Yes that would be great. Would you also be able to provide instructions on how to install a functional win32 PostgreSQL server. There are many DBA's, interested users etc. who are not programmers that would benefit from a win32 version that can be installed i.e.. "setup.exe". PostgreSQL would gain a greater audience/user base by providing a server that can be easily installed into the win32 environment. This would include not just PostgreSQL, but the entire cygwin/PostgreSQL solution. With regards to win32<>Linux, I'm on both sides of the fence. If I had a "solid" win32<>Linux PostgreSQL solution I might be more inclined to use/develop using PostgreSQL. As it is I, cannot use PostgreSQL for my win32 clients, so I am stuck with other Server's that provide support for win32<>Linux. This should be a wake up call to all the propeller heads (I am one) out there working on PostgreSQL, wiggle that hot dog in front of their noses and they will come... Fredrick Bartlett Jason Tishler wrote: > Fredrick, > > On Thu, Nov 09, 2000 at 07:16:18PM -0800, Fredrick Bartlett wrote: > > I was refering to hosting a "compiled" binary. That is what people are > > asking for... > > > > Jason Tishler wrote: > > > On Thu, Nov 09, 2000 at 08:02:52AM -0800, Fredrick Bartlett wrote: > > > > I will host it on my site. I have plenty of HD space... > > > > > > I can provide you with postgresql-7.0.2-10.tar.gz (about 2.7 MB) or you can > > > use the attached instructions and script. > > Sorry that I was not precise enough. But, the above mentioned > postgresql-7.0.2-10.tar.gz *is* a pre-compiled binary. I wasn't sure that > you would accept a binary built by someone else. So, I was also providing > you with my build recipe just in case you wanted to build it yourself. > Anyway, I'll willing to email or ftp postgresql-7.0.2-10.tar.gz if you > want it. Let me know how you would like to proceed. > > Thanks, > Jason > > -- > Jason Tishler > Director, Software Engineering Phone: +1 (732) 264-8770 x235 > Dot Hill Systems Corporation Fax: +1 (732) 264-8798 > 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com > Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Fredrick, On Sat, Nov 11, 2000 at 08:19:46AM -0800, Fredrick Bartlett wrote: > Yes that would be great. I would prefer to ftp and not mail bomb you. Do you have an incoming ftp area? > Would you also be able to provide instructions > on how to install a functional win32 PostgreSQL server. Kevin Lo has already provided the above. See the following: http://people.freebsd.org/~kevlo/postgres/portNT.html > There are > many DBA's, interested users etc. who are not programmers that would > benefit from a win32 version that can be installed i.e.. "setup.exe". > PostgreSQL would gain a greater audience/user base by providing a server > that can be easily installed into the win32 environment. This would > include not just PostgreSQL, but the entire cygwin/PostgreSQL solution. The above is exactly what we are doing. I wrangled the perl script, update-setup, that creates the setup.ini file used by Cygwin's setup.exe from its author. With update-setup, it is very simple to create custom Cygwin installations. One approach is to create a setup that installs all Cygwin packages plus PostgreSQL. Another approach installs only the minimum necessary Cygwin packages plus PostgreSQL. And yet another approach installs only PostgreSQL, the user would be required to install Cygwin from a mirror too. Note that in all of these approaches, the user is using the same setup.exe -- possibly more than once to different URLs. I must point out that the author sent me update-setup under the conditions of no support. I will contact him and ask his permission to send you a copy. If he gives permission, which is likely if you agree to no support too, then I will forward a copy to you. > With regards to win32<>Linux, I'm on both sides of the fence. > If I had a "solid" win32<>Linux PostgreSQL solution I might be more > inclined to use/develop using PostgreSQL. As it is I, cannot use > PostgreSQL for my win32 clients, so I am stuck with other Server's > that provide support for win32<>Linux. This should be a wake up call > to all the propeller heads (I am one) out there working on PostgreSQL, > wiggle that hot dog in front of their noses and they will come... Hmm...from where did the above come? I'm not touching this one with a 10 ft. pole! :,) Thanks, Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corporation 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 wrote: > Fredrick, > > On Sat, Nov 11, 2000 at 08:19:46AM -0800, Fredrick Bartlett wrote: > > Yes that would be great. > > I would prefer to ftp and not mail bomb you. Do you have an incoming ftp > area? > > > Would you also be able to provide instructions > > on how to install a functional win32 PostgreSQL server. > > Kevin Lo has already provided the above. See the following: > > http://people.freebsd.org/~kevlo/postgres/portNT.html > > > There are > > many DBA's, interested users etc. who are not programmers that would > > benefit from a win32 version that can be installed i.e.. "setup.exe". > > PostgreSQL would gain a greater audience/user base by providing a server > > that can be easily installed into the win32 environment. This would > > include not just PostgreSQL, but the entire cygwin/PostgreSQL solution. > > The above is exactly what we are doing. I wrangled the perl script, > update-setup, that creates the setup.ini file used by Cygwin's setup.exe > from its author. With update-setup, it is very simple to create custom > Cygwin installations. One approach is to create a setup that installs > all Cygwin packages plus PostgreSQL. Another approach installs only > the minimum necessary Cygwin packages plus PostgreSQL. And yet another > approach installs only PostgreSQL, the user would be required to install > Cygwin from a mirror too. Note that in all of these approaches, the > user is using the same setup.exe -- possibly more than once to different > URLs. > > I must point out that the author sent me update-setup under the conditions > of no support. I will contact him and ask his permission to send you > a copy. If he gives permission, which is likely if you agree to no > support too, then I will forward a copy to you. > > > With regards to win32<>Linux, I'm on both sides of the fence. > > If I had a "solid" win32<>Linux PostgreSQL solution I might be more > > inclined to use/develop using PostgreSQL. As it is I, cannot use > > PostgreSQL for my win32 clients, so I am stuck with other Server's > > that provide support for win32<>Linux. This should be a wake up call > > to all the propeller heads (I am one) out there working on PostgreSQL, > > wiggle that hot dog in front of their noses and they will come... > > Hmm...from where did the above come? I'm not touching this one with a > 10 ft. pole! :,) Remember Pavlog's Dog!!! Create some interest by showing the win32 world PostgreSQL. > > > Thanks, > Jason > > -- > Jason Tishler > Director, Software Engineering Phone: +1 (732) 264-8770 x235 > Dot Hill Systems Corporation Fax: +1 (732) 264-8798 > 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com > Hazlet, NJ 07730 USA WWW: http://www.dothill.com