Hi,

I encountered the following errors when running adminpack--1.0.sql:
psql -U postgres < adminpack--1.0.sql
----------------------------------------------------------------------
ERROR: could not access file "MODULE_PATHNAME": No such file or directory
ERROR: could not access file "MODULE_PATHNAME": No such file or directory
ERROR: function pg_catalog.pg_file_rename(text, text, text) does not exist
LINE 3: AS 'SELECT pg_catalog.pg_file_rename($1, $2, NULL:g_catalo...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR: could not access file "MODULE_PATHNAME": No such file or directory
ERROR: could not access file "MODULE_PATHNAME": No such file or directory
ERROR: function "pg_file_read" already exists with same argument types
ERROR: function "pg_file_length" already exists with same argument types
ERROR: function "pg_logfile_rotate" already exists with same argument types

----------------------------------------------------------------------

I have tried to run
sudo -u postgres psql <enter>
create extension "adminpack";
create extension "uuid-ossp";

But still got the above errors.

Regards,
Eye Gee

Hi,

"create extension adminpack" works!

Regards,
Eye Gee