Postgresql 9.1 install uuid-ossp

Note that UUIDs of this kind reveal the identity of the computer that created the identifier and the time at which it did so, which might make it unsuitable for certain security-sensitive applications. This function generates a version 3 UUID in the given namespace using the specified input name.

It could be any UUID in theory. The name is an identifier in the selected namespace. The generation of UUIDs by this method has no random or environment-dependent element and is therefore reproducible. This pertains to ASN. On Linux, macOS, and some other platforms, suitable functions are provided in the libuuid library, which originally came from the e2fsprogs project though on modern Linux it is considered part of util-linux-ng.

More than one of these libraries might be available on a particular machine, so configure does not automatically choose one. This module is only necessary for special requirements beyond what is available in core PostgreSQL.

See Section 9. Table F. There is no version 2 algorithm. Each of these algorithms could be suitable for a different set of applications.

Generates a version 1 UUID. This involves the MAC address of the computer and a time stamp. Note that UUIDs of this kind reveal the identity of the computer that created the identifier and the time at which it did so, which might make it unsuitable for certain security-sensitive applications.

I was trying to install citext, but google was not finding this page, and this answer did not come up. Now citext is mentioned three times on this page :- Come on google, do that indexing thing. Note that the package is also needed to add vacuumlo script in pgsql bin. For the postgrersql10 I have solved it with yum install postgresqlcontrib Don't forget to activate extensions in postgresql. Marios Simou Marios Simou 2 2 silver badges 7 7 bronze badges.

Leave off the quotes. This works: create extension intarray; This does not : create extension 'intarray'; — David J. That's for pre 9. Do not use this method in 9. I did not have to restart. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta.