1 Preparation for make installcheck
3 1. Install pg_dbms_stats into the target binary tree. Make sure to
4 prepare the PATH environment variable properly to execute the right
5 pg_config for the version of target PostgreSQL server.
7 postgres$ which pg_config
8 <somewhere bin of the target server resides>/pg_config
11 2. Install additionally required contrib module file_fdw. This could
12 be done for RPM installed server by installing postgresql##-contrib
13 using yum after installing additional repository.
15 # yum install postgresql96-contrib
17 3. Edit postgresql.conf so that pg_dbms stats will be automatically
20 postgres$ echo "shared_preload_libraries = 'pg_dbms_stats'" >> <PGDATA>/postgresql.conf
22 4. Start the target server
24 postgres$ postgres or pg_ctl start
26 5. Install extension on the server.
28 postgres$ psql postgres -c 'CREATE EXTENSION pg_dbms_stats; CREATE EXTENSION file_fdw;'
30 6. run make installcheck
32 postgres$ make installcheck