Обсуждение: PostGreSQL on Windows Help

Поиск
Список
Период
Сортировка

PostGreSQL on Windows Help

От
Stephan Richter
Дата:
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


Re: PostGreSQL on Windows Help

От
Jason Tishler
Дата:
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

Re: PostGreSQL on Windows Help

От
Stephan Richter
Дата:
>     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


Re: PostGreSQL on Windows Help

От
Fred Yankowski
Дата:
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