Re: How To Install Extension Via Script File?

On Thu, Aug 8, 2013 at 6:30 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> 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.
>

Oops! That *could* create havoc, couldn't it? Still, should be easy
enough to rectify.