I’ve been trying and failing to setup users and run some scripts in an automated fashion against a postgres instance. I’ve done ARM templating from Azure to setup the instance, and Azure CLI in the same step to setup the databases, but now I need to run .sql files to setup users, passwords, and run some schema generation against a few of the DBs.
I’m struggling big time. Azure CLI doesn’t do these sorts of things, and whenever I try to use
psql insert-commands-and-connection-info, it fails out, claiming that “The term ‘psql.exe’ is not recognized as the name of a cmdlet, function, script file, or operable program.” (despite psql.exe being accessible from the system PATH, and me being able to run psql commands in Powershell on the actual Octopus server host machine).
My google-fu fails me too, as Google just redirects me to information about setting up the actual instance in Azure, or just running PSQL commands from an interactive CLI. Is what I’m attempting to do at all possible? I can’t be the first to try this!
Thanks in advance,