This resource manages PostgreSQL extensions for a given database
:create- Creates an extension in a given database
:drop- Drops an extension from the database
:delete- Alias for
|The name of the extension to be installed
|The name of the schema in which to install the extension objects
|old_version must be specified when, and only when, you are attempting to install an extension that replaces an "old style" module that is just a collection of objects not packaged into an extension.
|The version of the extension to install
|Automatically install any extensions that this extension depends on that are not already installed
|This option prevents the specified extensions from being dropped if other objects, besides these extensions, their members, and their explicitly dependent routines, depend on them
To install the
# Add the contrib package in Ubuntu/Debian
# Install adminpack extension
postgresql_extension 'postgres adminpack' do
Was this helpful?