pg_branch
pg_branch copied to clipboard
invalid create database strategy "snapshot"
First thanks for this interesting project.
I have succeed to build and install the extension on pg16:
postgres=# select * from pg_extension ;
oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+-----------+----------+--------------+----------------+------------+-----------+--------------
13547 | plpgsql | 10 | 11 | f | 1.0 | |
16390 | pg_branch | 10 | 2200 | f | 0.0.1 | |
Then createdb somebase -T some_template is slow as usual.
I can't force a strategy:
postgres=# create database somebase template some_template strategy snapshot;
ERROR: invalid create database strategy "snapshot"
It's slow because it's not using subvolumes. The only subvolumes are the one created by init.sh (1/ , 4/ , 5/)
I'm new to pgrx. I want to use the system' postgres, so I did:
cargo pgrx init --base-port 5432 --pg16 /usr/bin/pg_config
cargo pgrx install --release