Re: Re: [GENERAL] Need Help Installing Dblink…(Desperately…)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jerry Levan <jerry(dot)levan(at)gmail(dot)com>
Cc: Scott Mead <scottm(at)openscg(dot)com>, "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: [GENERAL] Need Help Installing Dblink…(Desperately…)
Date: 2011-11-12 22:49:49
Message-ID: 4622.1321138189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jerry Levan <jerry(dot)levan(at)gmail(dot)com> writes:
> On Nov 12, 2011, at 3:34 PM, Scott Mead wrote:
>> The Makefile should be including the global.... did you try a 'make install' ?

> I went back and did the make install from the dblink directory it installed
> stuff in the share directory but invoking dblink functions failed with
> an unknown definition. I invoked the create extension command but it
> did no good...

Vague handwaving like that is an excellent way to guarantee that nobody
can help you, because we can't figure out what you did wrong (or, maybe,
what the code did wrong) based on this. We need to see exactly what
commands you gave and what results you got. Please read
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

(In general, though, in PG 9.1 you do not source contrib SQL scripts
directly. CREATE EXTENSION is the way to install a contrib module into
a database.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Levan 2011-11-13 00:41:18 Re: [GENERAL] Re: [GENERAL] Need Help Installing Dblink…(Desperately…)
Previous Message Cody Caughlan 2011-11-12 21:47:52 Re: Large values for duration of COMMITs and slow queries. Due to large WAL config values?