We've got a product built on FreeBSD and PostgreSQL 7.4.2 that I've had to fit onto an installable CDROM tradeshows and customer demos. This is the only way I've found to ensure an easy to re-install option for the non-technical folks at the tradeshows should they corrupt the box itself. This part all works fine.
However, I've only got 700mb to work with and the bootable CDROM takes a chunk of that as does the rest of our app.
Doing a pg_dumpall of the database results in a 369Kb file.
However, $PGDATA is around 60mb.
root@tradeshow:/local/pgsql/data% du -hcs base/* pg_xlog/* 4.4M base/1 4.4M base/17141 4.4M base/17144 4.4M base/17145 6.6M base/17146 5.4M base/17147 16M pg_xlog/0000000000000006 16M pg_xlog/0000000000000007 62M total
My question is what's the best way to trim that down? I realize I could remove it completely and have my install script do an initdb, etc, but if there's anyway to keep the installation intact to begin with I'd prefer that.
Is there any other way to trim the size of those files? Maybe dump everything out, "clean up", then restore it. Then immediately burn things to CD? Or if there are postgresql.conf options I can set to not keep WAL logs, etc around that would work too since this is just for tradeshows...
Thanks all!
-philip
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
