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
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:
;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:
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
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.