Commite4e95cf

committed

mentioned conflicts between extensions in docs

1 parent7707ad5 commite4e95cfCopy full SHA for e4e95cf

File tree

-0

lines changed

-0

lines changed

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
@@ -66,6 +66,8 @@ Modify the `shared_preload_libraries` parameter in `postgresql.conf` as foll
`66`	`66`	```
`67`	`67`	`shared_preload_libraries = 'pg_pathman'`
`68`	`68`	```
	`69`	+>Important:`pg_pathman` may have conflicts with some other extensions which uses the same hook functions. For example,`pg_pathman` uses`ProcessUtility_hook` hook to handle COPY queries for partitioned tables. And it could sometimes interfere with`pg_stat_statements` extension which uses the same hook. In this case try to list libraries in certain order:`shared_preload_libraries = 'pg_pathman, pg_stat_statements'`
	`70`	`+`
`69`	`71`	`It is essential to restart the PostgreSQL instance. After that, execute the following query in psql:`
`70`	`72`	```plpgsql
`71`	`73`	`CREATE EXTENSION pg_pathman;`

Comments

(0)