Results 1 to 2 of 2

Thread: dblink question

  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: dblink question

    Hello all!

    I am rather stuck and am hoping someone can help. I am working on a project where users need to be able to send one query which will hit databases on multiple hosts (the database structures are the same) and tie the data back together again.

    After doing lots of reading it looks like dblink might be a great solution for this. After trying to insert dblink.sql into the database, I just get a series of errors:

    ERROR: stat failed on file '$libdir/dblink': No such file or directory

    Does anyone know how I can get around this error? Or is dblink not really a good solution for what I am trying to do? I am sure others out there have had to do similar tasks before so any advice that can be provided would be greatly appreciated!

    TIA for your time and reply!

    --Sam

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    compile

    did you compile the other part of dblink
    the dblink.sql did not find some functions

    read the README file
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

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