Re: How To Install Extension Via Script File?

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