Postgresql password protection in a diskless environment
 

Community,

we're running Postgres 9.2 on a system that is diskless. The diskless system PXE boots and reeceives its image from a management blade.

My problem seems to be that I can't seem to password protect the database in this environment. While I can easily use the ALTER ROLE command and modify the pg_hba.conf file on the diskless server while it's running and it does work. When I reboot the management server scripts run that re-create the diskless image. When I reboot the diskless server, the pga_hba.conf still has my entry for md5 (instead of trust) but the password I've set doesn't work and I can't login to the db.


From reading about this I think that passwords are stored in a catalog called pg_authid. This doesn't seem to be a file I can copy to my scripts directory to put in place on the management server when the diskless image is rebuilt.

Just wondering if anyone has any ideas as to how to handle this problem.

Thank you.

According to this article, in a PXE connection, other forms of authentication may be in use: https://chartio.com/resources/tutori...in-postgresql/