Re: portable version for Usb Pen

On 4/24/2014 5:33 AM, Oscar Calderon wrote:
> First of all, you have to format your USB as NTFS instead FAT or FAT32
> because NTFS has some features needed by PostgreSQL according to this
> link:

and now you have a HUGE problem.    the postgres server has to run as a
dedicated user, and that user will have a different UUID on each system
you plug this portable stick into.  oh, and as a non-administrator, you
can't create said user.

anyways, the whole idea is bad.   postgres does a LOT of 8k block random
writes.  USB flash memory absolutely HATES random writes, and will burn
itself out in short order, meanwhile running at molasses slow speeds.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast