PostgreSQL Administration - Backup and clean up

Author

Backup and clean up

prabhakar V

2005-12-17, 3:23 am

Hi,

My disk partition /var is full due to growing of postgresql DB.

I am using postgres DB for more than six months. After taking the backup I
have to clean up all the DBs.(drop data only.This means table,DB structure
must be maintained).Because, my data partition size is more that 90% in
use. For ex.

/dev/sda6 4.3G 4.1G 105M 98% /var
Eventually, no one db,tables structure should not be altered and it should
run without any issues.Please advice me on this.

or else how can i move this DB to some other partition. For ex : /data2 if
this possible, Please help me out.

Thanks in Advance.

Prabhakar.

Jim C. Nasby

2005-12-19, 1:24 pm

On Tue, Dec 13, 2005 at 03:18:40PM +0530, prabhakar V wrote:
> or else how can i move this DB to some other partition. For ex : /data2 if
> this possible, Please help me out.

Use tablespaces. Though I think you can't alter a table's tablespace in
8.0...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links