Closed computate closed 1 month ago
I have successfully tested installing postgresql-server on a CentOS Stream 9 image with multiple VM Snapshots along the way:
I was able to shutdown the VM, restore to several of these snapshots, restart the VM and see the state of the filesystem at the various snapshots.
Here are some steps I did to install a PostgreSQL database for testing the VM.
$ sudo yum install -y postgresql-server postgresql-contrib
$ sudo systemctl start postgresql
$ sudo systemctl enable postgresql
$ sudo -u postgres psql
$ create user test password '...';
$ create database test owner test;
$ create table test(pk bigserial primary key, id text unique, val text);
$ postgres=# insert into test(id, val) values('best-linux-flavor', 'rhel9');
INSERT 0 1
$ postgres=# insert into test(id, val) values('best-linux-flavor', 'ubuntu24.04');
ERROR: duplicate key value violates unique constraint "test_id_key"
Motivation
The ability to create and manage VM snapshots of virtual machines, allowing to easily revert to previous states.
This is essential for ensuring data safety, enabling rollback after updates, and supporting test and development use cases.
Completion Criteria
Description
Completion dates
Desired - 2024-10-23 Required - TBD