pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Retrievig text information from damaged DataBase
2+ messages / 2 participants
[nested] [flat]

* Retrievig text information from damaged DataBase
@ 2008-04-05 08:59  veejar <veejar.net@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: veejar @ 2008-04-05 08:59 UTC (permalink / raw)
  To: pgsql-admin

Hello!

My PostgreSQL DB was damaged, some files were removed and now I have such loss:

global/pg_auth
global/pg_database
global/pgstat.stat

fast all files in folder "pg_clog"

pg_subtrans/527E

all files in folder "pg_xlog"

And some small files in folder of my database.

Is it possible corrent database structure files and start pgsql server
or retrieve text information from database?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Retrievig text information from damaged DataBase
@ 2008-04-05 13:01  Alvaro Herrera <alvherre@commandprompt.com>
  parent: veejar <veejar.net@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2008-04-05 13:01 UTC (permalink / raw)
  To: veejar <veejar.net@gmail.com>; +Cc: pgsql-admin

veejar escribió:

> Is it possible corrent database structure files and start pgsql server
> or retrieve text information from database?

Pretty unlikely.  You can try using pg_filedump to get at the raw data:
http://sources.redhat.com/rhdb

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-04-05 13:01 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-05 08:59 Retrievig text information from damaged DataBase veejar <veejar.net@gmail.com>
2008-04-05 13:01 ` Alvaro Herrera <alvherre@commandprompt.com>

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