Check this post on depesz.com:
http://www.depesz.com/2012/04/04/lets-talk-dirty/
2012/9/18 Craig Ringer
> Also, are there any functions to read raw tuple bytes to `RECORD's? I
> couldn't find any in `pageinspect', `pgstattuple', `adminpack', etc. Am I
> right in guessing that they're pretty much
On Wed, 16 Mar 2005 16:05:16 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> Ok - I found the log messages:
>
> ERROR: duplicate key violates unique constraint "features_pkey"
> STATEMENT: insert into features
> (propid,dtmodified,proptype,groupid,featid,group_desc,feat_desc)
> values (449356005
This is the message I get when I try to start the database:
LOG: database system was interrupted while in recovery at 2005-03-16
16:07:58 EST
HINT: This probably means that some data is corrupted and you will
have to use the last backup for recovery.
LOG: checkpoint record is at 2B/553CED30
LOG
Ok - I found the log messages:
ERROR: duplicate key violates unique constraint "features_pkey"
STATEMENT: insert into features
(propid,dtmodified,proptype,groupid,featid,group_desc,feat_desc)
values (449356005,'3/9/2005 12:03:59 AM',1,26,1,'Water','PublicWater')
PANIC: right sibling's left-link
On Wed, 16 Mar 2005 16:02:58 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> Fsync was off - we are using XFS and the Microcontroller on the RAID
> card Crashed and took two filesystems offline at about 2 a.m.
Did you run xfs_repair afterwards?
> There were some error messages in the postgres log
Fsync was off - we are using XFS and the Microcontroller on the RAID
card Crashed and took two filesystems offline at about 2 a.m.
There were some error messages in the postgres log, something like
Update failed - right part of branch is wrong (I'm guessing - I'm
trying to find the exact error - b
On Wed, 16 Mar 2005 15:46:16 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> It's postgresl 8.01 on AMD 64 Suse 9.2. The database didn't dump
> succesfully for several days in a row so the backup is corrupted also.
>
> The controller card crashed and we think caused data corruption. I
> rebooted
It's postgresl 8.01 on AMD 64 Suse 9.2. The database didn't dump
succesfully for several days in a row so the backup is corrupted also.
The controller card crashed and we think caused data corruption. I
rebooted the system the following day, and it came back up, but all
was not well, pg_dump all
On Wed, 16 Mar 2005 14:43:09 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> I have a crashed database fileset, and I'm wondering if there is any
> way to recover the data from a specific table. I know which table got
> corrupted, and it's not the table I am trying to recover.
>
> I know this is
