Re: Snow Leopard and PG 8.4 problems....

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(dot)levan(at)eku(dot)edu
> > Subject: [GENERAL] Snow Leopard and PG 8.4 problems....
> > Date: Sat, 29 Aug 2009 12:08:45 -0400
> > To: pgsql-general(at)postgresql(dot)org
> >
> > 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(at)postgresql(dot)org)
> > 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.