Opened 2 years ago

Last modified 17 months ago

#774 new defect

Move away from postgress for the markeplace

Reported by: butler Owned by:
Priority: minor Milestone: Admin Tasks
Component: sasmodels Markeplace Keywords:
Cc: Work Package: SasModels Marketplace

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.

Change History (1)

comment:1 Changed 17 months ago by lewis

  • Work Package changed from SasView QA and testing to SasModels Marketplace

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

Note: See TracTickets for help on using tickets.