Thread: Installing dblink

Ridvan Lakas ng Bayan S. Baluyos schrieb:
> Hi list,
>
> I'm currently having a problem. I cannot call the dblink_connect
> function of postgres.
>
> pos=# select dblink_connect('dbname=postgres');
> ERROR:  function dblink_connect("unknown") does not exist
> HINT:  No function matches the given name and argument types. You may
> need to add explicit type casts.
> pos=#
>
> I've read this in the archives though but i still can't find the
> contrib-package he is talking about:
> http://archives.postgresql.org/pgsql-sql/2006-02/msg00311.php
>

Which OS are you running? If you are running a Debian based Linux try:

$ apt-cache search postgresql

You will find a package called
postgresql-contrib - additional facilities for PostgreSQL (latest version)

$ apt-get install postgresql-contrib

installs the package. After that you should be able to use dblink like
A. Kretschmer was writing.

>
> My postgres version is 8.1.8


Hint: you should upgrade to version 8.3. postgresql-contrib package is
always for the latest version which is 8.3 on Debian Lenny.

Cheers

Andy

--
Andreas Wenk

St.Pauli - Hamburg - Germany

>
>
> Thanks in advance!
>
> --
> リヅバン バルヨス
> ridvan.baluyos@qualservcentral.com
> <mailto:ridvan.baluyos@qualservcentral.com>
> http://ridvan.baluyos.net
> http://www.onxiam.com/people/rbaluyos
>
> Registered Linux User #439466
> Registered Ubuntu User #16034
> Q: Have you heard of the Object-Oriented way to get wealthy?
> A: Inheritance.

--
----------------------------------
Netzmeister St.Pauli

St.Pauli - Hamburg - Germany

Andreas Wenk

Lutterothstr 82
20255 Hamburg

Tel.: +49 (0) 40 319 43 54

http://www.netzmeister-st-pauli.de
mailto:a.wenk@netzmeister-st-pauli.de

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Ridvan Lakas ng Bayan S. Baluyos schrieb:
> Hi Andy,
>
> Thanks for your reply. I've already installed postgresql-contrib-8.1:
> root@<domain>:~# dpkg --list | grep "postgresql-contrib"
> ii  postgresql-contrib-8.1
> 8.1.8-0ubuntu6.06.1                        additional facilities for
> PostgreSQL
>
> And still it can't recognize the dblink_connect function,
> pos=# select dblink_connect();
> ERROR:  function dblink_connect() does not exist
> HINT:  No function matches the given name and argument types. You may
> need to add explicit type casts.
>
>
> I've ready to dump the dblink.sql file? Where can I download it?
>

Hi Ridvan,

root@seven:~# find / -name dblink.sql
/usr/share/postgresql/8.1/contrib/dblink.sql

Cheers

Andy
- --
St.Pauli - Hamburg - Germany

Andreas Wenk


