PostgreSQL 18 adds a search path for extension files. This has two big advantages:

• it allows us to distribute extensions separately from the rest of PostgreSQL
• it makes it easier to build your own extesnions

We need to make the following changes:

• update Postgres.app GUI to configure search paths (extension_control_path and dynamic_library_path) when starting servers
• patch pgxs makefile to use a default prefix