Re: Postgres Instability - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: Postgres Instability
Date
Msg-id Pine.BSF.4.21.0005241715060.243-100000@thelab.hub.org
Whole thread Raw
In response to Postgres Instability  ("planx plnetx" <planetx2100@hotmail.com>)
Responses Re: Postgres Instability  (Vince Vielhaber <vev@michvhf.com>)
Re: Postgres Instability  (Lamar Owen <lamar.owen@wgcr.org>)
List pgsql-general
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 ...



 >
> 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


pgsql-general by date:

Previous
From: Giles Lean
Date:
Subject: Re: Migrating from mysql.
Next
From: Vince Vielhaber
Date:
Subject: Re: Postgres Instability