> Thanks,
>
> Ridvan
>
> On Mon, Jan 19, 2009 at 8:25 PM, Andreas Wenk
> <a.wenk@netzmeister-st-pauli.de <mailto:a.wenk@netzmeister-st-pauli.de>>
> wrote:
>
>
>     Ridvan Lakas ng Bayan S. Baluyos schrieb:
>
>         Hi list,
>
>         I'm currently having a problem. I cannot call the dblink_connect
>         function of postgres.
>
>         pos=# select dblink_connect('dbname=postgres');
>         ERROR:  function dblink_connect("unknown") does not exist
>         HINT:  No function matches the given name and argument types.
>         You may need to add explicit type casts.
>         pos=#
>
>         I've read this in the archives though but i still can't find the
>         contrib-package he is talking about:
>         http://archives.postgresql.org/pgsql-sql/2006-02/msg00311.php
>
>
>     Which OS are you running? If you are running a Debian based Linux try:
>
>     $ apt-cache search postgresql
>
>     You will find a package called
>     postgresql-contrib - additional facilities for PostgreSQL (latest
>     version)
>
>     $ apt-get install postgresql-contrib
>
>     installs the package. After that you should be able to use dblink
>     like A. Kretschmer was writing.
>
>
>
>         My postgres version is 8.1.8
>
>
>
>     Hint: you should upgrade to version 8.3. postgresql-contrib package
>     is always for the latest version which is 8.3 on Debian Lenny.
>
>     Cheers
>
>     Andy
>
>     --
>     Andreas Wenk
>
>     St.Pauli - Hamburg - Germany
>
>
>
>         Thanks in advance!
>
>         --
>         リヅバン バルヨス
>         ridvan.baluyos@qualservcentral.com
>         <mailto:ridvan.baluyos@qualservcentral.com>
>         <mailto:ridvan.baluyos@qualservcentral.com
>         <mailto:ridvan.baluyos@qualservcentral.com>>
>
>         http://ridvan.baluyos.net
>         http://www.onxiam.com/people/rbaluyos
>
>         Registered Linux User #439466
>         Registered Ubuntu User #16034
>         Q: Have you heard of the Object-Oriented way to get wealthy?
>         A: Inheritance.
>
>
>     --
>     ----------------------------------
>     Netzmeister St.Pauli
>
>     St.Pauli - Hamburg - Germany
>
>     Andreas Wenk
>
>     Lutterothstr 82
>     20255 Hamburg
>
>     Tel.: +49 (0) 40 319 43 54
>
>     http://www.netzmeister-st-pauli.de
>     mailto:a.wenk@netzmeister-st-pauli.de
>     <mailto:a.wenk@netzmeister-st-pauli.de>
>
>
>
>
> --
> リヅバン バルヨス
> ridvan.baluyos@qualservcentral.com
> <mailto:ridvan.baluyos@qualservcentral.com>
> http://ridvan.baluyos.net
> http://www.onxiam.com/people/rbaluyos
>
> Registered Linux User #439466
> Registered Ubuntu User #16034
> Q: Have you heard of the Object-Oriented way to get wealthy?
> A: Inheritance.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJdagGVa7znmSP9AwRAsh1AJ48QZwQHmtgtX/7Hp+P7xemXKP5bgCgnDZ0
P7+BvrUjfMwyM8M1bkqWgyo=
=2wNW
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hey Ridvan,

that's cool ... happy that I was able to help ;-)

Cheers

Andy
- --
St.Pauli - Hamburg - Germany

Andreas Wenk

Ridvan Lakas ng Bayan S. Baluyos schrieb:
> Thanks Andy! Everything works fine already.
>
> +1 for you!
>
>
> Ridvan
>
> On Tue, Jan 20, 2009 at 6:31 PM, Andreas Wenk
> <a.wenk@netzmeister-st-pauli.de <mailto:a.wenk@netzmeister-st-pauli.de>>
> wrote:
>
>
> Ridvan Lakas ng Bayan S. Baluyos schrieb:
>> Hi Andy,
>
>> Thanks for your reply. I've already installed postgresql-contrib-8.1:
>> root@<domain>:~# dpkg --list | grep "postgresql-contrib"
>> ii  postgresql-contrib-8.1
>> 8.1.8-0ubuntu6.06.1                        additional facilities for
>> PostgreSQL
>
>> And still it can't recognize the dblink_connect function,
>> pos=# select dblink_connect();
>> ERROR:  function dblink_connect() does not exist
>> HINT:  No function matches the given name and argument types. You may
>> need to add explicit type casts.
>
>
>> I've ready to dump the dblink.sql file? Where can I download it?
>
>
> Hi Ridvan,
>
> root@seven:~# find / -name dblink.sql
> /usr/share/postgresql/8.1/contrib/dblink.sql
>
> Cheers
>
> Andy

> --
> リヅバン バルヨス
> ridvan.baluyos@qualservcentral.com
> <mailto:ridvan.baluyos@qualservcentral.com>
> http://ridvan.baluyos.net
> http://www.onxiam.com/people/rbaluyos

> Registered Linux User #439466
> Registered Ubuntu User #16034
> Q: Have you heard of the Object-Oriented way to get wealthy?
> A: Inheritance.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJdaxoVa7znmSP9AwRAvrkAJ9/x6pW2bJnD9hO9n6PqxtWlM5KQwCghl1i
fopAAM11FAOlsO5UuyAyeAE=
=FTUQ
-----END PGP SIGNATURE-----