From: Stephen Frost <sfrost@snowman.net>
To: Rambabu V <ram.wissen@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: by mistake dropped physical file dropped for one table.
Date: Tue, 6 Mar 2018 08:21:24 -0500
Message-ID: <20180306132124.GL2416@tamriel.snowman.net> (raw)
In-Reply-To: <CADtiZxrsqkUjGOP7GBWpOgaW-_HYWtMNNs72sJrpkMy4n+S=3A@mail.gmail.com>
References: <CADtiZxrsqkUjGOP7GBWpOgaW-_HYWtMNNs72sJrpkMy4n+S=3A@mail.gmail.com>
Greetings,
* Rambabu V (ram.wissen@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 table.
You're not likely able to recover that table. To do so would require
completely stopping the system immediately and attempting to perform
filesystem maniuplation to "undelete" the file, or pull back chunks from
the filesystem which contain pieces of the file and attempting to
reconstruct it.
If you've been keeping all WAL since the beginning of the cluster, it's
possible you could recover that way, but you claim to not have any
backups, so I'm guessing that's pretty unlikely.
Thanks!
Stephen
Attachments:
[application/pgp-signature] signature.asc (818B, ../20180306132124.GL2416@tamriel.snowman.net/2-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sfrost@snowman.net, ram.wissen@gmail.com
Subject: Re: by mistake dropped physical file dropped for one table.
In-Reply-To: <20180306132124.GL2416@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox