Re: no space left on device

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
>