Re: [HACKERS] initdb should create a warning message [was Re:

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL hackers list <pgsql-hackers(at)postgresql(dot)org>, pgsql-docs(at)postgresql(dot)org
Subject: Re: [HACKERS] initdb should create a warning message [was Re:
Date: 2003-12-01 07:29:57
Message-ID: 1070263797.7719.2662.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-hackers

On Sun, 2003-11-30 at 23:18, Neil Conway wrote:
> Oliver Elphick <olly(at)lfix(dot)co(dot)uk> writes:
> > The use of the word "log" in the directory name does tend to invite
> > this error, and some have acted on it without asking first. I think
> > initdb should put a README.IMPORTANT file in $PGDATA to say [...]
>
> If someone deletes something from $PGDATA without understanding what
> it is, they deserve what they get.

People have a distressing tendency to want to shoot themselves in the
foot; and the somewhat unfortunate naming of those files contributes to
the problem. While it is satisfying to see stupidity properly rewarded,
it is more neighbourly at least to attempt to protect a fool from his
folly. It is also kinder to those who may be depending on him for the
protection of their data.

> I do agree that we could stand to document the purpose of pg_clog
> and pg_xlog more clearly. However, this information belongs in the
> standard documentation, not scattered throughout $PGDATA.

Then it needs to be stated very prominently. But the place to put a
sign saying "Dangerous cliff edge" is beside the path that leads along
it.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Who is like unto thee, O LORD, among the gods? who is
like thee, glorious in holiness, fearful in praises,
doing wonders?" Exodus 15:11

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Armel HERVE 2003-12-01 07:50:56 Re: Problem with pg_dump / pg_restore
Previous Message William Yu 2003-12-01 00:04:04 Re: filesystem suggestion for pg

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2003-12-01 15:13:11 Re: [HACKERS] initdb should create a warning message [was Re: [ADMIN] Size on Disk]
Previous Message Bruce Momjian 2003-12-01 04:48:04 Re: Numeric version of factorial()

Browse pgsql-hackers by date

  From Date Subject
Next Message phd9110 2003-12-01 10:31:56 Where does catalog store CHAR length ?
Previous Message Jonathan Gardner 2003-12-01 06:49:59 Partitions implementation with views