Pivotal Knowledge Base

Follow

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

Problem

  • 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'

Cause

The ddboost argument is specified incorrectly as

-ddboost

Instead of the correct option

--ddboost

Resolution

Use the correct gpdbrestore syntax

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

Comments

Powered by Zendesk