Re: Please help - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: Please help
Date
Msg-id 1035223178.395.19.camel@lerlaptop.iadfw.net
Whole thread Raw
In response to Re: Please help  (Larry Rosenman <ler@lerctr.org>)
List pgsql-hackers
On Mon, 2002-10-21 at 12:57, Larry Rosenman wrote:
> On Mon, 2002-10-21 at 12:39, Olivier PRENANT wrote:
> > Hi larry,
> > 
> > Glad to see you around...
> > On 21 Oct 2002, Larry Rosenman wrote:
> > 
> > > Date: 21 Oct 2002 12:34:48 -0500
> > > From: Larry Rosenman <ler@lerctr.org>
> > > To: ohp@pyrenet.fr
> > > Cc: Tom Lane <tgl@sss.pgh.pa.us>,
> > >      pgsql-hackers list <pgsql-hackers@postgresql.org>
> > > Subject: Re: [HACKERS] Please help
> > > > The point is, it occurs today for the very first time!
> > > > Question: does (with 7.2) augmenting max_connection suffice, or do I have
> > > > to recompile?
> > > You might need to up the Shared Memory parameters and the Semaphore
> > > Parameters in your OS (UnixWare IIRC). 
> > I did!
> Ok.
> > > > 
> > > > That's the only thing that comes to my mind! I changed max_coneections
> > > > (and related parameters) in postgresql.conf only...
> > > > 
> > > > I say that, because I tried to change socket_directory in postgresql.conf 
> > > > and clients didn't work anymore
> > Sorry, I mis-explain!
> > I mean changing socket_directory in postgresql.conf and restart server did
> > create .s.PGSQL.5432 in the new dir, however clients (like psql) still
> > want it in /tmp!!
> That **WOULD** take a recompile. 
Or (IIRC), changing the connect string passed from PHP to PostgreSQL.

> 
> LER
> > 
> >  > See above. 
> > > 
> > > 
> > > > > 
> > > > >             regards, tom lane
> > > > > 
> > > > 
> > > > -- 
> > > > Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
> > > > Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
> > > > 31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
> > > > FRANCE                      Email: ohp@pyrenet.fr
> > > > ------------------------------------------------------------------------------
> > > > Make your life a dream, make your dream a reality. (St Exupery)
> > > > 
> > > > 
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 4: Don't 'kill -9' the postmaster
> > > > 
> > > 
> > 
> > -- 
> > Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
> > Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
> > 31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
> > FRANCE                      Email: ohp@pyrenet.fr
> > ------------------------------------------------------------------------------
> > Make your life a dream, make your dream a reality. (St Exupery)
> -- 
> Larry Rosenman                     http://www.lerctr.org/~ler
> Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Please help
Next
From: Robert Treat
Date:
Subject: Re: [GENERAL] Security implications of (plpgsql) functions