All postgres 9.3 databases disappeared after update
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postgresql-9.3 (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
All my postgres databases disappeared after doing an update (after a long time away from that particular machine).
I first noticed something was off when my Trac installation couldn't connect tot he database. Then I found out the database port changed from 5432 to 5433 (I didn't touch the config file before - so this somehow had to happen automatically). When I changed the connection port, it still didn't work, so I tried to login using the postgres user to look what's the problem, and found out ALL DATABASES WERE MISSING.
One of these databases contained some important data - any ideas what could have happened, and whether it is possible to find the missing files somewhere?
System info:
vyskocil@infinity: ~ $ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04.3 LTS
Release: 14.04
Codename: trusty
vyskocil@infinity: ~ $ uname -a
Linux infinity 3.13.0-61-generic #100-Ubuntu SMP Wed Jul 29 11:21:34 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
postgres@
psql (PostgreSQL) 9.3.9