In current newest postgresql = 9.6 (right now) it's not possible to create a role/user starting with prefix pg_
psql~: create role pg_extensions;
ERROR: role name "pg_extensions" is reserved
DETAIL: Role names starting with "pg_" are reserved.
Time: 3.651 ms
I would propose to change it to postgres_extensions ( password as well)
I now that the plugin target postgresql 9.4 but this makes it at least forward compatible.
In current newest postgresql =
9.6
(right now) it's not possible to create a role/user starting with prefixpg_
I would propose to change it to
postgres_extensions
( password as well) I now that the plugin target postgresql9.4
but this makes it at least forward compatible.