On 3/23/07, Mark <sendmailtomark@xxxxxxxxx> wrote:
I would like to use postgresql with knopixx, Sounds like a simple idea :-) and I would like to get full version of postgresql stored on flash drive. I remeber I've seen postgresql tar files before, but do not recall the location - can anybody point? Also, how big (in MB) postgresql takes after install? If there is any better way to have postgresql installed on usb drive and have it executebale from lnopixx - please let me know
postgresql is quite small for full installation, maybe 30mb or less (on mine is 25mb for /usr/local/pgsql). for extreme situations you may want to explore .exe compression. I would suggest compile from source because then you can omit ssl which you probably don't need, etc, and contrib, etc. maybe instead of knoppix you can consider distro optmized for thumb: http://flashlinux.org.uk/. I disagree with others, postgresql on flash drive will not necessarily suck, although it will eventually wear out a flash device presumably...<2.0 usb will be painful however. Ideally you can mount disk storage from the computer. It is fun experiment at the very least. good luck! merlin
