Skip to content

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
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information