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
Hi all
Someone on SO has UPDATEd away some data they cared about. I've written
a bit on what they might want to do, but really don't know enough, so I
was hoping for some aid/ideas. In particular, is the advice to use "
pg_ctl stop -m immediate" (to hopefully avoid a checkpoint) appropriate
a
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
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 a little vague, but I'm not really sure what
information would be pertinent..
Any he
Hallo. This is the log. This is postgresql 7.4.0.
The problem appeared after few hang-ups because of phisical memory
problem. Is there any way to recover the data?
2004-01-07 21:18:05 LOG: statistics collector process (PID 886) exited
with exit code 1
2004-01-05 15:12:23 LOG: could not create IP
I was running version 6.4.2 when I lost all the binaries. I still
have all the data/* and data/base/* files.
The port for FreeBSD is 6.5.3. I have it installed, now. The disk
file formats changed between version 6.4.2 and 6.5.3.
Is there a tool or mechanism to translate these files into a for
13 matches
Mail list logo
