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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general