Hi @Jneubert, can you please elaborate what do you want the postgresql database for?

Is it just to process the dump?
Or do you want a standing instance to have the database running all the time?

(the solution to both things might be different)

Hi @dcaro , sorry for the late respose - I was some days off and missed the notification.

The request is about a standing instance, to be shared among at least two persons. It would have two key uses, firstly, to mint identifiers for new PM20 folders (wdt:P4293), and secondly, to add local information (in particular, holdings information which is not well suited to Wikidata). ZBW, the collections owner, has discontinued the maintenance of the database, but is willing to accept metadata to extend access to the collection.

The addition of data would be ongoing work, so there is no termination date.

Hope this helps, otherwise do hestitate to ask for further clarification.

Thanks, good to know.

Given that, there's two possible ways to go forward:

• Creating your own database in a VM on CloudVPS:
  • You have full control (for good and bad, ex. upgrades/maintenance)
  • Would be pretty stable

• Using Trove database on CloudVPS:
  • The DB is half-managed (you get a database with "just one click")
  • Postgresql is not very well supported (no automated backups or replication, OOMs under load, ...)

Note that currently both require the creation of a CloudVPS project, the difference is creating your own VM with postgres, or letting Trove do it for you.

We can create the project and let you try both if you want, I'll need a name for the project though (ex. pm20database).

That sounds great! Project name "pm20database" would be fine.

I'd try a Trove instance first, and hope that backups are possible via pgadmin. Load will be low, so I don't suppose OOMs would occur. But of course, I have zero experience in the setting, so it is good to know there is the VM option.

Thanks, @Andrew ! I was able to log into Horizon, but I see no "Launch Instance" button:

Apparently, I also do not have access to the project:

It is the first time that I deal with the Openstack environmet - please forgive if I miss something obvious.

In T359785#9656678, @Jneubert wrote:

Ok, figured it out: Had to switch from "bastion" to "pm20database" project ...

That fits -- you only have read-only access to 'bastion' but should be able to do whatever in pm20database. Be warned that most horizon features don't work with postgres (it's largely tested/designed to support mysql). You'll be able to create the database but then you'll need to inject a root user and manage it via psql after that.