-
Notifications
You must be signed in to change notification settings - Fork 5
Description
After building the lolor extension and adding it to the shared_preload_libraries parameter, the server won't start; it was running before the extension was added, so I may have overlooked something when building the extension.
Could you please see if you can debug this Action and then add some test cases:
An example of the error follows:
PostgreSQL is not ready. Starting it now...
waiting for server to start....2025-03-05 14:23:42.023 UTC [10753] LOG: starting PostgreSQL 16.8 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2025-03-05 14:23:42.024 UTC [10753] LOG: listening on IPv6 address "::1", port 5416
2025-03-05 14:23:42.024 UTC [10753] LOG: listening on IPv4 address "127.0.0.1", port 5416
2025-03-05 14:23:42.025 UTC [10753] LOG: listening on Unix socket "/tmp/.s.PGSQL.5416"
2025-03-05 14:23:42.027 UTC [10756] LOG: database system was shut down at 2025-03-05 14:23:40 UTC
2025-03-05 14:23:42.029 UTC [10753] LOG: database system is ready to accept connections
done
server started
PostgreSQL is running. Listing available extensions:
name | default_version | installed_version | comment
---------+-----------------+-------------------+-----------------------------------------------
plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language
lolor | 1.0 | | Large Objects support for logical replication
(2 rows)
Adding lolor to shared_preload_libraries...
ALTER SYSTEM
Restarting PostgreSQL to apply changes...
waiting for server to shut down...2025-03-05 14:23:47.126 UTC [10753] LOG: received fast shutdown request
.2025-03-05 14:23:47.126 UTC [10753] LOG: aborting any active transactions
2025-03-05 14:23:47.126 UTC [10753] LOG: background worker "logical replication launcher" (PID 10759) exited with exit code 1
2025-03-05 14:23:47.127 UTC [10754] LOG: shutting down
2025-03-05 14:23:47.127 UTC [10754] LOG: checkpoint starting: shutdown immediate
2025-03-05 14:23:47.130 UTC [10754] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.004 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/147FC20, redo lsn=0/147FC20
2025-03-05 14:23:47.134 UTC [10753] LOG: database system is shut down
done
server stopped
pg_ctl: could not start server
Examine the log output.
waiting for server to start.... stopped waiting
PostgreSQL failed to restart! Checking logs:
cat: /var/lib/postgresql/data-16/postgresql.log: No such file or directory
Error: Process completed with exit code 1.