by mistake dropped physical file dropped for one table.

From: Rambabu V <ram(dot)wissen(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: by mistake dropped physical file dropped for one table.
Date: 2018-03-06 11:35:43
Message-ID: CADtiZxrsqkUjGOP7GBWpOgaW-_HYWtMNNs72sJrpkMy4n+S=3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rambabu V 2018-03-06 11:38:24 need meta data table/command to find query log
Previous Message Laurenz Albe 2018-03-06 09:59:04 Re: GIST index (polygon, point)