Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TsCdA-0004rG-9Y for pgsql-admin@arkaria.postgresql.org; Mon, 07 Jan 2013 13:20:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TsCd9-0000RH-B0 for pgsql-admin@arkaria.postgresql.org; Mon, 07 Jan 2013 13:20:43 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TrBi4-0002dk-FM for pgsql-admin@postgresql.org; Fri, 04 Jan 2013 18:09:36 +0000 Received: from graphite.accessaxis.com ([71.42.172.75]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TrBi2-000868-Jx for pgsql-admin@postgresql.org; Fri, 04 Jan 2013 18:09:35 +0000 Received: by graphite.accessaxis.com (Postfix, from userid 1001) id 604CF23D39; Fri, 4 Jan 2013 11:09:33 -0700 (MST) Date: Fri, 4 Jan 2013 11:09:33 -0700 From: Greg Schenzel To: pgsql-admin@postgresql.org Subject: Mapping a Data File Back to a Table Message-ID: <20130104180933.GA21370@graphite.accessaxis.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="ew6BAiZeqk4r7MaW" Content-Disposition: inline User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --ew6BAiZeqk4r7MaW Content-Type: text/plain; charset=us-ascii Content-Disposition: inline So I've been digging through a database on an embedded device for two days trying to figure out which table some data is stored in. There are litterally 1000 tables in the database and I haven't come across the right one(s) yet. I know that the data I'm looking for is stored in /var/lib/pgsql/data/base/16384/2613 from strings and grep. Is there any way to map this back to a table or group of tables? Any insight would be greatly appreciated! --ew6BAiZeqk4r7MaW Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAlDnGt0ACgkQ2ua/BJvbazd3wQCgwUUWs7bAJ2eu7YDnj9YeCHOZ W4kAniHpM+vNmsFL7VNdWM10BFiNGZiq =9Ij9 -----END PGP SIGNATURE----- --ew6BAiZeqk4r7MaW--