You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There've always been issues with our Postgres class that is used in verdi quicksetup to try and "autodetect" how to:
connect to an existing postgres cluster as the postgres superuser
create a database user newuser (no special rights, in particular no rights to create databases)
create a database owned by newuser
This task simply depends a lot on the operating system and the particular setup encountered, so the only way I can see to make real progress here is to extract this part out of AiiDA and test it on
multiple operating systems
multiple ways of setting up postgres (e.g. apt, docker, conda, ...)
(potentially) multiple postgres versions (if there are differences)
I've already prepared the stage for this by creating an azure pipeline for pgtest, which has a similar but still significantly different purpose.
The pipeline runs pgtest on windows, macos and ubuntu and I expect it to work quite similarly for this purpose.
The text was updated successfully, but these errors were encountered:
I've started this here, which has already helped significantly with figuring out the core of what we are actually trying to achieve here.
There are still some things to be fixed in the azure pipeline and I'm not yet entirely sure whether the current name (pgsu) & API are the one we want to keep for making this an official package.
So, in the meanwhile, I'll copy the updated code back into aiida-core, hopefully providing a fix for #2836 in time for the tutorial.
There've always been issues with our
Postgres
class that is used inverdi quicksetup
to try and "autodetect" how to:postgres
superusernewuser
(no special rights, in particular no rights to create databases)newuser
This task simply depends a lot on the operating system and the particular setup encountered, so the only way I can see to make real progress here is to extract this part out of AiiDA and test it on
I've already prepared the stage for this by creating an azure pipeline for
pgtest
, which has a similar but still significantly different purpose.The pipeline runs pgtest on windows, macos and ubuntu and I expect it to work quite similarly for this purpose.
The text was updated successfully, but these errors were encountered: