No prompt, seems to be using .pgpass without a problem. On Tue, Mar 27, 2012 at 1:59 PM, Raymond O'Donnell <rod@xxxxxx> 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@xxxxxx -- W. David Jarvis M: 203.918.2328 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
