Hi Pablo,
This is not a PG in-built function. It seems like a user-defined one. You may need to troubleshoot the function.
Thanks,
Ninad
On Mon, Oct 9, 2023 at 4:01 PM Pablo Delgado <pabloj.df@xxxxxxxxx> wrote:
I am observing this error in the log of my PostgreSQL 12:
2023-10-07 16:03:06 UTC:LOG: POWA connected to database powa
2023-10-07 16:03:06 UTC:ERROR: query returned more than one row
2023-10-07 16:03:06 UTC:HINT: Make sure the query returns a single row, or use LIMIT 1.
2023-10-07 16:03:06 UTC:CONTEXT: PL/pgSQL function powa_take_snapshot(integer) line 31 at SQL statement
SQL statement "SELECT public.powa_take_snapshot()"
2023-10-07 16:03:06 UTC:LOG: background worker "powa" (PID 34049) exited with exit code 1This error prevents me from doing a pg_basebackup of my DB.--Un saludo,Pablo Delgado FloresDBA Oracle · Desarrollador WordPress · Sysadmin
