Re: by mistake dropped physical file dropped for one table.

2018-03-06 Thread Rambabu V
Ok, thanks. On Mar 6, 2018 6:51 PM, "Stephen Frost" wrote: > Greetings, > > * Rambabu V (ram.wis...@gmail.com) wrote: > > by mistake one physical file dropped for one of our table, as we do-not > > have backup for this table we are getting below error. > > > > ERROR: could not open file "base/1

Re: by mistake dropped physical file dropped for one table.

2018-03-06 Thread Stephen Frost
Greetings, * Rambabu V (ram.wis...@gmail.com) wrote: > by mistake one physical file dropped for one of our table, as we do-not > have backup for this table we are getting below error. > > ERROR: could not open file "base/12669/16394": No such file or directory > > please help us to recover the

by mistake dropped physical file dropped for one table.

2018-03-06 Thread Rambabu V
Hi Team, by mistake one physical file dropped for one of our table, as we do-not have backup for this table we are getting below error. ERROR: could not open file "base/12669/16394": No such file or directory please help us to recover the table. Regards, Rambabu Vakada, PostgreSQL DBA.