Re: no space left on device

From: Kenneth Godee <Ken(at)perfect-image(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: javalis(at)sympatico(dot)ca
Subject: Re: no space left on device
Date: 2003-01-03 04:18:25
Message-ID: 20030102211825.4174313a.Ken@perfect-image.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just a thought, check your "inodes" as well...
"df -i"
You can have lots of space left, but can be out of inodes.

> Hi Jose,
>
> Double check that by making sure that all your linux partitions have
> free disk.
>
> df is the command to use.
>
> Cheers,
> Hadley
>
>
> On Wed, 2003-01-01 at 06:28, Jose wrote:
> > Hi there, I'm Jose From Canada,
> >
> > I'm working with PostgreSQL 7.2 on Linux Red hat 7.3 and when I try to
> > create an object in the database, using PGAdmin or psql, I get this error.
> >
> > create index pp_key on pp (p1) ;
> >
> > Error: -2147467259 can not create object : no space left on device.
> >
> >
> > But if I check the available space on disk from linux I have a lot, more
> > than 4 GB and the table pp is empty.
> >
> >
> > Any clues ??? what should I check ???
> >
> > Thanks in advance
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> --
> Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
> hadley(dot)willan(at)deeperdesign(dot)co(dot)nz > www.deeperdesign.com > +64(21)-28-41-463
> Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-01-03 04:47:05 Re: [GENERAL] 7.3 Prepared statements
Previous Message Charles H. Woloszynski 2003-01-03 04:18:02 Re: 7.3 Prepared statements