Re: [GENERAL] Cannot restart postgres

2006-06-19 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > 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? I'd tr

Re: [GENERAL] Cannot restart postgres

2006-06-19 Thread Scott Marlowe
On Mon, 2006-06-19 at 17:45, Casey Duncan wrote: > 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

Re: [GENERAL] Cannot restart postgres

2006-06-19 Thread Casey Duncan
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

[GENERAL] Cannot restart postgres

2006-06-19 Thread elein
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 so