企业官网建设流程全解析

手机网站图片优化,海北北京网站建设,黄岩做网站,云优化seo软件1. 参考 Backing up your OpenProject installationRestoring an OpenProject backupLinux安装OpenProject 2. 环境 Docker compose部署的OpenProject服务服务器192.168.7.28 作为主服务器#xff0c;预装OpenProject服务#xff0c;提供生产环境服务器192.168.15.96 作为…1. 参考Backing up your OpenProject installationRestoring an OpenProject backupLinux安装OpenProject2. 环境Docker compose部署的OpenProject服务服务器192.168.7.28 作为主服务器预装OpenProject服务提供生产环境服务器192.168.15.96 作为备份服务器预装OpenProject服务作为备份环境3. 流程服务器192.168.7.28 备份OpenProject服务的Postgresql数据库服务器192.168.15.96使用rsync命令同步OpenProject服务的配置文件docker-compose.yml、存储文件assets、Postgresql数据库备份文件服务器192.168.15.96恢复Postgresql数据库备份文件4. 备份Postgresql数据库dockerexecopenproject-db-1 pg_dump -U postgres -d openproject --insert/public/postgresql/pgsqlbackup/pgsql_openproject.sqlopenproject-db-1posgresql的容器名称-U postgres连接数据库账号-d openproject 备份数据库名称–insert 生成insert语句的备份文件“/public/postgresql/pgsqlbackup/pgsql_openproject.sql” 备份文件存储路径5. 恢复备份文件5.1 服务器192.168.15.96同步备份文件同步主服务器192.168.7.28下OpenProject目录排除postgresql数据库目录/bin/rsync -avz --exclude/postgresql/--delete-after root192.168.7.28:873/public/application/openproject/ /public/application/openproject/同步主服务器192.168.7.28下OpenProject的数据库备份文件/bin/rsync -avz --delete-after root192.168.7.28:873/public/postgresql/pgsqlbackup/pgsql_openproject.sql /public/postgresql/pgsqlbackup/5.2 服务器192.168.15.96恢复数据库备份定义环境变量# 定义备份数据库名字DBNAMEopenproject# 定义postgresql容器名称CONTAINER_NAMEopenproject-db-1# 定义docker-compose.yml文件位置停止openproject服务需要使用DOCKER_COMPOSE_YML/public/application/openproject/docker-compose.yml# 需要预先停止的docker compose 服务SERVICE_NAMEweb worker停止openproject项目的web worker,删除数据库# 停止openproject项目的web worker,删除数据库docker compose -f${DOCKER_COMPOSE_YML}kill${SERVICE_NAME}\dockerexec${CONTAINER_NAME}psql -U postgres -cDROP DATABASE IF EXISTS${DBNAME};重建openproject数据库# 重建openproject数据库dockerexec${CONTAINER_NAME}psql -U postgres -cCREATE USER openproject;dockerexec${CONTAINER_NAME}psql -U postgres -cCREATE DATABASE openproject OWNER${DBNAME};导入数据库备份初始化数据库重启web、work服务# 导入数据库备份初始化数据库重启web、work服务dockerexec-i${CONTAINER_NAME}psql -U postgres -d${DBNAME}/public/postgresql/pgsqlbackup/pgsql_openproject.sql\docker compose -f${DOCKER_COMPOSE_YML}start seeder\docker compose -f${DOCKER_COMPOSE_YML}start${SERVICE_NAME}6. 检查服务状态cd/public/application/openproject/\docker composepsNAME IMAGE COMMAND SERVICE CREATED STATUS PORTS openproject-autoheal-1 willfarrell/autoheal:1.2.0/docker-entrypoint …autoheal About an hour ago Up About an hour(healthy)openproject-cache-1 memcacheddocker-entrypoint.s…cache About an hour ago Up About an hour11211/tcp openproject-cron-1 openproject/openproject:16-slim./docker/prod/entry…cronAbout an hour ago Up About an hour8080/tcp openproject-db-1 postgres:17docker-entrypoint.s…db About an hour ago Up About an hour5432/tcp openproject-proxy-1 openproject/proxycaddy run --config …proxy About an hour ago Up About an hour443/tcp,2019/tcp,443/udp,0.0.0.0:8899-80/tcp,[::]:8899-80/tcp openproject-web-1 openproject/openproject:16-slim./docker/prod/entry…web About an hour ago Up About an hour(healthy)8080/tcp openproject-worker-1 openproject/openproject:16-slim./docker/prod/entry…worker About an hour ago Up About an hour8080/tcp6. 补充说明上述命令为简化示例可以编写成Shell脚本定时执行实现定时备份自动恢复的功能