On Tue, Aug 03, 2010 at 11:54:56AM +0530, Neetin Kumar wrote:

> I am new to postgres My database actual size is 2 GB after replication 
> its become 47 GB i tried to run VACUUM but i am not able to do so 
> because getting error :No space left on disk.

You need more disk.  You can solve this by shutting postgres down,
moving some of the files to another filesystem, and symlinking them
back into their previous location.  Also, look for log files
(human-readable log files) or something else that you can safely cut
down to get yourself more room.

> Can I remove pg_xlog files its size become 2.4 GB.

No, lordy, no.  That's the transaction log.  If you remove it you will
destroy the database.

A big question is how your database got so big.  Are you quite sure
you're not getting a lot of errors (which leave dead tuples around)?

A
-- 
Andrew Sullivan
ajs at crankycanuck.ca