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

Re: Missing pg_clog files

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing pg_clog files
Date: 2008-09-24 18:09:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
To use the hex value 0x55, do I need to enclose it in single quotes?


On Sep 24, 2008, at 11:44 AM, Tom Lane wrote:

> Carol Walter <walterc(at)indiana(dot)edu> writes:
>> Are the files that contain the hex characters supposed to contain a
>> single string and no control characters?
> Yes, you want 256K occurrences of the byte value 0x55 and nothing  
> else.
>> I'm also wondering if, after I create the dummy files, and pg_dump
>> works, I could restore an old pg_dumpall file and then insert any
>> data that aren't there from the pg_dumps.
> It'd be a good idea to do as much cross-checking as you can, since
> it's highly probable that the dumped data will be at least partly  
> wrong.
> No, I'm afraid updating to 8.2.latest won't get you out of this.
> It might possibly prevent a recurrence.
> 			regards, tom lane
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-09-24 18:29:32
Subject: Re: Postgres client Configuration
Previous:From: Tom LaneDate: 2008-09-24 15:53:37
Subject: Re: Missing pg_clog files

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