Date: Tue, 6 Mar 2018 08:21:24 -0500
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.
Message-ID: <20180306132124.GL2416@tamriel.snowman.net>
References: 
 <CADtiZxrsqkUjGOP7GBWpOgaW-_HYWtMNNs72sJrpkMy4n+S=3A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="FtAwfbRT+dym8Dt1"
Content-Disposition: inline
In-Reply-To: 
 <CADtiZxrsqkUjGOP7GBWpOgaW-_HYWtMNNs72sJrpkMy4n+S=3A@mail.gmail.com>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk


--FtAwfbRT+dym8Dt1
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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.
>=20
> ERROR:  could not open file "base/12669/16394": No such file or directory
>=20
> 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

--FtAwfbRT+dym8Dt1
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJanpXUAAoJEO1sijiDR2RVbzcQAKd4/XdQEQ5hKXsGDmVvcB+c
d1VuHLf20tmLMlQXLdCf7/sOgCZJAvZ8+1pnyOr7v1aWCNFB1vObfETQZwOB0Y8a
Elo3NIc+9yoX9+jT7Y75gjeQZbD41e2Dlz0/vAvV8k1jDOfaazVpZanc3+iNV/Zo
sCvcwTRwt2zpuEpOpkybzNTE0P+Wg/gn2gQbfUJMbH7rhH9CfLRX23nvhHs48EHC
b1NMSxt7zp658NdbK+FhTD7wI5fHU5gWjOZmzcrV51iuXkFdTXRtqpoqWdjVgb41
3QpvcUne3m/VA6YEWNMDG/NmYhcUJaC681LAa2Fn0BwedJP5WXYwyc/6VGqvsUbl
Vy0W3j/vMzL+20abQk/Q+SUP+NnxOAfRceZUr1wqNxoFLmDXW31RMojCIuum/w2W
PbIKmA6Sq3Yy3hLLV8YeMmhFEaq1/3J/OBF4zMDL39d3Zr4gkqwfBhjiS0y022c/
S1dmVUI+PFe0RNb+qhw7p8I2kmX6Zw1ONaMotbws69KzSVElW54SnyU/XUioKW1e
AwH2vSsjFfwQhZWkD1NDsfhKFlYY4JdNsbjSvjt7DYaTUhoSoyA+/u/kTnDVlB02
0CLziT8L4q5clKepAnLw9fQvw6n8mlLFmvtwPUgZcIXlE/b/rAO1g0kIraPJmZMq
EQNPJcK0xF6GXpVGJclK
=eu3I
-----END PGP SIGNATURE-----

--FtAwfbRT+dym8Dt1--