Re: [JDBC] jdbc and nfs

From: Dave Cramer <pg(at)fastcrypt.com>
Date: Sat Feb 16 2008 - 14:43:58 EST

On 16-Feb-08, at 1:19 PM, Tom Lane wrote:

> "Christian Bourque" <christian.bourque@gmail.com> writes:
>> The pg server is running on server B (openSUSE) and I'm connecting to
>> it from server C (Solaris 10) using a user account with an nfs
>> mounted
>> directory from server A (openSUSE).
>
>> If I unmount the nfs share it works! But with the share it doesn't,
>> the connection seems to reach the server but it gets stuck there, no
>> error and it doesn't timeout either...
>
> It's way too hard to believe that NFS per se is interfering.
>

seems far fetched to me too.

> What I could believe is that there is some configuration-type file in
> your home directory that is causing a problem, and after the unmount
> it's not visible so no problem. There are obvious possibilities for
> this such as ~/.psqlrc if you're using psql/libpq, but I dunno enough
> about the JDBC environment to guess whether it has equivalents.
>

There is no equivalent use in the jdbc environment.

> If all else fails, you could try strace'ing the application (or
> whatever
> Solaris' equivalent to strace is) in both cases and comparing results.
> That would at least make it clearer where it's hanging up ...
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq Received on Sat Feb 16 14:44:49 2008