search

SasView / sasmodel-marketplace

A website for sharing custom sasmodel files
1 stars 2 forks source link

Move away from postgress for the markeplace (Trac #774) #6

Closed butlerpd closed 1 year ago

butlerpd commented 5 years ago

Eventually would like to move to SQ light for as many databases as we can for easier backups -- currently using mySQL for most and postgress for the marketplace. This is a long term planning ticket at this point.

Migrated from http://trac.sasview.org/ticket/774

{
    "status": "new",
    "changetime": "2017-09-06T13:16:33",
    "_ts": "2017-09-06 13:16:33.305613+00:00",
    "description": "Eventually would like to move to SQ light for as many databases as we can for easier backups -- currently using mySQL for most and postgress for the marketplace.  This is a long term planning ticket at this point.",
    "reporter": "butler",
    "cc": "",
    "resolution": "",
    "workpackage": "SasModels Marketplace",
    "time": "2016-10-11T14:09:55",
    "component": "sasmodels Markeplace",
    "summary": "Move away from postgress for the markeplace",
    "priority": "minor",
    "keywords": "",
    "milestone": "Admin Tasks",
    "owner": "",
    "type": "defect"
}
sasview-bot commented 5 years ago

Trac update at 2017/09/06 13:16:33:

Backing up postgres is (in theory) as simple as running pg_dump -Fc marketplace > backup.db. The backup can then be restored if necessary with pg_restore -d marketplace backup.db

See https://www.postgresql.org/docs/9.1/static/backup.html for more info