Re: psql: FATAL: the database system is starting up

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(dot)klaver(at)aklaver(dot)com