Running postgres 9.4.4 on a SLES11 SP4 Machine.
I'm rsyncing an entire machine over the Internet to create a copy of the operating system and when I try running postgres (the service starts). I stoped the postgresql service before running rsync.
Logging in to my database (that works on the machine I rsynced from), I get
$ psql -U [my_username] [my_database]
psql: FATAL: cache lookup failed for relation 1259
Searching here and there shows me lots of info for this error, but most of them appear to be for people who can actually log in to their database.
I can log in as the postgres user, but I don't think that user can fix it.
I've tried rsyncing again, in case something was lost in translation, and got exactly the same error. So something must be gummed up. I've rebooted, restarted postgresql. Ran vacuum (as postgres, probably doesn't touch the busted relation).
I'll probably have to go hack on the config files to give the postgres user access to the tables, but short of that, are there any ways I can fix this. I really only need the schema to survive the rsync, the data can (and will) get blown away and repopulated by another machine.