On Aug 29, 2009, at 2:40 PM, Martin Gainty wrote:
for superusers only
dblink-connect takes a libpq style connection string with hostaddr
as first attribute
dblink("hostaddr=127.0.0.1 port=5432 dbname=mydb user=postgres
password=mypasswd");
http://www.postgresql.org/docs/current/static/contrib-dblink-connect.html
Martin Gainty
I have been able to use just the ip in the host field but Snow Leopard
seems to have
broken using a 'name' in the host field... see below.
It appears that compiling pg 8.4 gives rise to libs with architecture
of x386_64...
What sort of magic do I have to use to get a 32 bit version of the
various libs ?
( I don't seem to be able to find where in the make file I can ask the
linker to
add the various archs, but I am getting bleary eyed.)
I don't seem to be able to compile python support against the apple
2.6 or the macpython
2.5 versions (of python).
Has anyone built a Snow Leopard version of pg with python support?
Am I the only one to have problems with dblink on Snow Leopard?
( the fedora 11 rpms work fine...)
Jerry
> From: jerry.levan@xxxxxxx
> Subject: Snow Leopard and PG 8.4 problems....
> Date: Sat, 29 Aug 2009 12:08:45 -0400
> To: pgsql-general@xxxxxxxxxxxxxx
>
> Gaaaah,
>
> Last week postgresql was working fine, yesterday I upgraded to
> Snow Leopard...
>
> Everything seemed to be working and then I tried to move some
> rows to another machine via dblink.
>
> I am getting a variety of failures on dblink_connect..
>
> mbp is my main machine let me connect to my home server ( named
server )
>
> [mbp:~]$ psql -Ulevan -hserver
> psql (8.4.0)
> Type "help" for help.
>
> levan=# select dblink_connect('host=mbp.skynet user=levan
dbname=levan
> password=foobar');
> ERROR: could not establish connection
> DETAIL: could not translate host name "mbp.skynet" to address:
> nodename nor servname provided, or not known
>
> levan=# select dblink_connect('host=mbp user=levan dbname=levan
> password=foobar');
> ERROR: could not establish connection
> DETAIL: could not translate host name "mbp" to address: nodename nor
> servname provided, or not known
>
> levan=# select dblink_connect('host=mbp.localdomain user=levan
> dbname=levan password=foobar');
> ERROR: could not establish connection
> DETAIL: could not translate host name "mbp.localdomain" to address:
> nodename nor servname provided, or not known
>
> levan=# select dblink_connect('host=192.168.1.80 user=levan
> dbname=levan password=foobar');
> dblink_connect
> ----------------
> OK
> (1 row)
>
> The name resolution appears to be buggered. Now server is almost my
> local network name
> server and it appears to be working just fine ie I can use Safari
send
> mail etc...
>
> Now if I hop on to server and connect to mbp psql and try to use
> dblink...
>
> [mbp:~]$ ssh server
> Password:
> Last login: Sat Aug 29 11:10:48 2009 from mbp.localdomain
> server:~ jerry$ psql -Ulevan -hmbp
> psql (8.4.0)
> Type "help" for help.
>
> levan=# select dblink('host=server user=levan dbname=levan
> password=foobar');
> ERROR: function dblink(unknown) does not exist
> LINE 1: select dblink('host=server user=levan dbname=levan
password=...
> ^
> HINT: No function matches the given name and argument types. You
> might need to add explicit type casts.
>
> ***************************
> Everything was working fine till the installation of Snow Leopard.
>
> I tried to rebuild dblink but got many bizarre errors.
>
> I tried to rebuild postgresql 8.4 but there were problems with
python
> and warnings about perl
> the build did not succeed.
>
> Anyone else having problems?
>
> Jerry
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
With Windows Live, you can organize, edit, and share your photos.
Click here.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
