I am assuming you mean something like:
CREATE FUNCTION pg_stop_backup ( ) RETURNS TABLE ( lsn pg_lsn, labelfile
text, spcmapfile text )
AS 'pg_backup_stop'
LANGUAGE internal
STRICT;
CREATE FUNCTION pg_start_backup(label text) RETURNS pg_lsn
AS 'pg_backup_start'
LANGUAGE internal
STRICT;
On 12/21/23 10:07, Ingo Schaefer wrote:
Hello Trever,
you may define aliases for this functions with the "old" name like
described here:
https://www.postgresql.org/docs/current/xfunc-internal.html
HTH,
Ingo
Am 21. Dez. 2023, um 15:11, "Trever L. Adams"
<tre...@middleearth.sapphiresunday.org> schrieb:
So, I am not sure which version started this problem with backing up
PostgreSQL.
| psql stderr: ERROR: function pg_start_backup(unknown) does not exist
| psql stderr: LINE 1: SELECT pg_start_backup('amanda-1703142252')
| psql stderr: ^
| psql stderr: HINT: No function matches the given name and argument
types. You might need to add explicit type casts.
??! Failed to call pg_start_backup
I believe the only change needs to be pg_backup_start instead of
pg_start_backup. The same change in order for pg_backup_stop. See table
9.92 athttps://www.postgresql.org/docs/current/functions-admin.html