Re: BASH script for collecting analyze-related info

From: Craig James <cjames(at)emolecules(dot)com>
To: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: BASH script for collecting analyze-related info
Date: 2013-09-29 23:59:05
Message-ID: CAFwQ8reQnO+3e+b8fuiMc9nTo1bXXZ6xZcyd_QD558Ja4CGGNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Sep 29, 2013 at 2:24 PM, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> wrote:

> p.s., This script runs fine on my computer (Ubuntu 13.04), but on a
>>> Fedora 11 machine it dies with
>>>
>>> pg_analyze_info.sh: line 18: unexpected EOF while looking for matching
>>> `)'
>>> pg_analyze_info.sh: line 57: syntax error: unexpected end of file
>>>
>>> If anyone knows why, or encounters a similar error and fixes it, please
>>> let me know!
>>>
>>
>> It's the blank line on line 26. Put a backslash on that line or delete
>> it entirely.
>>
>> Craig
>>
>
>
> Well that made perfect sense, but after making that change I'm still
> getting the same error.
>

Try putting the entire TABLE= on one big line and see if that works. If it
does, work backwards from there, inserting backslash-newlines. It may be
something simple like an extra space after a backslash.

Craig

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message didier 2013-09-30 06:11:05 Re: Slow plan for MAX/MIN or LIMIT 1?
Previous Message Ken Tanzer 2013-09-29 21:24:52 Re: BASH script for collecting analyze-related info