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
+14Lines changed: 14 additions & 0 deletions
Original file line number
Diff line number
Diff line change
@@ -77,6 +77,19 @@ Done! Now it's time to setup your partitioning schemes.
77
77
78
78
>**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).
79
79
80
+
##How to update
81
+
In order to update pg_pathman:
82
+
83
+
1. Install the latest_stable_ release of pg_pathman.
84
+
2. Restart your PostgreSQL cluster.
85
+
3. Execute the following queries:
86
+
87
+
```plpgsql
88
+
/* replace X.Y with the version number, e.g. 1.3*/
89
+
ALTER EXTENSION pg_pathmanUPDATE TO"X.Y";
90
+
SETpg_pathman.enable= t;
91
+
```
92
+
80
93
##Available functions
81
94
82
95
###Partition creation
@@ -654,3 +667,4 @@ Do not hesitate to post your issues, questions and new ideas at the [issues](htt
654
667
Ildar Musin <i.musin@postgrespro.ru> Postgres Professional Ltd., Russia
655
668
Alexander Korotkov <a.korotkov@postgrespro.ru> Postgres Professional Ltd., Russia
656
669
Dmitry Ivanov <d.ivanov@postgrespro.ru> Postgres Professional Ltd., Russia