Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error accessing PostgreSQL

Error accessing PostgreSQL

From
Ricardo Maia
Date:
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

Re: Error accessing PostgreSQL

From
Tom Lane
Date:
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

Re: Error accessing PostgreSQL

From
Ricardo Maia
Date:
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