Task #7427
closed
Add a general purpose postgresql server to collect the production databases
Added by Andrea Dell'Amico over 8 years ago.
Updated about 8 years ago.
Assignee:
_InfraScience Systems Engineer
Category:
System Application
Estimated time:
(Total: 0.00 h)
Infrastructure:
Production
Description
With the postgis extensions installed.
- Status changed from New to In Progress
Address and IP: postgresql-srv.d4science.org 146.48.123.31
- Status changed from In Progress to Feedback
- % Done changed from 0 to 100
- Infrastructure Pre-Production added
The VM is ready. We should migrate there all the postgres 9.x db instances used in production but the portal ones
The database creation will be ansible provisioned until the service of #7429 will be ready.
- Status changed from Feedback to Closed
- Infrastructure deleted (
Pre-Production)
I need to port the current DB hosted on dev.d4science.org:5432/gcube-releases in this general purpose postgresql server. How can I do this? In general a Dump and a restore in the new server is sufficient as the content isn't changing soon. The infra-gateway cluster should be able to contact this DB.
gcube-releases has been imported.
Let's open a new ticket with the list of the to-be-moved databases.
gcube-releases has been imported successfully the portlet now is able to contact the new postgres.
Also available in: Atom
PDF