[BUGS] Postgres crash? could not write to log file: No space left on device

2013-06-25 Thread Yuri Levinsky
Dear All, 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 destinat

Re: [BUGS] Postgres crash? could not write to log file: No spaceleft on device

2013-06-25 Thread Yuri Levinsky
me 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:

Re: [BUGS] Postgres crash? could not write to log file: No spaceleft on device

2013-06-25 Thread Yuri Levinsky
;t see any destination that isn't /data/postgres. Have I perform any specific setting to limit it into /data/postgres? Sincerely yours, Yuri Levinsky, DBA Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel Mobile: +972 54 6107703, Office: +972 9 9710239; Fax:

Re: [BUGS] Postgres crash? could not write to log file: No spaceleft on device

2013-06-26 Thread Yuri Levinsky
oots for 2 days. I disabled pg_dump with tar option, that somehow filled up by 100% the /var directory and freed it after failure. I limited the temp storage per session as well. Unfortunately I lost the connection to the site and unable to check today if it helped or not. Sincerely yours, Yuri

Re: [BUGS] Postgres crash? could not write to log file: No spaceleft on device

2013-07-02 Thread Yuri Levinsky
04:18:55 GMT0LOG: WAL writer process (PID 2296) was terminated by signal 6 2013-07-02 04:18:55 GMT0LOG: terminating any other active server processes 2013-07-02 04:18:55 GMT57P03FATAL: the database system is in recovery mode Sincerely yours, Yuri Levinsky, DBA Celltick Technologies Ltd.