Re: How To Install Extension Via Script File? - Mailing list pgsql-general

From John R Pierce
Subject Re: How To Install Extension Via Script File?
Date
Msg-id 52041C10.6080106@hogranch.com
Whole thread Raw
In response to How To Install Extension Via Script File?  (Don Parris <parrisdc@gmail.com>)
Responses Re: How To Install Extension Via Script File?
List pgsql-general
On 8/8/2013 2:13 PM, Don Parris wrote:
> I thought I could add the commands and run the create script by doing:
> sudo -u postgres psql -U user -W -d mydb
> --file=/home/user/dev/mydb_create.sql
>
> I thought that, running my script as the superuser, it would have the
> privileges necessary to install the extension, but I still got a
> "permission denied" error.

can the postgres user access /home/user/dev ?

thats aside from the rest of potentially wrong stuff the other guys
mentioned.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgres won't start
Next
From: Don Parris
Date:
Subject: Re: How To Install Extension Via Script File?