Search Postgresql Archives

Re: Cannot restart postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux