Re: Valid query times out when run from bash script

No prompt, seems to be using .pgpass without a problem.

On Tue, Mar 27, 2012 at 1:59 PM, Raymond O'Donnell <rod@iol.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@iol.ie



--
W. David Jarvis
M: 203.918.2328