Thread: Need to repair Database

Need to repair Database

From

"Jurado, Hector R."

Date:

20 October 2006, 23:59:35

We use a program that uses GPG file extension, now when the application try to call the database it responds that the database is corrupt.

Which tool I could use to repair it? Normally I need to get old backup and all my new data is lost, the problem begin when some user close the program improperly.

Thanks

Hector

Re: Need to repair Database

From

Peter Eisentraut

Date:

21 October 2006, 09:14:10

Jurado, Hector R. wrote:
> We use a program that uses GPG file extension, now when the
> application try to call the database it responds that the database is
> corrupt. Which tool I could use to repair it?

With this amount of detailed information, we can't even guess.

> Normally I need to
> get old backup and all my new data is lost, the problem begin when
> some user close the program improperly.

Closing "the program" improperly would not cause database corruption.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/