function gp_create_restore_point(unknown)

[nowost]

Greenplum version or build

INFO: 2022/02/17 12:28:15.272072 Greenplum version: PostgreSQL 9.4.24 (Greenplum Database 6.18.2 build 6.18.2_arenadata30-762.gitefee477.el7) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit compiled on Dec 15 2021 16:44:42

OS version and uname -a

Linux adb-master-01 3.10.0-1160.31.1.el7.x86_64 #1 SMP Thu Jun 10 13:32:12 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

i try to use wal-g for backup and got error

INFO: 2022/02/17 12:33:15.723572 Creating restore point with name backup_20220217T122815Z
ERROR: 2022/02/17 12:33:15.736410 ERROR: function gp_create_restore_point(unknown) does not exist (SQLSTATE 42883)

2022-02-17 12:05:53.336502 UTC,"gpadmin","postgres",p20440,th-1505380224,"127.0.0.1","64774",2022-02-17 12:05:53 UTC,0,con72,cmd7,seg-1,,,,sx1
,"ERROR","42883","function gp_create_restore_point(unknown) does not exist",,"No function matches the given name and argument types. You might
 need to add explicit type casts.",,,,"SELECT (gp_create_restore_point('backup_20220217T120052Z'))::text",9,,"parse_func.c",538,
2022-02-17 12:05:53.336621 UTC,"gpadmin","postgres",p20440,th-1505380224,"127.0.0.1","64774",2022-02-17 12:05:53 UTC,0,con72,cmd7,seg-1,,,,sx1
,"LOG","00000","An exception was encountered during the execution of statement: SELECT (gp_create_restore_point('backup_20220217T120052Z'))::t
ext",,,,,,"SELECT (gp_create_restore_point('backup_20220217T120052Z'))::text",0,,"elog.c",2098,

[Stolb27]

@nowost, hello!

This function is a part of the gp_pitr extension. Did you install this extension with: CREATE EXTENSION gp_pitr in the postgres database?

[nowost]

@Stolb27 , hello! Need create extension and create function manually, and its worked. Tested at 6.17 6.18 6.19 adb comunity versions. Are you plan to add this functional in arenadata db ?