Re: Postgres Instability

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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
>

--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)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
==========================================================================