Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a very serious problem here in one of my client server. The remote server is installed with REDHAT ES 5.2 and we have a postgresql as database. I was trying to clone the database. The hard drive had 32 GB of free space before taking clone. I started cloning the database and during the process, there was some internet issue and due to this, putty got disconnected before taking clone. So I opened another fresh session and I was able to see only 2.5GB as available space. Also I was not able to see the clone in the psql terminal. Any solution to get the 29GB that was consumed????

share|improve this question
    
How were you trying to clone the database? With pg_dump? –  Dan Andreatta Mar 25 '10 at 18:44
    
How large was the database you were trying to clone? Presumably, there is a temp file that it was using for the clone and you just need to clean that up, but I'm not a postgresql expert. Good luck! –  Jed Daniels Mar 25 '10 at 18:57
    
@ Dan: I am using psql terminal to clone.. I have figured out the folder under the directory basd on the modified date. /usr/local/pgsql/data/base/XXXX If I delete the folder, will it affect the current database? –  Anonymous Mar 26 '10 at 14:39
add comment

1 Answer

You need to find the file in question. Try the following:

find /path -type f -ctime -1 -size +25G -size -32G -print

That will find files under /path, created in the last day, over 25 GB and under 32 GB in size.

share|improve this answer
    
If this doesn't work it's possible that several smaller files are causing your problem. In which case remove the -size... options and look the data over by hand. –  Chris Nava Mar 25 '10 at 20:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.