gpcrondump
, the backup finishes on all segments but not on the master.20181007:01:00:12:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Starting gpcrondump with args: -x maindb -c -g -G -a -q -r --cleanup-total=1 20181007:01:02:17:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Directory /data/master/gpseg-1/db_dumps/20181007 not found, will try to create 20181007:01:02:17:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Created /data/master/gpseg-1/db_dumps/20181007 20181007:01:02:17:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Checked /data/master/gpseg-1 on master 20181007:01:02:21:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Configuring for single-database, include-table dump 20181007:01:02:23:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Validating disk space 20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Creating filter file: /data/master/gpseg-1/db_dumps/20181007/gp_dump_20181007010025_table 20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Adding compression parameter 20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Adding --no-expand-children 20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Dump process command line gp_dump -p 5432 -U gpadmin --gp-d=db_dumps/20181007 --gp-r=/data/master/gpseg-1/db_dumps/20181007 --gp-s=p --gp-k=20181007010025 --no-lock --gp-c --no-expand-children "maindb" --schema-file=/tmp/schema_list6kHOSd 20181007:01:07:48:001025 gpcrondump:bdtbasr1n7:gpadmin-[INFO]:-Starting Dump process
2018-10-07 01:07:54.625740 BST,"gpadmin","maindb",p10644,th1164502816,"169.25.79.22","4456",2018-10-07 01:07:54 BST,76750635,con1101913,,seg-1,,,x76750635,sx1,"FATAL","28000","no pg_hba.conf entry for host ""169.25.79.22"", user ""gpadmin"", database ""maindb"", SSL on",,,,,,,0,,"auth.c",608,
pg_hba.conf
file for gpadmin. Run the command,
gpstop -u
to reload the access list and test it by running a backup.