Re: incompatibilities with newer Postgresql

"Trever L. Adams" <[email protected]> Sun, 24 Dec 2023 03:30:04 -0700
Newsgroups gmane.comp.archivers.amanda.user
Message-ID <939c4992-a494-4f1e-8c9e-730cf27c2a63@middleearth.sapphiresunday.org>
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" 
> <[email protected]> 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
>