Skip site navigation (1) Skip section navigation (2)

Re: ran vacuum, ran out of space, cant bring up psql

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Pam Eggler" <peggler(at)hotmail(dot)com>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: ran vacuum, ran out of space, cant bring up psql
Date: 2005-02-03 17:14:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: sfpug

Welcome to SFPUG!  Are you in San Francisco, the East Bay, or what?

> I noticed I was running low on space on my system, so I found this vacuum
> command. I ran it and it failed because it ran out of space:
> vacuum mytable;
> FATAL 2:  ZeroFill failed to write
> /var/lib/pgsql/data/pg_xlog/xlogtemp.23895: No space left on device
> server closed the connection unexpectedly

> I cleared out that dir and then tried to go back into my database and I get
> this error:

Um, do you mean to say that you cleared out the XLOG directory!?!?  If so, I 
hope you have a backup ...

> psql fsp
> psql: could not connect to server: No such file or directory
> 	Is the server running locally and accepting
> 	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Well, the error you got is a "postgresql is shutting down" error.   So you'd 
need to restart.   But not if you're still out of disk space, and not if you 
just wiped the xlog directory.

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

sfpug by date

Next:From: William YuDate: 2005-02-03 19:31:42
Subject: Re: Arg! PG not using index on an analyzed table
Previous:From: Pam EgglerDate: 2005-02-03 15:04:48
Subject: ran vacuum, ran out of space, cant bring up psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group