On Thu, Aug 5, 2010 at 2:46 PM, Nacho Mezzadra <nachomezza...@gmail.com> wrote: > > The following bug has been logged online: > > Bug reference: 5603 > Logged by: Nacho Mezzadra > Email address: nachomezza...@gmail.com > PostgreSQL version: 8.3.11 > Operating system: Red Hat Enterprise 5.3 > Description: pg_tblspc and pg_twoface directories get deleted when > starting up service > Details: > > This issue happened not very frequently, but it happened to me 3 times, in 3 > different Red Hat servers. > The thing is that when stopping the Postgresql service with the > "/sbin/service postgresql-8.3 stop" command, and after that starting it with > the "/sbin/service postgresql-8.3 start" command (haven't tried with the > restart one though), a few times both pg_tblspc and pg_twoface directories > (inside data directory) get somehow deleted and hence the start service > command fails. Looking in the log files I find the following error: > > 2010-07-19 16:54:55 ISTFATAL: could not open directory "pg_tblspc": No such > file or directory > > So I manually create the "pg_tblspc" directory, and then try to start again > the service unsuccessfully, getting this time a similar error, but saying > that pg_twoface directory doesn't exist. > > After creating the pg_twoface directory, service can be successfully > started. > > Please note that all these always happened running the service command as > root. > All 3 linux boxes are running over a VMWare host.
This is pretty scary, but it's a little hard to believe that Red Hat would ship a script which had even the faintest chance of obliterating two critical directories. Especially since the guy who does the packaging of PostgreSQL over thereabouts is our most knowledgeable, experienced, and prolific committer. So I suspect you've a (broken) custom script, or a cron job that's doing something evil, or some other weirdness that is specific to your installations, but you haven't provided enough details to speculate in detail (for example, perhaps you could reply to the list and post a copy of the script you think is doing this). Also, I'm pretty sure that we don't have a directory called pg_twoface, though it would pretty funny if we did. It's fairly obvious what this is meant to say, but it doesn't. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
