Thread: PostGreSQL on Windows Help
Hello everyone, I am using PostGreSQL for all my Web site's data. Now, a client of mine wants to use one of my "applications" off-line as well on a Windoze machine. I got all the other software to work fine there, but I have troubles getting PostGreSQL to run. The descriptions on the mailing lists are spare and I have not yet found a good step by step description. Currently I am at the infamous "FATAL 1: SetPgUserName: no entry in host passwd file" problem and noone gives a clear answer how to solve it. But that is already much more than I want. I just want the PostGreSQL server running locally without networking ability...all I want is to connect to a DB using the PyGreSQL Python module. Is there any way I can solve my problem quickly and clean? I do not want to install the entire Cygnus tools on my clients computer either. Thank you very much for your time in advance. Regards, Stephan -- Stephan Richter CBU - Physics and Chemistry Student Web2k - Web Design/Development & Technical Project Management
Stephan,
On Tue, Jan 16, 2001 at 06:46:59PM -0600, Stephan Richter wrote:
> The descriptions on the mailing lists are spare and I have not yet found a
> good step by step description.
Have you tried the following?
http://people.freebsd.org/~kevlo/postgres/portNT.html
> Currently I am at the infamous "FATAL
> 1: SetPgUserName: no entry in host passwd file" problem and noone gives a
> clear answer how to solve it.
Do you have an /etc/passwd file? If not, then on NT/2000 run the following:
mkpasswd -l >/etc/passwd
or
mkpasswd -d >/etc/passwd
for a workgroup or domain environment, respectively.
If you are on 9X/ME, then you will have to construct /etc/passwd by
hand.
> But that is already much more than I want.
> I just want the PostGreSQL server running locally without networking
> ability...all I want is to connect to a DB using the PyGreSQL Python
> module. Is there any way I can solve my problem quickly and clean? I do not
> want to install the entire Cygnus tools on my clients computer either.
Sorry, you are on your own here. At a minimum, you will have to install
the cygwin, ash (i.e., sh), and textutils packages. I'm sure that there
are others. If you determine the minimal set, please post your findings
to the list.
Thanks,
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
> http://people.freebsd.org/~kevlo/postgres/portNT.html Yeah, I found it last night after a lot of searching!!! > > Currently I am at the infamous "FATAL > > 1: SetPgUserName: no entry in host passwd file" problem and noone gives a > > clear answer how to solve it. After fiddling with it, I got it. :-) >Sorry, you are on your own here. At a minimum, you will have to install >the cygwin, ash (i.e., sh), and textutils packages. I'm sure that there >are others. If you determine the minimal set, please post your findings >to the list. I will try to do that right now. I know for sure that I'll need: cygwin1.dll ash pgsql (full dir tree) I will post my results ASAP! Regards, Stephan -- Stephan Richter CBU - Physics and Chemistry Student Web2k - Web Design/Development & Technical Project Management
On Wed, Jan 17, 2001 at 07:05:20PM -0600, Stephan Richter wrote: > I will try to do that right now. I know for sure that I'll need: > > cygwin1.dll > ash > pgsql (full dir tree) Better get fileutils too since postgres makes system() calls to 'rm' and 'cp'. Make sure those are in the PATH as well. -- Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA