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 >