Migrate databases to postgres 9.5
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------------------------------+----------+----------+---------+---------+-----------------------
antelink | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
gitimport_20150930 | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
lister-github | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
olasd | olasd | UTF8 | C.UTF-8 | C.UTF-8 |
postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
snapshot.debian.org | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
softwareheritage | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =Tc/postgres +
| | | | | postgres=CTc/postgres+
| | | | | olasd=CTc/postgres
softwareheritage-log | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
softwareheritage-snapshot-20151001 | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
softwareheritage-snapshot-20151006 | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
softwareheritage-test-dir | olasd | UTF8 | C.UTF-8 | C.UTF-8 |
template-swh | postgres | UTF8 | C.UTF-8 | C.UTF-8 |
template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
zack | zack | UTF8 | C.UTF-8 | C.UTF-8 |
zack-swh-sample | zack | UTF8 | C.UTF-8 | C.UTF-8 |
move plan :
| database | destination | status | duration | | softwareheritage | 9.5/main | done | dump: 6h50; restore 26h04 | | softwareheritage-log | 9.5/secondary | done | 4h03 | | softwareheritage-snapshot-* | 9.5/secondary | done | 4h30 | | softwareheritage-test-dir | 9.5/secondary | done | 33m | | zack-* | 9.5/secondary | done | 12m | | olasd | 9.5/secondary | done | 7h07 | | gitimport_20150930 | 9.5/secondary | done | 42m | | antelink | 9.5/hdd | done | 1h20 | | snapshot.debian.org | 9.5/hdd | done | 31m | | lister-github | 9.5/hdd | done | 1h38 |
Migrated from T267 (view on Phabricator)
Edited by Phabricator Migration user