pg_branch icon indicating copy to clipboard operation
pg_branch copied to clipboard

invalid create database strategy "snapshot"

Open hparfr opened this issue 1 year ago • 1 comments

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"

hparfr avatar Apr 12 '24 14:04 hparfr

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

hparfr avatar Apr 15 '24 09:04 hparfr