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.klaver@aklaver.com