From: | "Nacho Mezzadra" <nachomezzadra(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5603: pg_tblspc and pg_twoface directories get deleted when starting up service |
Date: | 2010-08-05 18:46:53 |
Message-ID: | 201008051846.o75Ikrl0057510@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5603
Logged by: Nacho Mezzadra
Email address: nachomezzadra(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2010-08-05 18:47:11 | Re: [HACKERS] Drop one-argument string_agg? (was Re: string_agg delimiter having no effect with order by) |
Previous Message | Tom Lane | 2010-08-05 18:45:49 | Re: [HACKERS] Drop one-argument string_agg? (was Re: string_agg delimiter having no effect with order by) |