From: | "W(dot) David Jarvis" <william(dot)d(dot)jarvis(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Valid query times out when run from bash script |
Date: | 2012-03-27 21:05:15 |
Message-ID: | CAFMAO9xM0uHz9FB-3+wag+=sosey_qtHxfgB2ZswHJ-TM+pzDg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
No prompt, seems to be using .pgpass without a problem.
On Tue, Mar 27, 2012 at 1:59 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> On 27/03/2012 19:37, W. David Jarvis wrote:
>> Hello all -
>>
>> I've been trying to get a bash script set-up that creates a DB, does a
>> join, writes the join to file, and then cleans itself up afterwards.
>> Everything within the script runs fine when entered at an actual
>> prompt, but when I run the script the SELECT query runs indefinitely.
>> I'm not sure what the cause is—the script is being run on a box
>> connecting to its own local postgres installation, so it can't be a
>> connection issue. Any thoughts?
>
> Only a guess, but would the createdb line, or indeed any of the psql
> invocations, be prompting for a password? - That would cause the script
> to hang indefinitely.
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod(at)iol(dot)ie
--
W. David Jarvis
M: 203.918.2328
From | Date | Subject | |
---|---|---|---|
Next Message | leaf_yxj | 2012-03-28 00:48:05 | Re: postgresql commit. |
Previous Message | Raymond O'Donnell | 2012-03-27 20:59:54 | Re: Valid query times out when run from bash script |