]OT] Parsing postgresql.conf archive_command

On Oct 3, 2008, at 6:05 AM, Joey K. wrote:

Hello,

I'd like to get the path configured for archive_command in a shell
script

I've used a file with following content as an example
(postgresql.conf),

# archive_command = cp %p /backup/%r
# archive_command = cp %p /backup/%r
# archive_command = cp %p /backup/%r
#archive_command = cp %p /backup/%r
archive_command = 'cp %p /backup/wal/%f'

This is what I been trying.
$ awk '!/[ \t]*#/ { sub(/%f$/, "", $NF); print $NF }' postgresql.conf

and I get
/backup/wal/%f'

Any idea how to get rid of "%f'" so that I get only?
/backup/wal/

My regexp skills are sad :-)

I usually prefer to string together more simple command than to
compress it into one awkward command:

dirname `grep -E '^archive_command' postgresqlc.conf | awk '{print
$NF}' | awk -F\' '{print $1}'`

dirname will directory component of a path (dirname /backup/wal/%f => /
backup/wal)

So, that's dirname on the results of grepping for the line that starts
with archive_command piped through a basic awk (split on spaces)
printing the last filed piped through an awk splitting on a single
quote printing the first field.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
(415) 963-4410 x 260
Location: US/Pacific
IRC: mage2k