Forum OpenACS Q&A: Re: Backup and Restore of Postgresql

Collapse
Posted by Steve Manning on
Dave

That would explain it then because 2 of our installations are still 7.3. Perhaps the restore instructions could say that the problem only applies to <=7.3.

I wish I hadn't bothered mentioning it now 🤔

Russell

Thats true - by default we add it to template1 during the installation process. That makes sense because any new DB's we create are by default off template1 so they include plpgsql which is what we want.

However, when importing a dump which includes the plpgsql_call_handler function we don't want the lang in the new db so we use template0.

- Steve