Search Postgresql Archives

Re: GUID for postgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dann Corbit wrote:
There is a "privacy hole" from using the MAC address.  (Read it in the
WIKI article someone else posted).

Probably, it would be better to use a one way hash of the MAC address.


The chances of MAC addresses colliding (through some low-end network
card vendor's sloppy manufacturing process; or through the not
uncommon ability to edit your mac address) is surely much higher than
the chance of big random numbers colliding.   Sure, you won't hurt
anything if you add the MAC address to your entropy sources when
generating a GUID; but thinking a MAC address is more unique than
the bits you'd get from any less human-error-prone source is
almost certainly wrong.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux