VCD Cell deployment fails with error : 'could not open file "./postgresql.conf-bak": Permission denied'
search cancel

VCD Cell deployment fails with error : 'could not open file "./postgresql.conf-bak": Permission denied'

book

Article ID: 369753

calendar_today

Updated On:

Products

VMware Cloud Director

Issue/Introduction

VCD  Standby cell deployment fails with error  'could not open file "./postgresql.conf-bak": Permission denied'

VCD cell fails to configure with exception : 'could not get COPY data stream: ERROR:  could not open file "./postgresql.conf-bak": Permission denied' 

/opt/vmware/var/log/vcd/configure-vcd.log indicates below

Jun 05 03:49:47 hostname.example.com systemd[1]: vpostgres.service: Control process exited, code=exited status=1
Jun 05 03:49:47 hostname.example.com systemd[1]: vpostgres.service: Failed with result 'exit-code'.
Jun 05 03:49:47 hostname.example.com systemd[1]: Failed to start VMware Postgres database server.
Creating repmgr standby configuration.
2024-06-05 10:12:56 | setup-repmgr-standby.sh | Creating repmgr standby configuration.
2024-06-05 10:12:56 | configure-repmgr.sh | Creating repmgr-node-id
2024-06-05 10:12:56 | configure-repmgr.sh | Writing /opt/vmware/vpostgres/current/etc/repmgr.conf
Cloning primary database (100.xx.xx.xxx) to standby using repmgr. This may take a long time, depending on database size.
2024-06-05 10:12:56 | setup-repmgr-standby.sh | Cloning primary database (100.xx.xx.xx) to standby using repmgr. This may take a long time, depending on database size.
NOTICE: destination directory "/var/vmware/vpostgres/current/pgdata" provided
INFO: connecting to source node
DETAIL: connection string is: user=repmgr host=100.xx.xx.xx gssencmode=disable
DETAIL: current installation size is 51 GB

Environment

vCloud Director 10.x

Cause

This file '/postgresql.conf-bak' exists in location /var/vmware/vpostgres/14/pgdata/ and while cloning primary the database, its errors out with : 'Permission denied' error stack

 

Resolution

  • The file '/postgresql.conf-bak' exists in location : /var/vmware/vpostgres/14/pgdata/
  • Move the file to tmp directory
    • cd /var/vmware/vpostgres/14/pgdata/
    • mv postgresql.conf-bak  /tmp
  • Re-initiate standby cell deployment 
Powered by Wolken Software