You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
It is essential to restart the PostgreSQL instance. After that, execute the following query in psql:
97
97
```plpgsql
98
98
CREATESCHEMApathman;
99
+
GRANT USAGEON SCHEMA pathman TO PUBLIC;
99
100
CREATE EXTENSION pg_pathman WITH SCHEMA pathman;
100
101
```
101
102
102
103
Done! Now it's time to setup your partitioning schemes.
103
104
104
-
>**Security notice**: Do not install pg_pathman in public schemas! Specify the schema explicitly using the WITH SCHEMA clause. Installing an extensionin ascheme that is accessible to malicious users can lead toa privilege escalation attack.
105
+
>**Security notice**: Do not install pg_pathman in public schemas! Specify the schema explicitly using the WITH SCHEMA clause. Installing an extensioninto aschema in which attackers can create objects can lead toan elevation of privilege attack.
105
106
106
107
>**Windows-specific**: pg_pathman imports several symbols (e.g. None_Receiver, InvalidObjectAddress) from PostgreSQL, which is fine by itself, but requires that those symbols are marked as`PGDLLIMPORT`. Unfortunately, some of them are not exported from vanilla PostgreSQL, which means that you have to either use Postgres Pro Standard/Enterprise (which includes all necessary patches), or patch and build your own distribution of PostgreSQL.