Hello
I compiled from source postgresql 12.1 and all went fine but when I try to restore my DB I can see that I have 3 extensions missing: uuid-ossp, btree_gist, tablefunc.
I tried to run: CREATE EXTENSION "uuid-ossp"; and the error is ERROR: could not open extension control file "/usr/local/pgsql_12.1/share/extension/uuid-ossp.control": No such file or directory
How do I enable these extensions? I tried to copy the file from my previous postgres version but is not compatible.
These were my compiling options: ./configure --with-ossp-uuid --with-uuid=bsd --prefix=/usr/local/pgsql_12.1
Thank you.
I compiled from source postgresql 12.1 and all went fine but when I try to restore my DB I can see that I have 3 extensions missing: uuid-ossp, btree_gist, tablefunc.
I tried to run: CREATE EXTENSION "uuid-ossp"; and the error is ERROR: could not open extension control file "/usr/local/pgsql_12.1/share/extension/uuid-ossp.control": No such file or directory
How do I enable these extensions? I tried to copy the file from my previous postgres version but is not compatible.
These were my compiling options: ./configure --with-ossp-uuid --with-uuid=bsd --prefix=/usr/local/pgsql_12.1
Thank you.