From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: portable version for Usb Pen |
Date: | 2014-04-24 19:17:11 |
Message-ID: | 53596337.8010808@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Burgess, Freddie | 2014-04-24 20:08:37 | Pgpool Setup inquiry - Configuration concerns |
Previous Message | Sergey Konoplev | 2014-04-24 18:57:50 | Re: WAL archiving from a standby backup strategy Postgresql 9.3 |