Re: psql problem - Mailing list pgsql-general

From Ireneusz Pluta
Subject Re: psql problem
Date
Msg-id 4C4BD2A7.3060806@wp.pl
Whole thread Raw
In response to psql problem  (Gary Fu <gary.fu@sigmaspace.com>)
List pgsql-general
Gary Fu pisze:
>
> 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.
>
you may eventually track the progress more verbosely with -a switch to
psql and this way isolate the part where it hangs

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Question about SCO openserver and postgres...
Next
From: "Michael A. Peters"
Date:
Subject: Re: pg_dump, shemas, backup strategy