Project

General

Profile

Actions

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.

Status:
Closed
Priority:
Normal
Assignee:
_InfraScience Systems Engineer
Category:
System Application
Target version:
Start date:
Mar 07, 2017
Due date:
% Done:

100%

Estimated time:
(Total: 0.00 h)
Infrastructure:
Production

Description

With the postgis extensions installed.


Subtasks 1 (0 open1 closed)

Task #7433: Activate backups for the postgresql production serverClosed_InfraScience Systems EngineerMar 07, 2017

Actions
Actions #3

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

Actions #4

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.

Actions #5

Updated by Andrea Dell'Amico over 8 years ago

  • Status changed from Feedback to Closed
  • Infrastructure deleted (Pre-Production)
Actions #6

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.

Actions #7

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.

Actions #8

Updated by Massimiliano Assante about 8 years ago

gcube-releases has been imported successfully the portlet now is able to contact the new postgres.

Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 8.91 MB)