Improve Installation Documentation

[mneverov]

Improve documentation

Link

https://supabase.github.io/supautils/installation/

Describe the problem

When I follow the instructions above I get errors from PG.

Describe the improvement

Documentation that describes prerequisites, like installing postgresql-server-dev-... and environment variables.

Additional context

make && make install
make: Nothing to be done for 'all'.
/bin/mkdir -p '/usr/lib/postgresql/15/lib'
/bin/mkdir -p '/usr/share/postgresql/15/extension'
/bin/mkdir -p '/usr/share/postgresql/15/extension'
/usr/bin/install -c -m 755  supautils.so '/usr/lib/postgresql/15/lib/supautils.so'
/usr/bin/install -c -m 644 .//supautils.control '/usr/share/postgresql/15/extension/'
/usr/bin/install -c -m 644 .//sql/supautils--0.1.0.sql  '/usr/share/postgresql/15/extension/'
/bin/mkdir -p '/usr/lib/postgresql/15/lib/bitcode/supautils'
/bin/mkdir -p '/usr/lib/postgresql/15/lib/bitcode'/supautils/src/
/usr/bin/install -c -m 644 src/supautils.bc '/usr/lib/postgresql/15/lib/bitcode'/supautils/src/
/usr/bin/install -c -m 644 src/privileged_extensions.bc '/usr/lib/postgresql/15/lib/bitcode'/supautils/src/
/usr/bin/install -c -m 644 src/utils.bc '/usr/lib/postgresql/15/lib/bitcode'/supautils/src/
cd '/usr/lib/postgresql/15/lib/bitcode' && /usr/lib/llvm-10/bin/llvm-lto -thinlto -thinlto-action=thinlink -o supautils.index.bc supautils/src/supautils.bc supautils/src/privileged_extensions.bc supautils/src/utils.bc

 ld -v /usr/lib/postgresql/15/lib/supautils.so
GNU ld (GNU Binutils for Ubuntu) 2.34
ld: warning: cannot find entry symbol _start; not setting start address
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `superuser'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `get_rolespec_name'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `standard_ProcessUtility'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `SPI_execute'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `list_delete_ptr'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `ProcessUtility_hook'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `GetUserId'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `makeInteger'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `CurrentMemoryContext'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `lowerstr'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `errmsg_internal'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `elog_finish'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `GetUserIdAndSecContext'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `IsTransactionState'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `quote_literal_cstr'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `SetUserIdAndSecContext'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `SPI_connect'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `SplitIdentifierString'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `pg_snprintf'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `palloc'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `list_free'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `pstrdup'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `AlterRole'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `PopActiveSnapshot'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `list_make1_impl'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `elog_start'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `errmsg'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `GetTransactionSnapshot'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `PushActiveSnapshot'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `get_role_oid'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `makeDefElem'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `quote_identifier'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `errfinish'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `DefineCustomStringVariable'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `MemoryContextAllocZeroAligned'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `SPI_finish'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `pfree'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `errcode'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `MarkGUCPrefixReserved'
ld: /usr/lib/postgresql/15/lib/supautils.so: undefined reference to `errstart_cold'

Feb 14 20:18:11 postgresql@15-main[1714541]: Error: /usr/lib/postgresql/15/bin/pg_ctl /usr/lib/postgresql/15/bin/pg_ctl start -D /var/lib/postgresql/15/main -l /var/log/postgresql/postgresql-15-main.log -s -o  -c config_file="/etc/postgresql/15/main/postgresql.conf"  exited with status 1:
Feb 14 20:18:11 postgresql@15-main[1714541]: 2023-02-14 20:18:11.785 CET [1714546] FATAL:  could not load library "/usr/lib/postgresql/15/lib/supautils.so": /usr/lib/postgresql/15/lib/supautils.so: undefined symbol: elog_finish
Feb 14 20:18:11 postgresql@15-main[1714541]: 2023-02-14 20:18:11.786 CET [1714546] LOG:  database system is shut down