pgo 4.7 pg 11: could not save history to file "/var/lib/pgsql/.psql_history": No such file or directory

[jose-joye]

I have installed pgo 4.7 and created a cluster as such:

$ pgo -n pgo-4-7-0 show cluster pgo-osb-management

cluster : pgo-osb-management (crunchy-postgres-ha:centos8-11.12-4.7.0)
	pod : pgo-osb-management-59478c7785-6pxd6 (Running) on k3d-abn-mirror-agent-1 (2/2) (primary)
		pvc: pgo-osb-management (8Gi)
	resources : CPU: 500m Memory: 1Gi
	limits : CPU: 500m Memory: 1Gi
	deployment : pgo-osb-management-backrest-shared-repo
	deployment : pgo-osb-management
	service : pgo-osb-management - ClusterIP (10.43.61.28) - Ports (9187/TCP, 2022/TCP, 5432/TCP)
	service : pgo-osb-management-test-node-port - ClusterIP (10.43.165.190) - Ports (5432/TCP)
	labels : pgo-osb-instance=5df46723-1bfd-4076-9f7b-e5cbc9acac38 space-guid=guid-d3d7bf41-200c-4261-9d52-a0c343747d4c cpu-in-milli-cpu=500 workflowid=f1402f3a-6b9a-4b56-88f4-33a418849325 pgouser=admin storage-config=storage-default memory-in-gb=1 org-guid=guid-b3156d32-a583-4a34-9224-299d90a3a557 name=pgo-osb-management pg-cluster=pgo-osb-management pgo-version=4.7.0 

If I shell into the data pod, and run psql, I will get an error when exiting:

bash-4.4$ psql
psql (11.12)
Type "help" for help.

postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.utf-8 | en_US.utf-8 | 
 template0 | postgres | UTF8     | en_US.utf-8 | en_US.utf-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf-8 | en_US.utf-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 userdb    | postgres | UTF8     | en_US.utf-8 | en_US.utf-8 | =Tc/postgres         +
           |          |          |             |             | postgres=CTc/postgres+
           |          |          |             |             | testuser=CTc/postgres
(4 rows)

postgres=# exit
could not save history to file "/var/lib/pgsql/.psql_history": No such file or directory
bash-4.4$ 

Thanks,
José

[jkatz]

Thanks. This is a result of running in readOnlyRootFilesystem mode. We will fix this.

[MilanSavaliya]

is there any update on this one @jkatz ?

[jg-navas]

Interested in this issue. In my case, I have deployed PGO v5.3.0 on Openshift 4.10, and the error message reads

could not save history to file "//.psql_history": No such file or directory

but essentially it is the same issue.