postgresql

PyKMIP + PostgreSQL with pg_tde, Percona Server for MySQL

by .pQd
i wanted to try applying transparent data encryption in PostgreSQL 17, MySQL 8.4 with key obtained via KMIP from KMS. i’ve used PyKMIP as Key Management System. i could not find any detailed step by step guide, even Percona’s own documents were pretty minimal. below – is what i’ve done step by step. my setup ... Read More

crude way to restore postgresql database dump to table with a different name

by .pQd
i needed to restore specific table, backed up via pg_dump, to the same database / schema but under different name. that’s what i’ve done pv dump.zstd|pzstd -dc - |sed 's/name_of_original_table/name_of_renamed_table/g'|su - postgres -c 'psql dbname' this only works if all constrains / indices have in their name name of the original table.