Project

General

Profile

Actions

Task #7708

closed

Please move Databases of dev2.d4science.org and preprod1.d4science.org to postgresql-srv-dev.d4science.org

Added by Massimiliano Assante about 8 years ago. Updated almost 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
_InfraScience Systems Engineer
Category:
-
Start date:
Mar 23, 2017
Due date:
% Done:

100%

Estimated time:
Infrastructure:
Development, Pre-Production

Description

The following DBs:

  • dev2.d4science.org:5432/infra_dev_db (restore)
  • dev2.d4science.org:5432/survey-db-1 (in this case do not restore it)
  • quota_dev_db (restore)
  • preprod1.d4science.org:5432/infra_pre_db (restore)

And create new db

  • postgresql-srv-dev.d4science.org:5432/survey-db-pre

Please Do not shutdown the dev2 and preprod1 postgresql(s)until we have moved and verified the infra resources pointing to them


Related issues

Related to D4Science Infrastructure - Task #7426: Add a general purpose postgresql server to collect the dev and preprod databasesClosed_InfraScience Systems EngineerMar 07, 2017

Actions
Actions #1

Updated by Massimiliano Assante about 8 years ago

  • Related to Task #7426: Add a general purpose postgresql server to collect the dev and preprod databases added
Actions #2

Updated by Massimiliano Assante about 8 years ago

  • Description updated (diff)
Actions #3

Updated by Massimiliano Assante about 8 years ago

  • Status changed from New to In Progress
Actions #4

Updated by Andrea Dell'Amico about 8 years ago

  • % Done changed from 0 to 30

DBs created on postgresql-srv-dev.d4science.org.
survey-db-1 with user survey-db-u
survey-db-pre with user survey-db-pre-u

Actions #5

Updated by Andrea Dell'Amico about 8 years ago

  • % Done changed from 30 to 80

The infra databases have been moved.
quota_dev_db will be moved in the next days

Actions #6

Updated by Andrea Dell'Amico almost 8 years ago

@alessandro.pieve@isti.cnr.it let us know when we can move the quota_dev_db

Actions #7

Updated by Alessandro Pieve almost 8 years ago

ok for me is possible now

Actions #8

Updated by Andrea Dell'Amico almost 8 years ago

  • Status changed from In Progress to Feedback
  • % Done changed from 80 to 100

The quota_db_dev has been migrated.
Can we kill the postgresql instances on dev2 and preprod1?

Actions #9

Updated by Alessandro Pieve almost 8 years ago

yes you can kill the instances

Actions #10

Updated by Andrea Dell'Amico almost 8 years ago

  • Status changed from Feedback to Closed

Done.

Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 8.91 MB)