I need support for the
uuid library in my Postgres server (a 64-bit Amazon Linux AMI). I've installed the
uuid-pgsql packages. Is it possible to load the library without restarting the Postgres server?
PostgreSQL version is 8.4.11.
On 8.4.x you should be able to activate the extension once installed by simply loading the SQL file that came with it (the extensions are basically collections of C functions and other goodies - Postgres loads that stuff dynamically). The stack overflow question you linked to talks about how to go about this (it's discussed in the manual waaaaay in the back in Appendix F - "Additional Supplied Modules"
On 9.1 (I had the wrong version in my comment) and later this functionality has been subsumed by the