Thread: BUG #5612: Database Integrity
The following bug has been logged online: Bug reference: 5612 Logged by: Ramachandran S Email address: nic.srama@gmail.com PostgreSQL version: 8.4 Operating system: Ubuntu Description: Database Integrity Details: 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? I will never know that such a file existed nad remved and data of 1811 is also availble? How can stop the start the database when such situation recur. pgfsck was available 8.2
"Ramachandran S" <nic.srama@gmail.com> wrote: > 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? I will never know that such a > file existed nad remved and data of 1811 is also availble? > How can stop the start the database when such situation recur. > pgfsck was available 8.2 I don't see any hint of a PostgreSQL bug here. Since there's not really enough in your post to get very far, please re-post to a more appropriate list. pgsql-general is probably your best bet. I'm not entirely clear on whether you are asking a hypothetical question or whether your database cluster is currently out of commission because you mangled the underlying files. If you're trying to recover from such damage, please post actual details. See this page for suggestions on what to include: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems If this is all hypothetical, my advice is to review the backup documentation and always keep up-to-date backups, and never delete files in the manner you describe. -Kevin
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