On 6/1/19 3:14 PM, Tom K wrote:
>
>
> ** Correction. There is postgres, template1 and template2 but none of
> the other databases we had.
In a psql session do:
select oid, datname from pg_database ;
Then go to /data/patroni an drill down to the base directory. In that
directory there should be sub-directories with numbers equal to the oid
values from the query. If not then something is wrong. That could be:
1) Wrong data directory.
2) Copied over incorrect data directory.
Basically if the only sub-directories are for the system databases then
the user databases do not exist. You might want to look at some of the
other clusters to see what is there.
--
Adrian Klaver
adrian.klaver@aklaver.com