pgEdge Platform Release Notes

to do's for 23.130 and beyond

add support for pljava-pg15 & -pg16 (cannot find libjvm17 setting from util.get_jvm_location)
fix port numbers in cluster local-create()'s env file
replicate ddl automagically to the spock.replicate_ddl command if cluster is a 'leader'
test json fields for replication
more default conf setting tweaks from customer support (from hari)
explore possible inclusion of function for calling aws lambdas (hari)

leverage lbzip2, if present, to dramatically speed installation
improve Dockerfile.el9 to install lbzip2
bump Spock to 3.1.6 GA
bump pg16 to 16.0 for GA
bump oraclefdw 2.6.0 and add support for pg16
bump partman to 4.7.4 and add support for pg16
continuous improvements in quality & quantity of test scripts (thank u Susan and team)
fix northwind schema and data to use numeric(9,2) for prices & double for discount (was using real)
add support to pg16 for pgCron & pgAudit
bump plprofiler to 4.2.4 and support pg15 & pg16
bump pgVector, PostGIS, TimescaleDB, & Orafce to latest versions
rename the cluster CLI local & remote commands for consistency
move the new Spock db-create command to db create
move new pool cli commands to db pool-
fix northwind demo to work with nodes that default to port 5432
start with first avail port after 6432 for port1 in cluster.create-local()
improve db-create to return json & generate a password if not supplied

bump pg16 to rc1
Spock to 3.1.5 (with new security roles defined & diff2 backpatch to pg15)
improve efficiency of ace diff-tables to handle massive tables w blocks of checksums
bump pgcat to 1.1.1 & make available for dev and test
add support for plv8 3.2.0 for dev and test
fixed a tricky problem (reported by susan) when adding tables to a repset w/ a wildcard (cady)
Fix missing static lib for uuid-ossp in pg15 & pg16 builds
2nd pass at implementing spock.db_create() for supporting Dev Edition reqmnts
WIP: refactor install-pgedge.py to use spock.db_create()
2nd pass and document secure CLI (cady)
WIP: Windows compatibility for secure & cluster CLI commands

add support for pg16beta3 & bumped versions of pg11 thru pg15
add secure api for interacting with pgEdge Cloud services
add requests & awscli as default nclibs
enhance northwind app to use schema 'northwind' rather than defaulting to 'public'
the basic cluster.import_remote_def() now works
spock.repset_add_table() only throws WARNING when table cannot be added
create a good dev baseline for etcd & patroni installs
create a good dev baseline for pgcat (throwing a sed error)
get devel scripts for start & stop http.server out of base directory & into devel

improve devel/setup doc & completeness
add support for ./nc psql 99 -f
confirm cluster app-install northwind works fully
drop unused from spock.py validate(), tune() & install()}
fix regression in spock.repset_add_tables() for wildcards
soften bad_os warning
fix bug where ./nc tune setting working_mem to 0 GB
install pgedge now supports parms --with-patroni, --with-backrest & --with-cat
bump backrest from 2.46 to 2.47
fix install/remove for backrest not to assume pg15
bump plv8 to 3.2.0

fix race condition when initializing cluster in Docker
improvements to autostarting PG for Docker
incremental improvements and fixes to spock.py (thank u cady)
remove speculative doc support for Amazon Linux 2023 (adding it back is "coming soon")
add 1st pass northwind as a demo/test app (alongside pgbench)
remove runNC() & validate() from cluster.py
improve cluster.command() to work with local and remote
improve lag monitoring & expose via spock.metrics_check()

install platform specific nclibs and support running on el9-amd, el9-arm, ubu22-amd & osx-amd/arm
bump Spock to 3.1.4 (bug fixes)
document service init & service config commands as internal use only
ensure cluster create-local: defaults to pg16, but allows for --pg=15 override allows for -U, -P and -d overrides from command line
fix race-condition in docker compose code
ensure cluster remote-init and cluster create-local commands are working in parity & with shared codebase
get to codeComplete for cluster remote-init
get to codeComplete for cluster remote-reset
improve flexibility of cluster.runNC() to handle passwordless ssh without certificates
improve cluster.echo_cmd() to handle remote ssh when os_user is presented
verify cluster.echo_cmd() handles remote ssh when ssh_key is present

fix regression to allow core PG functionality to use Python 3.6+ (not require Python 3.9+)
improve ace diff-tables error handling and re-factor for going fwd
make 1st and 2nd passes at cluster remote-init
bump orafce to v4.3.0
bump curl to v2.1.1

improve ssh support for cluster create-local
add devel/setup support for zookeeper & patroni
stub out starfleet support
add warning when not EL9+ or Ubuntu 22.04+
add cloud metadata to INFO command (region, az, instance_id, account_id, flavor)
new version of Spock 3.1.3 supporting double update bug fix and other.