Обсуждение: Error accessing PostgreSQL
When I am trying to connect to PostgreSQL e get the following error: ERROR: pg_attribute_attrelid_index: cannot extend. Check free disk space. I should have about 98 MB of free disk space in PostgreSQL database file system. Is there any way to check if there is a minimum amount of free space that must be available ? Could it be other problem than disk space? Ricardo Maia
Ricardo Maia <rmaia@criticalsoftware.com> writes:
> When I am trying to connect to PostgreSQL e get the following error:
> ERROR: pg_attribute_attrelid_index: cannot extend. Check free disk space.
While you're trying to *connect*? That's hard to believe. I would think
only table creation or addition of a column would cause an attempt to
add an entry to pg_attribute_attrelid_index.
> Could it be other problem than disk space?
Hard to tell. Try updating to a more recent version of Postgres --- in
recent releases (7.0.3 and up), this message includes the specific
kernel error code that's being returned by write().
regards, tom lane
On Friday 13 July 2001 19:53, Tom Lane wrote: > Ricardo Maia <rmaia@criticalsoftware.com> writes: > > When I am trying to connect to PostgreSQL e get the following error: > > > > ERROR: pg_attribute_attrelid_index: cannot extend. Check free disk > > space. > > While you're trying to *connect*? That's hard to believe. I would think > only table creation or addition of a column would cause an attempt to > add an entry to pg_attribute_attrelid_index. Yes you are rigth. It's after connecting when I am creating a sequence. I should have been more precise. Thanks! Ricardo Maia > > > Could it be other problem than disk space? > > Hard to tell. Try updating to a more recent version of Postgres --- in > recent releases (7.0.3 and up), this message includes the specific > kernel error code that's being returned by write(). > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster