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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
