Thread: No Space left on Device
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
"Jose" <javalis@sympatico.ca> writes: > 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. This error is not coming from Postgres: the string 'can not create object' does not appear anywhere in the PG source code. Nor does the format of the message match anything in Postgres -- we don't use error numbers. regards, tom lane
It has been my experience that the message indicates the partition that contains your PostgreSQL data is full. Try the "df -h" command to determine if this might be the case. 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 4: Don't 'kill -9' the postmaster > >. > > > -- John Burski @HOME S.I.M.U. (Well, sometimes I am :) ) ... and still searching for the cheese!