# Postgres plv8 on Trusty

**URL:** <https://discuss.circleci.com/t/postgres-plv8-on-trusty/5335>\
**Category:** Databases\
**Tags:** postgresql, trusty\
**Created:** [July 26, 2016, 9:48pm UTC](https://discuss.circleci.com/t/postgres-plv8-on-trusty/5335 "2016-07-26T21:48:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![iamtheschmitzer](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/iamtheschmitzer/32/13556_2.png) [@iamtheschmitzer](https://discuss.circleci.com/u/iamtheschmitzer)\
**Post date:** [July 26, 2016, 9:48pm UTC](https://discuss.circleci.com/t/postgres-plv8-on-trusty/5335/1 "2016-07-26T21:48:29Z")

</div>

Trying to move from Precise to Trusty, but I get an error adding the PLV8 extension:

```
PG::UndefinedFile: ERROR: could not open extension control file "/usr/share/postgresql/9.5/extension/plv8.control": No such file or directory

```

when I try to run:

```
CREATE EXTENSION IF NOT EXISTS plv8;

```

Is there a way to add this for my build?

---

<div class="post-metadata">

**Author:** ![drazisil](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/drazisil/32/24029_2.png) [@drazisil](https://discuss.circleci.com/u/drazisil)\
**Post date:** [July 26, 2016, 10:03pm UTC](https://discuss.circleci.com/t/postgres-plv8-on-trusty/5335/2 "2016-07-26T22:03:23Z")

</div>

The highest version that currently exists in the Ubuntu package repository is [9.3](http://packages.ubuntu.com/trusty/database/postgresql-9.3-plv8), so you would either need to downgrade Postgres, or build plv8 following the instructions at [https://github.com/plv8/plv8#install](https://github.com/plv8/plv8#install)

---

<div class="post-metadata">

**Author:** ![iamtheschmitzer](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/iamtheschmitzer/32/13556_2.png) [@iamtheschmitzer](https://discuss.circleci.com/u/iamtheschmitzer)\
**Post date:** [July 26, 2016, 10:24pm UTC](https://discuss.circleci.com/t/postgres-plv8-on-trusty/5335/3 "2016-07-26T22:24:09Z")

</div>

Thanks but I’m confused since Precise had plv8 support. I guess circle built it then?

---

<div class="post-metadata">

**Author:** ![drazisil](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/drazisil/32/24029_2.png) [@drazisil](https://discuss.circleci.com/u/drazisil)\
**Post date:** [July 21, 2017, 6:22pm UTC](https://discuss.circleci.com/t/postgres-plv8-on-trusty/5335/4 "2017-07-21T18:22:06Z")

</div>

Closed on July 21, 2017, 6:22pm UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.