| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | gue(at)datecs(dot)kiev(dot)ua |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: HELP!!! Corrupt Database! |
| Date: | 2005-06-21 08:14:56 |
| Message-ID: | 42B7CC80.80205@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yuri Gordienko wrote:
> Hi,
>
> The computer with database has lost power and after restarting I can't
> connect to database:
>
> connection to database "db_client" failed: FATAL: invalid memory alloc
> request size 4294901760
>
> version:
> postgresql-7.4.6
>
> Help me with this problem. I don't have reserve copy of database :(
And now you know why you're supposed to have a backup :-(
The bad news is it sounds like your database may be corrupted. The good
news is it might be possible to recover most of it.
1. Stop the database
2. Take a complete file-level backup of *all* the files in your
PostgreSQL data directory - data, postgresql.conf, xlog stuff etc.
3. Try to start the database and see what you get in the logs. Post the
log errors here.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-06-21 08:16:15 | Re: Scripting issues |
| Previous Message | Ilja Golshtein | 2005-06-21 08:12:24 | Re: failed to find conversion function from "unknown" to ... |