There is no problem with using a bash script. Is the crontab useful for those who have multiple DBs in a cluster?
I thought it would be easier to manage in DB for ease of management. Before using the bash script option, I wanted to confirm whether this is possible on the DB.
The result is when I run the function; "Reindex concurrently cannot run inside a transaction block. "
Of course, it works as follows, but in my building, I taken the scripts same like as follows but when I run this in function, I got the error message.
REINDEXINDEXCONCURRENTLY"players_id_idx";
commit;
REINDEXINDEXCONCURRENTLY"players_about_idx";
commit;
According to my research, the only way to do this is to write a bash script in Linux and insert it with the loop. But since I want to manage this in the database system, I wanted to ask here.
What's wrong with a bash script run from cron? (You should see my crontab; it's ginormous, running scripts against databases on 8 different servers.)