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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
