Re: Postgres Instability

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