Thank you both. Yes I was helping others when you two are
helping me:) I appreciate your time and help very much.
We rebooted server and recovered the disk space. Also doing
vacuum routinely. So far so good. Thanks again.
Rocky
From: Andy Shellam [mailto:andy@xxxxxxxxxx] Sent: Monday, May 22, 2006 12:57 PM To: Jim C. Nasby Cc: pgsql-admin@xxxxxxxxxxxxxx; Xu, Xiaoyi (Rocky) FSM Subject: Re: [ADMIN] Error in Access This exact e-mail was also raised a few weeks ago! I advised Rocky to check the host server, and as it turned out, it's PG data partition was 100% full! I believe Rocky was covering for a system admin temporarily, hence the fact it wasn't picked up sooner. I don't know what happened since - whether he got it sorted. Regards Andy Jim C. Nasby wrote: On Mon, May 15, 2006 at 10:09:25AM -0500, Xu, Xiaoyi (Rocky) FSM wrote:Hi, My database users are getting following error: ODBC-call failed Error while executing query Error: ItsWriteBlock: failed to write block 1 of temporary file Perhaps out of disk space (#1) This happens in Access. Could anyone shed some light on this? Thank you.Does the command work if you run it from psql? |