Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-docspgsql-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

Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK                   
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


pgsql-docs by date

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

pgsql-hackers by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group