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
Copy file name to clipboardExpand all lines: README.md
+6-2Lines changed: 6 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -72,13 +72,19 @@ More interesting features are yet to come. Stay tuned!
72
72
73
73
##Installation guide
74
74
To install`pg_pathman`, execute this in the module's directory:
75
+
75
76
```shell
76
77
make install USE_PGXS=1
77
78
```
79
+
80
+
>**Important:** Don't forget to set the`PG_CONFIG` variable (`make PG_CONFIG=...`) in case you want to test`pg_pathman` on a non-default or custom build of PostgreSQL. Read more[here](https://wiki.postgresql.org/wiki/Building_and_Installing_PostgreSQL_Extension_Modules).
81
+
78
82
Modify the**`shared_preload_libraries`** parameter in`postgresql.conf` as following:
83
+
79
84
```
80
85
shared_preload_libraries = 'pg_pathman'
81
86
```
87
+
82
88
>**Important:**`pg_pathman` may cause conflicts with some other extensions that use the same hook functions. For example,`pg_pathman` uses`ProcessUtility_hook` to handle COPY queries for partitioned tables, which means it may interfere with`pg_stat_statements` from time to time. In this case, try listing libraries in certain order:`shared_preload_libraries = 'pg_stat_statements, pg_pathman'`.
83
89
84
90
It is essential to restart the PostgreSQL instance. After that, execute the following query in psql:
@@ -88,8 +94,6 @@ CREATE EXTENSION pg_pathman;
88
94
89
95
Done! Now it's time to setup your partitioning schemes.
90
96
91
-
>**Important:** Don't forget to set the`PG_CONFIG` variable in case you want to test`pg_pathman` on a custom build of PostgreSQL. Read more[here](https://wiki.postgresql.org/wiki/Building_and_Installing_PostgreSQL_Extension_Modules).