1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • database upgrades, shoudnt they mostly be sql? not bash script?

    From polymorph self@21:1/5 to All on Thu Dec 14 08:49:06 2017
    should there be a minimum of shell scripting?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Laurenz Albe@21:1/5 to polymorph self on Mon Jan 22 07:38:01 2018
    On Thu, 14 Dec 2017 08:49:06 -0800, polymorph self wrote:
    should there be a minimum of shell scripting?

    It is just a single command (pg_upgrade).
    What more would you like?

    Before the database can even be started to execute SQL, it has
    to be upgraded, so you cannot do it all in SQL.

    Yours,
    Laurenz Albe

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)