From: | Casey Duncan <casey(at)pandora(dot)com> |
---|---|
To: | elein <elein(at)varlena(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Cannot restart postgres |
Date: | 2006-06-19 22:45:52 |
Message-ID: | BD39FC7C-E322-4A6D-9BC5-A99BACA28794@pandora.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Are there any other partitions on that machine with space available?
If so you could move some files there from your postgres data dir and
symlink to them from their original location. At least then you might
get it to start so you can get a pg_dump to work.
-Casey
On Jun 19, 2006, at 1:43 PM, elein wrote:
> 7.x installation. (Yeah, yeah, upgrade.)
>
> I have a disk which has only the database on it.
> It has become full and postgres won't start.
>
> Is there an option (besides restore from backup)
> other than trying to move the data dir to a bigger
> disk?
>
> Would pg_resetxlog do the right thing to free up
> some space so I can go in and vacuum and delete rows?
>
> This is somewhat urgent.
>
> Thanks for your help.
>
> --elein
> elein(at)varlena(dot)com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2006-06-19 22:54:00 | Re: Cannot restart postgres |
Previous Message | Florian G. Pflug | 2006-06-19 22:44:14 | Re: Adding foreign key constraints without integrity check? |