Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    16

    Unanswered: Error running adminpack--1.0.sql

    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

  2. #2
    Join Date
    Oct 2011
    Posts
    16

    Re: Error running adminpack--1.0.sql

    Hi,

    "create extension adminpack" works!

    Regards,
    Eye Gee

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •