gpdbrestore with ddboost Fails with "IOError: [Errno 2] No such file or directory: '/home/gpadmin/scripts/dboost/postgresql.conf'"
search cancel

gpdbrestore with ddboost Fails with "IOError: [Errno 2] No such file or directory: '/home/gpadmin/scripts/dboost/postgresql.conf'"

book

Article ID: 296052

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

Symptoms:
Typo in gpdbrestore command results in an unhelpful IOError:
20150917:10:04:00:533393 gpdbrestore:mdw:gpadmin-[INFO]:-Starting gpdbrestore with args: -a -t 20150917100212 -v -ddboost
20150917:10:04:00:533393 gpdbrestore:mdw:gpadmin-[DEBUG]:-Obtaining master's port from master data directory
20150917:10:04:00:533393 gpdbrestore:mdw:gpadmin-[ERROR]:-gpdbrestore failed. exiting...
Traceback (most recent call last):
 File "/usr/local/greenplum-db/lib/python/gppylib/mainUtils.py", line 279, in simple_main_locked
 commandObject = createCommandFn(options, args)
 File "/usr/local/greenplum-db/./bin/gpdbrestore", line 149, in __init__
 self.master_port = self._get_master_port(self.master_datadir)
 File "/usr/local/greenplum-db/./bin/gpdbrestore", line 333, in _get_master_port
 pgconf_dict = pgconf.readfile(datadir + "/postgresql.conf")
 File "/usr/local/greenplum-db/lib/python/gppylib/pgconf.py", line 42, in readfile
 fp = open(filename)
IOError: [Errno 2] No such file or directory: '/home/gpadmin/scripts/dboost/postgresql.conf'

Environment


Cause

The ddboost argument is specified incorrectly as "-ddboost" instead of the correct option "--ddboost".

 

Resolution

Use the correct gpdbrestore syntax:

gpdbrestore <.......> --ddboost