Tom, There are no any space quota on user postgres. It always happens on different log files. When I am creating huge dummy file in same FS - nothing wrong.
P.S. I am getting same error when I am using pg_dump in tar format. I don't know if there is some relation between 2 issues. The reason of the pg_dump space failure is: when using tar format, pg_dump write temporary data into /var, which might be smaller than biggest table requires. The fix is simple in this case: to use custom format or increase /var. I actually don't know what PostgreSQL has to do in /var and if it is same problem? By the way it's impossible to understand where not enough space from pg_dump output as well as in my original issue. Sincerely yours, Yuri Levinsky, DBA Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222 -----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, June 25, 2013 4:47 PM To: Yuri Levinsky Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] Postgres crash? could not write to log file: No spaceleft on device "Yuri Levinsky" <yu...@celltick.com> writes: > I have the following issue on Sun Solaris 10. PostgreSQL version is > 9.2.3. The wall logging is minimal and no archiving. The DB restarted > several time, the box is up for last 23 days. The PostgreSQL > installation and files under /data/postgres that is half empty. Is it > some other destination that might cause the problem? Can I log the > space consumption and directory name where the problem is happening by > some debug level or trace setting? > PANIC: could not write to log file 81, segment 125 at offset > 13959168, length 1392640: No space left on device That's definitely telling you it got ENOSPC from a write in $PGDATA/pg_xlog. Maybe you have a user-specific space quota affecting the postgres account? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
