X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3C5A89DC803 for ; Tue, 13 Dec 2005 05:48:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72627-06 for ; Tue, 13 Dec 2005 05:48:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.200]) by postgresql.org (Postfix) with ESMTP id 31BF09DC812 for ; Tue, 13 Dec 2005 05:48:37 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so1210389wxc for ; Tue, 13 Dec 2005 01:48:40 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=fDbHcu6ohcUJ/pALoThOXQmmmlebeH5kyA0c0qSXuqquZTHoWlDHjDHcmeJNtFcCpVMzTcSTvyjMLJ4nfYyKo1SWjVwDUzfKQcFHy5NHmmJR5p05+ABwDBUyhGZtW1Rr4ZLwZAMJlw9F4Uo/VMvwHb9Rdn0ReLw6Tg+KxwlF2IE= Received: by 10.70.21.13 with SMTP id 13mr312119wxu; Tue, 13 Dec 2005 01:48:40 -0800 (PST) Received: by 10.70.30.3 with HTTP; Tue, 13 Dec 2005 01:48:40 -0800 (PST) Message-ID: <956e047a0512130148t4ae10446n8118f4e115cdf40b@mail.gmail.com> Date: Tue, 13 Dec 2005 15:18:40 +0530 From: prabhakar V To: pgsql-admin@postgresql.org Subject: Backup and clean up MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_38569_8154435.1134467320167" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/174 X-Sequence-Number: 19894 ------=_Part_38569_8154435.1134467320167 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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. ------=_Part_38569_8154435.1134467320167 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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 back= up I have to clean up all the DBs.(drop data only.This means table,DB struc= ture 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.Pleas= e advice me on this.
 
 
or else how can i move this DB to some other partition. For ex : /data= 2  if this possible, Please help me out.
 
Thanks in Advance.
 
Prabhakar.
------=_Part_38569_8154435.1134467320167--