Re: Please help

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: ohp(at)pyrenet(dot)fr, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Please help
Date: 2002-10-21 17:59:38
Message-ID: 1035223178.395.19.camel@lerlaptop.iadfw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)lerctr(dot)org>
> > > To: ohp(at)pyrenet(dot)fr
> > > Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
> > > pgsql-hackers list <pgsql-hackers(at)postgresql(dot)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(at)pyrenet(dot)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(at)pyrenet(dot)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(at)lerctr(dot)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(at)postgresql(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2002-10-21 18:17:47 Re: [GENERAL] Security implications of (plpgsql) functions
Previous Message Larry Rosenman 2002-10-21 17:57:19 Re: Please help