Re: Valid query times out when run from bash script - Mailing list pgsql-general

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