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

Yes

yum install postgresql10-contrib resolved the error for the import.

2018-06-12 16:56 GMT+02:00 Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>:

> 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/post
>> gres.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
>>
>
>

--
Cordialement,

*Pierre Ochsenbein*
Mobile: +33668295394
pierreochsenbein(at)gmail(dot)com