Installing uuid-ossp on 9.2. ‹Previous Topic Next Topic›. I'm having problems installing the uuid-ossp extension on 9.2, running on Ubuntu. Is Postgres just not finding it? Do I need to make a symlink to it somewhere? On Sat, Sep 29, 2012 at 5:12 PM, Mike Christensen < [hidden email] > wrote
OpenVAS is a full-featured vulnerability scanner. Its capabilities include unauthenticated testing, authenticated testing, various high level and low level Internet and industrial protocols, performance tuning for large-scale scans and a powerful internal programming language to implement any type of vulnerability test.
The extension uuid-ossp is distributed with most newer versions of PostgreSQL. To confirm your PostgreSQL installation includes the extension, check for the uuid-ossp files in the Assuming the extension is installed, simply run the following SQL statement against your target database
select uuid_generate_v1(); For more info on which version of the algorithm you should use refer to the documentation. Postgres UUID OSSP Documentation.
create extension "uuid-ossp"; To test that it's working . select uuid_generate_v1(); For more info on which version of the algorithm you should use refer to the documentation. Postgres UUID OSSP Documentation
postgres install uuid ossp, Postgres has support for universally unique identifiers (UUIDs) as a column data type via uuid. If you have a UUID column, you may need to generate a UUID. This requires the uuid-ossp module.