You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
When I try to compile pg_rman I did the following steps:
make
make install
Everything finished successfully but create only pg_rman utility in bin folder (NOT create pg_rman.so in lib folder)
I add pg_stat_statements = 'pg_rman' in postgresql.conf, but when I try to start the server receive this error:
[remote]=:[APP]=:[user]=[db]=:58P01:651c243b.19201a::3:0FATAL: 58P01: could not access file "pg_rman": No such file or directory
OpenSSL version:
OpenSSL 3.0.7 1 Nov 2022 (Library: OpenSSL 3.0.7 1 Nov 2022)
OS version:
NAME="Rocky Linux"
VERSION="9.2 (Blue Onyx)"
Postgresql version:
v14.4
The text was updated successfully, but these errors were encountered:
Done. Now I receive one new error:
[pdbbo_adm@rocky-9 backup]$ pg_rman backup --backup-mode=full --with-serverlog --progress
INFO: copying database files
ERROR: query failed: ERROR: function pg_backup_start(unknown, unknown) does not exist
LINE 1: SELECT * from pg_walfile_name_offset(pg_backup_start($1, $2)...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
query was: SELECT * from pg_walfile_name_offset(pg_backup_start($1, $2))
Could you please suggest what exactly is the problem ?
I think the reason is that function name of PostgreSQL was changed.
You need to compile with the branch REL_14_STABLE corresponding your PostgreSQL version.
Hello,
When I try to compile pg_rman I did the following steps:
Everything finished successfully but create only pg_rman utility in bin folder (NOT create pg_rman.so in lib folder)
I add pg_stat_statements = 'pg_rman' in postgresql.conf, but when I try to start the server receive this error:
[remote]=:[APP]=:[user]=[db]=:58P01:651c243b.19201a::3:0FATAL: 58P01: could not access file "pg_rman": No such file or directory
OpenSSL version:
OpenSSL 3.0.7 1 Nov 2022 (Library: OpenSSL 3.0.7 1 Nov 2022)
OS version:
NAME="Rocky Linux"
VERSION="9.2 (Blue Onyx)"
Postgresql version:
v14.4
The text was updated successfully, but these errors were encountered: