Difference between revisions of "Postgrest row level security via postgres"
Jump to navigation
Jump to search
Line 6: | Line 6: | ||
DETAIL: Could not open extension control file "/opt/bitnami/postgresql/share/extension/pgjwt.control": No such file or directory. | DETAIL: Could not open extension control file "/opt/bitnami/postgresql/share/extension/pgjwt.control": No such file or directory. | ||
HINT: The extension must first be installed on the system where PostgreSQL is running. | HINT: The extension must first be installed on the system where PostgreSQL is running. | ||
+ | ``` | ||
+ | |||
+ | ``` | ||
+ | # apt-get install postgresql-server-dev-all | ||
+ | # cd /root/ | ||
+ | /root # git clone https://github.com/michelp/pgjwt.git | ||
+ | cd pgjwt | ||
+ | /root/pgjwt# make install | ||
+ | /bin/mkdir -p '/opt/bitnami/postgresql/share/extension' | ||
+ | /bin/mkdir -p '/opt/bitnami/postgresql/share/extension' | ||
+ | /usr/bin/install -c -m 644 .//pgjwt.control '/opt/bitnami/postgresql/share/extension/' | ||
+ | /usr/bin/install -c -m 644 .//pgjwt--0.1.1.sql .//pgjwt--0.1.0--0.1.1.sql .//pgjwt--0.1.1--0.2.0.sql '/opt/bitnami/postgresql/share/extension/' | ||
``` | ``` |
Revision as of 21:47, 27 April 2023
postgres=# CREATE EXTENSION IF NOT EXISTS pgjwt WITH SCHEMA ext_pgjwt; ERROR: extension "pgjwt" is not available DETAIL: Could not open extension control file "/opt/bitnami/postgresql/share/extension/pgjwt.control": No such file or directory. HINT: The extension must first be installed on the system where PostgreSQL is running.
# apt-get install postgresql-server-dev-all # cd /root/ /root # git clone https://github.com/michelp/pgjwt.git cd pgjwt /root/pgjwt# make install /bin/mkdir -p '/opt/bitnami/postgresql/share/extension' /bin/mkdir -p '/opt/bitnami/postgresql/share/extension' /usr/bin/install -c -m 644 .//pgjwt.control '/opt/bitnami/postgresql/share/extension/' /usr/bin/install -c -m 644 .//pgjwt--0.1.1.sql .//pgjwt--0.1.0--0.1.1.sql .//pgjwt--0.1.1--0.2.0.sql '/opt/bitnami/postgresql/share/extension/'