Re: pg_restore failed with the extension uuid-ossp.control

Hi Pierre,

It looks like the uuid-ossp extension is not installed.You have to install
the uuid-ossp extension manually and create extension before going for
restoration operation.

Hope this helps..

<http://www.shreeyansh.com>

On Tue, Jun 12, 2018 at 8:08 PM, Pierre Ochsenbein <
pierreochsenbein(at)gmail(dot)com> wrote:

> Hi all,
>
> How to install the package in my PostgreSQL10 ?
>
> This is the error I receive:
> 16:35 -bash-4.2$ pg_restore -d postgres /var/lib/pgsql/pgsql_dump/
> postgres.custom
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 2; 3079 61247 EXTENSION
> uuid-ossp
> pg_restore: [archiver (db)] could not execute query: ERROR: could not
> open extension control file "/usr/pgsql-10/share/extension/
> *uuid-ossp.control*": No such file or directory
> Command was: CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA
> public;
> pg_restore: [archiver (db)] Error from TOC entry 76585; 0 0 COMMENT
> EXTENSION "uuid-ossp"
> pg_restore: [archiver (db)] could not execute query: ERROR: extension
> "uuid-ossp" does not exist
> Command was: COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally
> unique identifiers (UUIDs)';
>
>
> Thanks for your help.
>
> Regards
>