Re: BUG #5612: Database Integrity - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #5612: Database Integrity
Date
Msg-id 1281548220-sup-3350@alvh.no-ip.org
Whole thread Raw
In response to BUG #5612: Database Integrity  ("Ramachandran S" <nic.srama@gmail.com>)
List pgsql-bugs
Excerpts from Ramachandran S's message of mié ago 11 05:36:31 -0400 2010:

> I have observed that if a table exceeds size (default installation) 1 GB.
> The table when it exceeds 1 GB a file is created say 1811(table) with 1811.1
> and further records added are insertted into this file.  My Question if I
> remove the file 1811.1 say still database is starting up?

You're not supposed to mess with the underlying files.  If you randomly
delete files, it's your problem.

No, we don't have pgfsck.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Brian Ceccarelli
Date:
Subject: Re: BUG #5611: SQL Function STABLE promoting to VOLATILE
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5607: memmory leak in ecpg