Skip site navigation (1) Skip section navigation (2)

Re: Updated Cygwin Package: postgresql-7.4.2-1

From: Mike G <mike(at)thegodshalls(dot)com>
To: "Leeuw van der, Tim" <tim(dot)leeuwvander(at)nl(dot)unisys(dot)com>
Cc: "David P(dot) Lurie" <dbase4(at)hotmail(dot)com>,pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Updated Cygwin Package: postgresql-7.4.2-1
Date: 2004-06-14 20:27:32
Message-ID: 20040614202732.GA8845@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hi,

I am having the same problems on XP Pro.  I get a signal 12 selecting default max conections.

I looked at the postmaster.conf file created by initdb and noticed that the default connection max is set a 10.  On my 7.4.1-3 config file it is set at 100.  

I have seen 10 mentioned before, maybe in running postgres regression tests after compiling.  Perhaps it needs to be changed back.

Mike

On Mon, Jun 14, 2004 at 12:15:43PM +0200, Leeuw van der, Tim wrote:
> When installing as service, do you install it with postgres account? Or do you let it run with SYSTEM account?
> 
> --Tim
> 
> -----Original Message-----
> From: pgsql-cygwin-owner(at)postgresql(dot)org
> [mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of David P. Lurie
> Sent: zondag 13 juni 2004 23:37
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: Re: [CYGWIN] Updated Cygwin Package: postgresql-7.4.2-1
> 
> 
> Jason -
> 
> >     3. Cygwin PostgreSQL can fail to start or not function properly if
> >     certain files and directories have incorrect permissions.  The
> >     following usually solves these kinds of problems:
> >
> >         $ chmod a+rwx /tmp
> >         $ chmod a+rx /usr/bin /usr/bin/*
> >         $ chmod a+rw /var/log # could adversely affect other daemons
> >
> > In particular, note the third chmod above.
> >
> 
> I tried all three, without any success.
> 
> There was another problem with postgresql configuration that I hadn't
> mentioned. initdb failed when run as the user "postgres", but completed
> successfully under my usual login.
> 
> These permission changes now allow initdb to run from the "postgres"
> account. postmaster still successfully installs as a service, but fails to
> run, whether installed to run under my usual login or "postgres" (after
> initdb has been run under the appropriate account).
> 
> David
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

Responses

pgsql-cygwin by date

Next:From: SoniaDate: 2004-06-14 21:38:40
Subject: initdb failing
Previous:From: Tim J HartDate: 2004-06-14 18:14:17
Subject: Troubles with the 7.4.2-1 cygwin package

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group