Re: no space left on device

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Kenneth Godee <Ken(at)perfect-image(dot)com>, pgsql-general(at)postgresql(dot)org
Cc: javalis(at)sympatico(dot)ca
Subject: Re: no space left on device
Date: 2003-01-03 08:20:38
Message-ID: 5.1.0.14.1.20030103161709.0279c2f0@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(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
> >
>
>---------------------------(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

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2003-01-03 08:24:31 Re: 7.3 Prepared statements
Previous Message Christoph Dalitz 2003-01-03 08:18:30 Re: Aggregate working on ordered data