Home > mailing lists

by mistake dropped physical file dropped for one table. - Mailing list pgsql-performance

From	Rambabu V
Subject	by mistake dropped physical file dropped for one table.
Date	March 6, 2018 17:35:43
Msg-id	CADtiZxrsqkUjGOP7GBWpOgaW-_HYWtMNNs72sJrpkMy4n+S=3A@mail.gmail.com Whole thread Raw
Responses	Re: by mistake dropped physical file dropped for one table. (Stephen Frost <sfrost@snowman.net>)
List	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.

From: Laurenz Albe
Date: 06 March 2018, 15:59:04
Subject: Re: GIST index (polygon, point)

From: Rambabu V
Date: 06 March 2018, 17:38:24
Subject: need meta data table/command to find query log