CC-Hsu

`gpbackup` does not copy `gpbackup_history.yaml` to smdw host

1

Hi, One of our subscribed customers previously perform high availability test on mdw/smdw nodes. And they find that `gpbackup_history.yaml` file "disappears" on smdw, which is horrible because they utilize DDBoost...

`gpbackup` sendmail step always fails when running in `crontab`

6

Hi, Team, When executing `gpbackup` / `gprestore` command directly with `gp_email_contacts.yaml` setup, we can receive email after command finish. https://gpdb.docs.pivotal.io/backup-restore/1-20/admin_guide/managing/backup-gpbackup.html#topic_qwd_d5d_tbb However, when putting the same command in `crontab` (running with...

`gprestore --skip-index-build` option

2

Hi, Team, It seems that `gprestore` does not provide parallel index build option and it might be very time-consuming to restore a backup. Please provide an option `--skip-index-build` to skip...

`gpbackup --include-schema` contains default privilege on other schemas not on the list

1

Hi, It seems that `gpbackup --include-schema` additionally backups `DEFAULT PRIVILEGE` commands for schemas not on the list. ``` [gpadmin@gpdb ~]$ psql -d test -c 'ALTER DEFAULT PRIVILEGES FOR ROLE aaa...

`gpbackup --include-schema` backup does not contain created extensions

1

Hi, It seems that `gpbackup` can not backup `plpythonu` extension when specifying `--include-schema` option. Test below: 1. Backup specified schema(s) of a database with `plpythonu` enabled. ``` [gpadmin@gpdb ~]$ createdb...

gpbackup binary backup support

1

Hi, As far as I know, GPDB supports `COPY ... WITH (FORMAT BINARY)` option, which might be faster than normal text file output. https://gpdb.docs.pivotal.io/latest/ref_guide/sql_commands/COPY.html And it seems that `gpbackup` utilize...

Allowing non-superuser to access Apache AGE through python driver

14

Hi, Team, Previously we try to use Apache AGE Python driver to access an AGE database. But we find that we can not run the driver successfully without a DB...

Hi, Team, I find that there was several SRPMs of the Apache AGE in the [PGDG YUM repository](http://yum.postgresql.org/) that can be used to build ready-to-use RPM packages. https://download.postgresql.org/pub/repos/yum/srpms/11/redhat/rhel-8-x86_64/apache-age_11-0.3.0-1.rhel8.src.rpm https://download.postgresql.org/pub/repos/yum/srpms/11/redhat/rhel-8-x86_64/apache-age_11-0.4.0-1.rhel8.src.rpm It...

Making `analyzedb` a remotely executable command

1

Hi, Team, Currently `analyzedb` command does not provide remote execution capability, and it can only executed on `mdw` node. It would be helpful to enhance it to accept connection string...

Providing `optimizer_enable_indexscan` and `optimizer_enable_bitmapscan` to ask GPORCA to use index or not

4

## Feature Request **Is your feature request related to a problem? Please describe:** Hi, Team. Currently when there exists some indexes at a partition table, GPORCA tends to utilize these...