On 07/27/2010 10:20 PM, Tom Lane wrote:
Gary Fu<gary.fu@xxxxxxxxxxxxxx> writes:
Below is an example that I created. It works okay, but when I add any
character in the comment or in the table definition, it fails (hangs).
I checked the server process (with ps command), and I can see that
connection is 'idle'. By the way, the size 1484 may not mean anything,
since I tried another case (with different comment and table) and the
problem still happens but the size 1484 is not the break point.
I think this may be CentOS(64 bits)/ssh related, since I don't have the
problem with CentOS(32 bits) and we have the same application to install
the tables with the same command on mandriva.
FWIW, I cannot reproduce this problem using 8.4.latest on Fedora 13 64bit.
So it might indeed be something specific to the openssl version you're
using. I assume you tested that the problem goes away if you use a
non-SSL connection?
The openssl installation I'm testing with is
openssl-1.0.0a-1.fc13.x86_64
I don't know offhand what RHEL/CentOS 5.x are using but it's probably
quite a lot older.
regards, tom lane
Thanks for your response. Our SA said that there was a network
configuration set up incorrectly. After the 'Jumbo Frames' was enabled
on the network between the 10G and 1G hosts, the problem was gone.
Sorry, I don't know the detail about the network configuration.
Thanks,
Gary
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
