Re: jdbc and nfs

On 16-Feb-08, at 2:45 PM, Christian Bourque wrote:

> Hi Tom,
>
> I think you were right, there is something in the home directory that
> is conflicting!
>
> I don't understand why jdbc would use something in the user's home
> directory though...
>
> Anyway the workaround I found was to not map the share directly under
> the user's home account and now it works!
>
My guess is your classpath ?

Dave
> Thanks for your help!
>
> Christian
>
> On Feb 16, 2008 1:19 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> "Christian Bourque" <christian(dot)bourque(at)gmail(dot)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.
>>
>> 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.
>>
>> 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 5: don't forget to increase your free space map settings