admin管理员组文章数量:1023048
I have an old Ubuntu 14.04 server with an old PostgreSQL 9.6 database on it, and I was having issues with the server earlier so I power cycled it (bad idea in hindsight). It's currently running on a DigitalOcean VPS with weekly backups.
When I logged back in, I noticed that the status of the server was "down" and
root@server:/home/username# service postgresql status
9.6/main (port 5432): down
When I try starting it, I get this error:
root@server:/home/username# service postgresql start
* Starting PostgreSQL 9.6 database server
* Failed to issue method call: Unit [email protected] failed to load: No such file
or directory. See system logs and 'systemctl status [email protected]' for details.
[fail]
root@server:/home/username# systemctl status [email protected]
[email protected]
Loaded: error (Reason: No such file or directory)
Active: inactive (dead)
I've tried restoring from backups from 5, 12, 19, and 26 days ago, but I get the same error each time.
I also tried reinstalling Postgres 9.6, but it looks like the files used to update Ubuntu 14.04 are no longer hosted.
My site is well overdue for a migration, but I want to recover from this first.
I have an old Ubuntu 14.04 server with an old PostgreSQL 9.6 database on it, and I was having issues with the server earlier so I power cycled it (bad idea in hindsight). It's currently running on a DigitalOcean VPS with weekly backups.
When I logged back in, I noticed that the status of the server was "down" and
root@server:/home/username# service postgresql status
9.6/main (port 5432): down
When I try starting it, I get this error:
root@server:/home/username# service postgresql start
* Starting PostgreSQL 9.6 database server
* Failed to issue method call: Unit [email protected] failed to load: No such file
or directory. See system logs and 'systemctl status [email protected]' for details.
[fail]
root@server:/home/username# systemctl status [email protected]
[email protected]
Loaded: error (Reason: No such file or directory)
Active: inactive (dead)
I've tried restoring from backups from 5, 12, 19, and 26 days ago, but I get the same error each time.
I also tried reinstalling Postgres 9.6, but it looks like the files used to update Ubuntu 14.04 are no longer hosted.
My site is well overdue for a migration, but I want to recover from this first.
本文标签：
版权声明：本文标题：ubuntu 14.04 - A Postgres 9.6 database broke after a power cycle, and restoring with backups did not fix issue - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745590009a2157831.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论