Skip site navigation (1) Skip section navigation (2)

Re: URGENT: Database Recovery

From: mike g <mike(at)thegodshalls(dot)com>
To: Felipe Santiago <fpasantiago(at)hotmail(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: URGENT: Database Recovery
Date: 2004-07-02 04:14:45
Message-ID: 1088741685.23457.36.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-cygwin
The check free disk space message sounds would indicate your hard drive
is full.  Perhaps a core dump happened that is hogging your disk space?

Anyway try freeing up some disk space.  You can search the list, I would
recommend pgsql-general instead, but I believe improvements were made in
7.4 over 7.3 in how postgresql reacts when it runs out of disk space.

Mike
On Wed, 2004-06-30 at 09:16, Felipe Santiago wrote:
>      Hi All,
> 
>          I have a database on PostgreSQL 7.3, running on Windows 98 with 
> cygwin. In this morning, when the server was starting up, I got the 
> following messages:
> ------------------------------------------------
> LOG:  database system was interrupted being in recovery at 2004-06-30 
> 10:19:19 H
> AS
>         This probably means that some data blocks are corrupted
>         and you will have to use the last backup for recovery.
> LOG:  checkpoint record is at 0/3BD9CE60
> LOG:  redo record is at 0/3BD9CE60; undo record is at 0/0; shutdown FALSE
> LOG:  next transaction id: 24790; next oid: 1646921
> LOG:  database system was not properly shut down; automatic recovery in 
> progress
> 
> LOG:  redo starts at 0/3BD9CEA0
> PANIC:  cannot extend 16404: Permission denied.
>         Check free disk space.
> LOG:  startup process (pid 1209913) was terminated by signal 6
> LOG:  aborting startup due to startup process failure
> -------------------------------
> At this point Im downloading a new version of postgres. The database 
> administrator does not have the history os backups. Has anyone any tip how 
> to recover my data?
> 
> 
>    Regards
>     Felipe
> 
> _________________________________________________________________
> MSN Hotmail, o maior webmail do Brasil.  http://www.hotmail.com
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

In response to

pgsql-cygwin by date

Next:From: mike gDate: 2004-07-02 04:24:00
Subject: Re: Postgresql(ODBC do not works??)
Previous:From: mike gDate: 2004-07-02 03:54:19
Subject: Re: SIGNAL 12 on initDB command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group