Sorry forgot to mention the thread I referred to -
http://archives.postgresql.org/pgsql-general/2010-12/msg01000.php
Thanks
VB
On Thu, Nov 3, 2011 at 3:48 PM, Venkat Balaji venkat.bal...@verse.inwrote:
Hello Everyone,
We had recently taken an online backup of our production database cluster
(pg_start_backup() - rsync - pg_stop_backup()).
We had built the testing cluster with the backup.
When we try to vacuum the database or vacuum full the testing database,
we are getting the following error.
vacuuming of database failed: ERROR: could not open file
base/44620/972355: No such file or directory
In an other situation-
postgres=# select * from table1 limit 10;
ERROR: could not open file base/44620/1022275: No such file or directory
After going through the below thread, one situation which we believe could
be the problem is -
- Table1 is a partitioned table and we keep dropping and adding partitions
on daily basis. This might have happened at the time we were backing up.
Is this the problem ? If yes, what precautions we need to take ? perform
the backup when there are no DDLs are happening ?
Both the base files 972355 and 1022275 are not existing in production
(probably they belong to dropped partitions -- not sure).
We have a data center migration coming up, so, this is very critical for
us -
PG Version - 9.0.1
OS - RHEL 5.5 (prod) and RHEL 6.1 (test)
Please help
Thanks
VB