Re: Mapping a Data File Back to a Table

From: Greg Schenzel <inittab(at)unixdev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Mapping a Data File Back to a Table
Date: 2013-01-04 18:46:40
Message-ID: 20130104184639.GA12422@graphite.accessaxis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

It was stored in pg_largeobject based on the OID.

On Fri, Jan 04, 2013 at 11:09:33AM -0700, Greg Schenzel wrote:
> 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!
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jonathan Hayward 2013-01-04 18:56:25 Phantom half-install: How can I remove it completely?
Previous Message Greg Schenzel 2013-01-04 18:09:33 Mapping a Data File Back to a Table