Re: Postgres Instability - Mailing list pgsql-general

From Vince Vielhaber
Subject Re: Postgres Instability
Date
Msg-id Pine.BSF.4.21.0005241647020.44999-100000@paprika.michvhf.com
Whole thread Raw
In response to Re: Postgres Instability  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
On Wed, 24 May 2000, The Hermit Hacker wrote:

> On Wed, 24 May 2000, planx plnetx wrote:
>
> > I've remarked that postgresql-7.0 have two important bugs no, no...
> > I'll define its Problems.
> >
> > The first is  that it is very subsceptible to ipc: it's true that sometimes
> > U need to do an ipcclean to remake it start
>
> This sounds like a Linux problem to me ... I've got v7.0 running on a
> server over here that is dealign with the Search engine for the PostgreSQL
> site (over 10million tuples in one table, indexing over 90k URLs) and the
> server has been running flawlessly for the past ~14days now, and what is
> only because that was the last time we rebooted it ...

Ditto, except the uptime here (PostgreSQL running all the time taking
care of user's mailboxes, web server, etc.):  265 days, 20:43  running
FreeBSD-3.2-Rel.

Vince.

>
>
>
>  >
> > The second is the very VERY important instability problem.
> > I explain me better: I've tried Postgres on different systems
> > (redhat6.0,6.1, mandrake7.0) and every time after that I make  start the
> > postmaster 20 or 30  times  in a week  or 2,  it begin to have  a problem
> > with shared memory, but i do an ipcclean and go..., after when
> > postmaster run without problems if I do a createuser (from sqladmin) or
> > a createdb (from user) it give me the same problem like:
> >
> > ------------------------------------------------
> > FATAL 1: cannot create  init file
> > mydatabasedirectory//base/mydb/pg_internal.init
> > ------------------------------------------------
> >
> > it happens after few times of correct running... and persist also  if I
> > recompile again postgresql
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
>
> Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org
>
>

--
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Postgres Instability
Next
From: "Bryan White"
Date:
Subject: PG 7.0 is 2.5 times slower running a big report