No prompt, seems to be using .pgpass without a problem.
On Tue, Mar 27, 2012 at 1:59 PM, Raymond O'Donnell 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 cl
All -
Thanks for the prompt responses. I've actually narrowed it down a bit
and it seems that something earlier (specifically, the for loop that
assembles $ADDITIONAL_CREATION_FIELDS and
$ADDITIONAL_SELECTION_FIELDS) in the script is causing Bash to write
extremely slowly (if I subset the query o
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 th
On 03/27/2012 11:37 AM, W. David Jarvis wrote:
Hello all -
I've been trying to get a bash script...but when I run the script the SELECT
query runs indefinitely.
...
# Create a bunch of indexes
echo -n "Creating table indexes for faster querying..."
psql mta-join< $OUTPUT_FILE
Some things to
run the script with bash -v or
-vvv for extra detailed vebose logging.
see whats wrong, most of the times a
matter using the right closure of the statements with ' or "
Henk Bronk
On 27 mrt. 2012, at 20:37, "W. David Jarvis" wrote:
> Hello all -
>
> I've been trying to get a bash script s
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 sur