Backups

Moderator: NorbertKrupa

Post Reply
binface
Newbie
Newbie
Posts: 13
Joined: Fri Jun 15, 2012 2:40 pm

Backups

Post by binface » Wed Jun 27, 2012 8:58 am

Hi,

I am trying to create a backup config file as following but getting an error :


/opt/vertica/bin]$ ./vbr.py --setupconfig
Snapshot name (backup_snapshot):
Backup vertica configurations? (n) [y/n]: y
Number of restore points (1):
Specify objects (no default): yes
Vertica user name (vertica): DataStore
Save password to avoid runtime prompt? (n) [y/n]: y
Password to save in vbr config file (no default):
Node v_datastore_node0001
Backup host name (no default): v_datastore_node0005
Backup directory (no default): /vert_backups/backups
Node v_datastore_node0002
Backup host name (no default): v_datastore_node0006
Backup directory (no default): /vert_backups/backups
Node v_datastore_node0003
Backup host name (no default): v_datastore_node0007
Backup directory (no default): /vert_backups/backups
Node v_datastore_node0004
Backup host name (no default): v_datastore_node0008
Backup directory (no default): /vert_backups/backups
Config file name (backup_snapshot.ini):
Change advanced settings? (n) [y/n]: n
Traceback (most recent call last):
File "./vbr.py", line 2232, in <module>
work()
File "./vbr.py", line 2125, in work
setupConfig()
File "./vbr.py", line 376, in setupConfig
with open(configFileName, 'wb') as configfile:
IOError: [Errno 13] Permission denied: 'backup_snapshot.ini'


Any ideas?

Cheers

Rob.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Backups

Post by id10t » Wed Jun 27, 2012 10:03 am

Snapshot name (backup_snapshot):
Define full name for snapshot, i.e. add full path to name, otherwise it will try to create INI file in current directory (/opt/vertica/bin) and you have no permissions.

Code: Select all

$ ./vbr.py  --setupconfig
Snapshot name (backup_snapshot): /tmp/back
Backup vertica configurations? (n) [y/n]: y
Number of restore points (1): 1
Specify objects (no default): 
Vertica user name (dbadmin): dbadmin
Save password to avoid runtime prompt? (n) [y/n]: n
Node v_supportspacedb_node0001
Backup host name (no default): localhost
Backup directory (no default): /tmp
Config file name (/tmp/back.ini): 
Change advanced settings? (n) [y/n]: n
Saved vbr configuration to /tmp/back.ini.

Post Reply

Return to “Vertica Database Administration”