| From: | Lynn(dot)Tilby(at)asu(dot)edu |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Cc: | ltilby(at)asu(dot)edu |
| Subject: | DB & Log Files removed... |
| Date: | 2003-12-18 23:34:47 |
| Message-ID: | 1071790487.3fe23997ee866@webmail.asu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am running an experimental system, my disk filled up when running a
table build from a query. I mistakenly blew away the files in
../pgsql/data/base/18773 & ../pgsql/data/pg_xlog with NO BU!
Recover is only bringing back 8 of about 90 files.
I can rebuild the DB from scratch relatively easily...
I was going to try and just do a drop database but I get this when
trying to bring up the postmaster.
[postgres(at)polaris pgsql]$ postmaster
DEBUG: database system shutdown was interrupted at 2003-12-17 12:32:40 MST
DEBUG: open(logfile 6 seg 134) failed: No such file or directory
DEBUG: Invalid primary checkPoint record
DEBUG: open(logfile 6 seg 134) failed: No such file or directory
DEBUG: Invalid secondary checkPoint record
FATAL 2: Unable to locate a valid CheckPoint record
postmaster: Startup proc 18179 exited with status 512 - abort
Where is the postmaster getting the 'logfile 6 seg 134' from? Are there
any files I can edit to solve this problem, or perhaps something else
I can do?
I am running RH 6.2 with pgsql 7.1.3 I thought of just reinstalling 7.1.3
for the time being but I only see 7.1.3 for RH 7.1 available on the
download site. If I am unable to just rebuild the DB is there an archive
somewhere that I can download 7.1.3 for RH6.2 from or... would I be OK
with the RH7.1 version on an RH6.2 box? My gut feel is that this would
not work. (... i know... it's time to upgrade)
Thanks,
Lynn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2003-12-18 23:42:00 | Re: Firebird and PostgreSQL at the DB Corral. |
| Previous Message | Josué Maldonado | 2003-12-18 23:34:44 | Re: Select groupping by one column |