Re: no space left on device

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.willan@deeperdesign.co.nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.