Thanks
VB
On Thu, Nov 3, 2011 at 3:48 PM, Venkat Balaji <venkat.balaji@xxxxxxxx> wrote:
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 directoryIn an other situation-postgres=# select * from table1 limit 10;ERROR: could not open file "base/44620/1022275": No such file or directoryAfter 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.1OS - RHEL 5.5 (prod) and RHEL 6.1 (test)Please helpThanksVB
