public inbox for [email protected]
help / color / mirror / Atom feedFrom: Alvaro Herrera <[email protected]>
To: Marc G. Fournier <[email protected]>
Cc: Josh Berkus <[email protected]>
Cc: [email protected]
Cc: Bruce Momjian <[email protected]>
Cc: PostgreSQL www <[email protected]>
Subject: Re: [pgsql-advocacy] Server unreliability
Date: Wed, 29 Sep 2004 16:15:56 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
On Wed, Sep 29, 2004 at 04:07:20PM -0300, Marc G. Fournier wrote:
> as to what advantages the jail's provide ... mainly, security ... we can
> easily provide root access to pugs.postgresql.org, as an example, so that
> Fred (please tell me I remembered right?) can do whatever work he wants,
> without giving him full root on the developer jail ... same with all of
> the other jails ... Chris has full root on gborg, so that he doesn't have
> to ask someone else to do something when he notices a problem (ie. restart
> mailman) ...
This business about anyone having to restart anything is strange. I
don't run mailman lists personally anymore, but back when I used to,
there was no need to restart anything. This sounds like there are other
reliability problems that should be attacked.
Also I understand that it's a problem that fsck takes 8 hours to run.
However, why on earth is fsck running in the first place? Do the
servers go down unexpectedly on regular basis? This also screams of a
more fundamental problem that should be solved.
Another thing: I've seen several times already PHP warnings show up
about pg_query not getting a good connection or similar problems. Isn't
normal advice to check return codes before even trying to use the
connections? Why isn't this done in the main postgresql.org code, where
anyone can see it, is beyond me. Of course the solution to the
underlying problem is to restart the Postgres server, but why should we
inform the user that Postgres' own database server is down, in the worst
possible way?
Just random thoughts ...
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Hay dos momentos en la vida de un hombre en los que no deberÃa
especular: cuando puede permitÃrselo y cuando no puede" (Mark Twain)
view thread (74+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: [pgsql-advocacy] Server unreliability
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox