Task #7427
closed
Add a general purpose postgresql server to collect the production databases
100%
Description
With the postgis extensions installed.
Updated by Andrea Dell'Amico over 8 years ago
- Status changed from New to In Progress
Address and IP: postgresql-srv.d4science.org 146.48.123.31
Updated by Andrea Dell'Amico over 8 years ago
- 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.
Updated by Andrea Dell'Amico over 8 years ago
- Status changed from Feedback to Closed
- Infrastructure deleted (
Pre-Production)
Updated by Massimiliano Assante about 8 years ago
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.
Updated by Andrea Dell'Amico about 8 years ago
gcube-releases has been imported.
Let's open a new ticket with the list of the to-be-moved databases.
Updated by Massimiliano Assante about 8 years ago
gcube-releases has been imported successfully the portlet now is able to contact the new postgres.