andyatkinson/pg_scripts

Does `administration/tail_log.sh` not work with paths containing spaces?

Closed this issue · 1 comments

I installed Postgres on macOS with the Postgres.app as described in "High Performance PostgreSQL for Rails". This means it's installed at .../Library/Application Support/Postgres/var-16 (which contains a space). The administration/tail_log.sh script isn't working; could that be the cause?

Hi @nigel-lowry Thanks! I've found I need to either backslash escape the space, or surround the whole path in double quotes.

This script runs for me like:

sh tail_log.sh

SHOW data_directory: /Users/andy/Library/Application Support/Postgres/var-16
SELECT pg_current_logfile(): log/postgresql-2024-08-28_113704.log

Either of these:

vim "/Users/andy/Library/Application Support/Postgres/var-16/postgresql.conf"

vim /Users/andy/Library/Application\ Support/Postgres/var-16/postgresql.conf

Hope that helps!