Postgres Pro
Downloads
Home   >   mailing lists

Thread: Running Postgresql on NT

Running Postgresql on NT

From
Christos Poulkas
Date:
Hi all,

I installed Joerg Hessdoerfer's NT version but I am
experiencing the problem below.

After starting postmaster with the -i option I can't run
any client program. By running createdb dbname I get
the error below:

$ createdb tpc
psql: connectDBStart() -- connect() failed: No more processes
        Is the postmaster running (with -i) at 'localhost'
        and accepting connections on TCP/IP port '5432'?
createdb: database creation failed

the same happens with psql.

Has anyone used posgresql successfully on NT?

Thanks,

Christos

Re: Running Postgresql on NT

From
Pete Forman
Date:
Christos Poulkas writes:
 > $ createdb tpc
 > psql: connectDBStart() -- connect() failed: No more processes
 >         Is the postmaster running (with -i) at 'localhost'
 >         and accepting connections on TCP/IP port '5432'?
 > createdb: database creation failed
 >
 > the same happens with psql.

You need to supply the additional arguments "-h localhost" to createdb
and psql.
--
Pete Forman                 -./\.- Disclaimer: This post is originated
Western Geophysical           -./\.-  by myself and does not represent
pete.forman@westgeo.com         -./\.-  the opinion of Baker Hughes or
http://www.crosswinds.net/~petef  -./\.-  its divisions.

Re: Running Postgresql on NT

From
Jason Tishler
Date:
Christos,

On Wed, Nov 01, 2000 at 11:24:59AM +0000, Christos Poulkas wrote:
> I installed Joerg Hessdoerfer's NT version but I am
> experiencing the problem below.
>
> After starting postmaster with the -i option I can't run
> any client program. By running createdb dbname I get
> the error below:
>
> $ createdb tpc
> psql: connectDBStart() -- connect() failed: No more processes
                                              ^^^^^^^^^^^^^^^^^
                                              *****************

>         Is the postmaster running (with -i) at 'localhost'
>         and accepting connections on TCP/IP port '5432'?
> createdb: database creation failed
>
> the same happens with psql.
>
> Has anyone used posgresql successfully on NT?

Yes, but only with Cygwin 1.1.4.  The above error was reported to the
Cygwin list by Volker:

    http://sources.redhat.com/ml/cygwin/2000-10/msg01590.html

I just downloaded cygwin-1.1.5-3 and was able to duplicate the problem.
I am beginning to debug now and will report back my findings.

BTW, what version of Cygwin are you using?  1.1.4, a snapshot, CVS, etc?

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

Re: Running Postgresql on NT

From
Jason Tishler
Date:
Christos,

On Wed, Nov 01, 2000 at 04:07:58PM +0000, Christos Poulkas wrote:
> I got the error using cygwin 1.1.4

I'm very unhappy to hear the above.  Please send me the output from:

    uname -a
    cygcheck -s -v -r

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

Re: Running Postgresql on NT

From
Jason Tishler
Date:
Christos,

On Wed, Nov 01, 2000 at 04:19:07PM +0000, Christos Poulkas wrote:
> Here is the information you requested:
>
> administrator@CBURTON ~
> $ uname -a
> CYGWIN_NT-4.0 CBURTON 1.1.5(0.29/3/2) 2000-10-29 00:56 i686 unknown
                        ^^^^^
                        *****

You are running 1.1.5 (or at least 1.1.4+) and not 1.1.4.

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