pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Retrieving data from the data files. 2+ messages / 2 participants [nested] [flat]
* Retrieving data from the data files. @ 2008-02-26 06:19 Darren Reed <darrenr@fastmail.net> 0 siblings, 0 replies; 2+ messages in thread From: Darren Reed @ 2008-02-26 06:19 UTC (permalink / raw) To: pgsql-admin For whatever reason, I seem to be plagued with issues... Whether they're hardware or operating system or a bad combination....I'm not sure yet....and I find myself needing to recover from postgres not wanting to play all too often. In looking at the database data files, I notice that in (for example) a file called /data/db/base/10819/16397, are the contents for one of the relations. The data appears to be correctly stored with NULLs for field seperators, etc. On the assumption that the raw data itself is ok, how do I get that data out? Has anyone written a program to extract data directly from the database data files without using postgres? Are there any caveats in doing so? Darren ^ permalink raw reply [nested|flat] 2+ messages in thread
* Retrieving data from the data files. @ 2008-02-26 10:15 Darren Reed <darrenr+postgres@fastmail.net> 0 siblings, 0 replies; 2+ messages in thread From: Darren Reed @ 2008-02-26 10:15 UTC (permalink / raw) To: pgsql-admin For whatever reason, I seem to be plagued with issues... Whether they're hardware or operating system or a bad combination....I'm not sure yet....and I find myself needing to recover from postgres not wanting to play all too often. In looking at the database data files, I notice that in (for example) a file called /data/db/base/10819/16397, are the contents for one of the relations. The data appears to be correctly stored with NULLs for field seperators, etc. On the assumption that the raw data itself is ok, how do I get that data out? Has anyone written a program to extract data directly from the database data files without using postgres? Are there any caveats in doing so? Darren ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-26 10:15 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-02-26 06:19 Retrieving data from the data files. Darren Reed <darrenr@fastmail.net> 2008-02-26 10:15 Retrieving data from the data files. Darren Reed <darrenr+postgres@fastmail.net>
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