# Postgres insufficient privilege

**URL:** <https://discuss.circleci.com/t/postgres-insufficient-privilege/4782>\
**Category:** Databases\
**Tags:** postgresql\
**Created:** [June 23, 2016, 7:16pm UTC](https://discuss.circleci.com/t/postgres-insufficient-privilege/4782 "2016-06-23T19:16:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![garrettqmartin8](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/garrettqmartin8/32/13339_2.png) [@garrettqmartin8](https://discuss.circleci.com/u/garrettqmartin8)\
**Post date:** [June 23, 2016, 7:16pm UTC](https://discuss.circleci.com/t/postgres-insufficient-privilege/4782/1 "2016-06-23T19:16:08Z")

</div>

My tests pass locally, but on Circle they fail with this error:

`ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: could not open file.`

My tests write files to the “/tmp” directory.

circle.yml

```auto
database:
  override:
    - bin/setup
test:
  override:
    - COVERAGE=true bin/rake

```

---

<div class="post-metadata">

**Author:** ![levlaz](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/levlaz/32/36978_2.png) [@levlaz](https://discuss.circleci.com/u/levlaz)\
**Post date:** [June 25, 2016, 1:23am UTC](https://discuss.circleci.com/t/postgres-insufficient-privilege/4782/2 "2016-06-25T01:23:27Z")

</div>

> [@garrettqmartin8](#):
>
> ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR: could not open file.

Can you share the part of your code that causes this error?

---

<div class="post-metadata">

**Author:** ![garrettqmartin8](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/garrettqmartin8/32/13339_2.png) [@garrettqmartin8](https://discuss.circleci.com/u/garrettqmartin8)\
**Post date:** [June 27, 2016, 2:28pm UTC](https://discuss.circleci.com/t/postgres-insufficient-privilege/4782/3 "2016-06-27T14:28:14Z")

</div>

I can only post one link apparently, but here are the tests:  
[https://github.com/SturdyCo/aact2/blob/csv/spec/models/](https://github.com/SturdyCo/aact2/blob/csv/spec/models/) table\_exporter\_spec.rb

The code it’s running is in the TableExporter model in the same repo.

---

<div class="post-metadata">

**Author:** ![garrettqmartin8](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/garrettqmartin8/32/13339_2.png) [@garrettqmartin8](https://discuss.circleci.com/u/garrettqmartin8)\
**Post date:** [June 27, 2016, 2:51pm UTC](https://discuss.circleci.com/t/postgres-insufficient-privilege/4782/4 "2016-06-27T14:51:55Z")

</div>

Now the build is failing with: No such file or directory @ dir\_initialize - /home/ubuntu/aact2/tmp

I assume this is because I am trying to write files to the tmp directory, which is not in source control. I have code in the TableExporter model that will try to create a tmp directory if none exists, but that doesn’t seem to be working.

---

<div class="post-metadata">

**Author:** ![garrettqmartin8](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/garrettqmartin8/32/13339_2.png) [@garrettqmartin8](https://discuss.circleci.com/u/garrettqmartin8)\
**Post date:** [June 27, 2016, 3:36pm UTC](https://discuss.circleci.com/t/postgres-insufficient-privilege/4782/5 "2016-06-27T15:36:16Z")

</div>

Solved! Added a post checkout hook to my circle.yml to create the tmp directory.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/circleci/original/3X/5/1/511608acda8e85906e15909b57bd0a46c1dbe291.png) [@system](https://discuss.circleci.com/u/system)\
**Post date:** [June 18, 2018, 11:41am UTC](https://discuss.circleci.com/t/postgres-insufficient-privilege/4782/6 "2018-06-18T11:41:44Z")

</div>

Closed on June 18, 2018, 11:41am UTC