From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How To Install Extension Via Script File? |
Date: | 2013-08-08 21:44:43 |
Message-ID: | ku13ed$ph3$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Don Parris wrote on 08.08.2013 23:13:
> And to be able to run it from the Bash prompt (as securely as possible).
>
> 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.
You are not running the script as superuser because you supplied "-U user" and thus the _script_ is executed
as "user". psql is started as "postgres" (the Linux user, not the DB user).
I don't see the reason for using sudo in the first place, -U is enough:
Leave out the sudo, and use:
psql -U postgres -W -d mydb --file=/home/user/dev/mydb_create.sql
Or if you do want to use sudo, the leave out the -U user parameter:
sudo -u postgres psql -d mydb --file=/home/user/dev/mydb_create.sql
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2013-08-08 21:45:21 | Re: How To Install Extension Via Script File? |
Previous Message | Don Parris | 2013-08-08 21:13:26 | How To Install Extension Via Script File? |