Interactive Postgres

To backup the PostgresSQL database files on Windows, follow these steps:

1. Login to the computer as the local Windows OS user emsadmin.
2. On the Windows desktop, type Command in the Search window. Select the Command Prompt Icon. Right-click on Command Prompt icon and select Run as administrator.
   
   
3. A User Account Control Prompt appears. Click the Yes button to continue.
4. The Administrator: Command Prompt appears.

   Note: Do not close the Administrator Command Prompt window until explicitly instructed to do so or when instructed to perform a reboot or restart of the server.

   
5. In the Administrator: Command Prompt window, enter the following command to navigate to the Panorama PON EMS server folder.

   C:Tellabs> cd C:TellabsPanoramaPONbbmgrserver

6. To back up the PostgresSQL database, type the following command, and press Enter.

   TellabsPanoramaPONbbmgrserver>backupems.

   Messages similar to the following are displayed.

   C:TellabsPanoramaPONbbmgrserver>cd /D C:TellabsPanoramaPONbbmgr..bbmgrserver C:TellabsPanoramaPONbbmgrserver> C:TellabsPanoramaPONbbmgr..Perlbinperl.exe C:TellabsPanoramaPONbbmgr..bbmgrserverbackuppgdb.pl Checking Platform:MSWin32 Detecting Windows Operating System. Postgres Home Is C:postgres Ems Home Is C:TellabsPanoramaPONbbmgr Enter postgres user that will perform the postgres backup[postgres]:

7. To use the default user, press Enter. Otherwise, type another user ID with DB privileges, and press Enter. The following prompt is displayed:

   Enter the postgres user password[tellabs]:

8. To accept the default password, press Enter. Otherwise, type the correct password and press Enter. The following prompt is displayed:

   Enter postgres database name/SID [EMS]:

9. To accept the default database name, press Enter. Otherwise, enter the database name being used, and press Enter. The system prompts for backup file locations:

   Where should the backup logs be stored enter full path or press enter key for default: [C:TellabsPanoramaPONbbmgrserverbackuplogs] ?

10. Press Enter to accept the default backup file location, or type another path, and press Enter. If this is the first backup on this server or if the directory does not exist for some reason, a prompt similar to the following is displayed:

    The directory C:TellabsPanoramaPONbbmgrserverbackuplogs does not exist. Create it [y]

11. Are the directory name and path correct?
    • If YES, press Enter to create the default backup file location.
    • If NO, type n and enter the correct path and directory.
    • A prompt similar to the following is displayed:

      Where should the backup logs be stored enter full path or press enter key for default: [C:TellabsPanoramaPONbbmgrserverbackuplogs] ?

      Note: It is recommended that individual folders be created within the backup files folder. Name the individual folder to reference the PON release of the backup being performed. The path would need to be entered. It could look like this: C:TellabsPanoramaPONbbmgrserverbackupfilesPON_ver_30.4

12. Press Enter to accept the default location, or type another folder name, and press Enter. If this is the first backup on this server or if the directory does not exist for some reason, a prompt similar to the following is displayed:

    The directory C:TellabsPanoramaPONbbmgrserverbackupfiles does not exist. Create it [y]

13. Is the directory name and path, correct?
    • If YES, press Enter to create the backup directory.

    • If NO, type n and enter the correct path and directory.

14. A prompt similar to the following is displayed:

    Enter the name of the backup file [201801081559.dmp].

15. Press Enter to accept the default backup filename, or type another filename, and press Enter.

    Note: The format of the default filename consists of: 4-digit year, 2-digit month, 2-digit day, 2-digit hour (24-hour clock), and 2-digit minute.

16. At this point in the backup procedure there are three possible scenarios:
    • This is the first backup of the Panorama PON EMS database for Postgres on this server. Continue with these steps.
    • This is not the first backup and the maximum number of backups has not been performed (the max_backups value has not been met). Go to Step 24.
    • The maximum number of backups has been performed (max_backups value has been reached), go to Step 21.

      Note: The number of backup files that can be maintained is dependent on the amount of available storage space on the local system and the size of the backup file set. It is advisable to perform the initial backup and then analyze the amount of space required and the amount of available free space.

17. The backup properties file, PON_BackupRestore.properties, is located at c:TellabsPanoramaPONbbmgrserver. This file can be manually edited using an ASCII text editor (such as Notepad) to change the max_backups= value.
18. The following messages and prompts are displayed:

    Folder C:/Tellabs/PanoramaPONbbmgrserver/backupfiles Is Writable. Postgres Home Is c:postgres Ems Home Is C:TellabsPanoramaPONbbmgr Backup/Restore Properties Don’t exist How many backup files would you like to keep?[15]: _

19. The default value for the maximum number of backup files to be maintained is 15. Type the number of backup files to be maintained for this installation and press Enter.
20. The following message is displayed:

    Folder C:TellabsPanoramaPONbbmgrserverbackupfiles Is Writable.

21. The following messages and prompts are displayed.
    
    If the maximum number of backup files has been met or exceeded, there are two possible choices:

• Do not delete any backups, go to Step 22.
• Delete one or more backups, go to Step 23.

  Folder C:TellabsPanoramaPONbbmgrserverbackupfiles Is Writable. Found Backup/Restore Properties. You currently have 4 valid backup files[s] Including the current backup you will exceed the maximum backup count of 4 Would you like to delete the failed backup attempts? [Y]: _

22. To keep all backups, type n, and press Enter. Go to Step 25.
23. To delete one or more backups, type y, and press Enter. The following messages and prompt are displayed.

    Enter the number of the backup to be deleted 1 201706301621.dmp 2 201707071609.dmp 3 201707141613.dmp 4 201707211617.dmp 5 cancel [1] _

24. Type the number corresponding to the backup file to be deleted and press Enter. Notice that the name of the backup file is a date and time stamp. The oldest one in this example is June 6, 2017, at 4:21 p.m. The most recent is July 21, 2017, at 4:17 p.m.
25. Continue with the backup process.

    Note: As part of the backup process, the file 20yymmddhhmmss.info is created. It gives a summary of the status of the backup. A folder named 20yymmddhhmm.11XX is also created. It contains several sub-folders that hold files with additional information about the backup. These are in the C:TellabsPanoramaPONbbmgrserverbackupfiles directory. The 20yymmddhhmm.DMP file is the backup data.

26. Messages similar to the following are displayed:

    Backup Log Directory is C:TellabsPanoramaPONbbmgrserverbackuplogs >Backing up 11XX schema version 28.0.0.6 Executing: C:postgres/bin/pg_dumpall.exe -l EMS -U postgres -f C:TellabsPanoramaPONbbmgrserverbackupfiles201504081559.dmp Postgres Backup Successful. Backing up 11XX data... Backing up 11XX anchors... C:TellabsPanoramaPONbbmgr/httpfile/certificates... The backup has completed successfully. The log file can be found in C:TellabsPanoramaPONbbmgrserverbackuplogs201504081559.explog

27. EMS is backed up.

    Note: As a final reminder, it is recommended that a copy of the Panorama PON EMS database backup be stored in a remote location so it will be available for disaster recovery. (See Disaster Recovery Procedures.) The latest backup files may not be available if not stored at a remote location. i.e. On-site backups may be destroyed by the disaster.