PostgreSQL Server not starting

Here’s the output of Service Monitor Diagnostics…

PostgreSQL Server readiness check…
/tmp:7533 - no response
Authentication mode:

Local users certificates check…

:cross_mark: Certificate Authority certificate not found

Done.

Connections to server…

Any suggestions would be helpful. I probably renamed a disk or something…

I had a similar issue but I’m not sure it’s exactly the same so you need to investigate this further if you have projects you don’t want to lose.

You can only have one database either in certificate mode or in trust mode and the mode cannot be changed afterwards. If there is a conflict the certificate database must be destroyed to create a new database. You can use the following command to check which mode the database is in:

/opt/Autodesk/bin/dl_services_map -cDimet

By default, user certificates expire after 365 days and there are warning generated prior to it expiring. The certificate for a user can be refreshed with the following command that has to be run as the flame_db user:

flame_db$ ./igniter --user-refresh-cert <name(s)> [-d ] [-k ]

If you dabbled in certificate mode but then created a trust mode database, there might be a postgresql.crt file in the ~/.postgresql folder. You can simply delete the file to get rid of the warning.

I think this is over my head. Does this mean trust mode?

/opt/Autodesk/bin/dl_services_map -cDimet
Timeout waiting for DNS-SD events. Check Service Discovery diagnostic in the Service Monitor for possible resolution.
Host Display Name | ID | Metadata Addresses | Extra | Type

M4Max E46AE901-B38C-4D9C-A025-737EFF3F6008-dlmpd 192.168.1.59 dlmpd
M4Max E46AE901-B38C-4D9C-A025-737EFF3F6008-stone 192.168.1.59 auth=trust stone

Apparently I don’t have support, So I’m on my own. I uninstalled every version of flame, and reinstalled. I’m trying to make a new database manually so I can beta test. It looks all good up until I try to make a new database. Permission denied…

flame_db$ /opt/Autodesk/bin/igniter --init -a trust
initdb: error: could not create directory “/var/opt/Autodesk/pgsql/17/data”: Permission denied

Is that more of a philosophical comment on the state of Flame? Because if you have a valid license, you have support.

As an individual, I’m a beta tester without a ‘valid’ license.