Need someone to install Postgis on my VPS, i will pay $15.

Discussion in 'Site & Server Administration' started by zukinaru, Aug 29, 2008.

  1. #1
    Hello,

    I need someone who has experienced to install Postgis (http://postgis.refractions.net/). You will install on my VPS, you can rebuild/change OS to debian/centos/fedora/etc.

    This should be easy task, i have tried myself but i got this unsolved error :

    Error :
    psql:lwpostgis.sql:44: NOTICE: type "histogram2d" is not yet defined
    DETAIL: Creating a shell type definition.
    psql:lwpostgis.sql:44: ERROR: could not access file "$libdir/liblwgeom": No such file or directory
    psql:lwpostgis.sql:50: ERROR: current transaction is aborted, commands ignored until end of transaction block


    and

    ERROR: incompatible library
    “/usr/local/pgsql/lib/liblwgeom.so.1.2″: missing magic block INT: Extension libraries are required to use the
    PG_MODULE_MAGIC


    Please documented, so i can clone to another server.

    Please PM me.
     
    zukinaru, Aug 29, 2008 IP
  2. nimhost

    nimhost Active Member

    Messages:
    235
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    58
    #2
    if you using cpanel on your vps you can use this command /scripts/installpostgres
     
    nimhost, Aug 29, 2008 IP
  3. zukinaru

    zukinaru Well-Known Member

    Messages:
    253
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    123
    #3
    How to do this ? Can you give example ?

    thanks.
     
    zukinaru, Aug 31, 2008 IP
  4. nimhost

    nimhost Active Member

    Messages:
    235
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    58
    #4
    login into your server via ssh then type /scripts/installpostgres
    after that follow the steps :)
     
    nimhost, Aug 31, 2008 IP
  5. jayshah

    jayshah Peon

    Messages:
    1,126
    Likes Received:
    68
    Best Answers:
    1
    Trophy Points:
    0
    #5
    Do you have PostgreSQL installed already? I can't tell from your posts.

    Jay
     
    jayshah, Aug 31, 2008 IP