psql problem

From: Gary Fu <gary(dot)fu(at)sigmaspace(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: psql problem
Date: 2010-07-22 21:03:29
Message-ID: i2abqb$2lne$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

System information:
- psql 8.4.4 on a client with CentOS 5.5 (64 bits)
- postgres 8.4.4 on the server with CentOS 5.5 (64 bits)
- the client is connected with vpn

I have a script to create a table with some comments in front. When I
use the command 'psql -f script.sql' to load it, it hangs. However, if
I remove the comments, OR remove some of the columns from the table, it
works okay. It looks like to me, the psql will hang with large size of
the script file. I tried 'psql < script.sql' and 'cat script.sql |
psql' with the same result.

However, I tried it on another client host (CentOS 5.5 32 bits), I don't
see this problem.

Any idea and suggestion ?

Thanks,
Gary

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Howard Rogers 2010-07-22 21:09:33 Re: Bitmask trickiness
Previous Message Scott Marlowe 2010-07-22 20:13:01 Re: Need some help on PG database transfer