Also check if the user which postgresql is running as has permissions/quota
to write.
If that sort of stuff is fine, then maybe it's a bug - since you have 4GB left.
Try filling up 2GB+ of that 4GB free, then try again. If it now works then
you've found a bug somewhere, whether in Postgresql or elsewhere.
Good luck,
Link.
At 09:18 PM 1/2/03 -0700, Kenneth Godee wrote:
>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.willan@deeperdesign.co.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@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly