The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PostgreSQL initdb failed

Discussion in 'General Discussion' started by kinsky, Dec 17, 2007.

  1. kinsky

    kinsky Well-Known Member

    Joined:
    Jan 28, 2005
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Greetings..

    I have a server using FreeBSD 6.2 release and cPanel WHM 11.11.0 cPanel 11.16.0-R18473.
    I have successfully installing postgresql using ports (/usr/ports/databases/postgresql80-server) but when i try to configure for the first time using /usr/local/etc/rc.d/postgresql initdb or su -l pgsql -c initdb the result is :

    The files belonging to this database system will be owned by user "pgsql".
    This user must also own the server process.

    The database cluster will be initialized with locale C.

    creating directory /usr/local/pgsql/data ... ok
    creating directory /usr/local/pgsql/data/global ... ok
    creating directory /usr/local/pgsql/data/pg_xlog ... ok
    creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
    creating directory /usr/local/pgsql/data/pg_clog ... ok
    creating directory /usr/local/pgsql/data/pg_subtrans ... ok
    creating directory /usr/local/pgsql/data/base ... ok
    creating directory /usr/local/pgsql/data/base/1 ... ok
    creating directory /usr/local/pgsql/data/pg_tblspc ... ok
    selecting default max_connections ... 40
    selecting default shared_buffers ... 1000
    creating configuration files ... ok
    creating template1 database in /usr/local/pgsql/data/base/1 ... ok
    initializing pg_shadow ... ok
    enabling unlimited row size for system tables ... ok
    initializing pg_depend ... ok
    creating system views ... ok
    loading pg_description ... ok
    creating conversions ... FATAL: could not load library "/usr/local/lib/postgresql/ascii_and_mic.so": dlopen '/usr/local/lib/postgresql/ascii_and_mic.so' failed. (Cannot open /usr/local/lib/postgresql/ascii_and_mic.so")
    child process exited with exit code 1
    initdb: removing data directory "/usr/local/pgsql/data"

    i check the folder of /usr/local/lib/postgresql and there is a file name ascii_and_mic.so.

    Any help ? thank you

    Regards
     

Share This Page