"FATAL: sorry, too many clients already" message when using the SQL Server PI migration tool (4228804)

"FATAL: sorry, too many clients already" message when connecting to the Infobright PI repository using the SQL Server PI migration tool 

Restart the Infobright SQL PI repository database

IN LINUX/UNIX 

1. Log into the server where the Infobright database is located using a SSH command line
   
2. Navigate to the Infobright\ folder
3. Edit the "infobright-stop.ksh" file and add "–m fast" flag to the command line, then save the file. * This is the recommended shutdown process. Please give this a minute or two to complete. *
4. Run the infobright-stop.ksh file
5. Navigate to pg_data\ directory
6. Delete any files with a .pid extension from the directory
7. Navigate back up one level to the Infobright\ directory
8. Run the infobright-start.ksh file
9. Then attempt to reconnect again using the SQL PI migration tool

Note: the user running the infobright process should have read, write, and execute permissions to the Infobright directory and its subdirectories.

IN WINDOWS 

1. Log into the server where the Infobright database is located using a RDP sessions
   
2. Open a command line with Administrator access
3. Navigate to the Infobright\ folder
4. Edit the "infobright-stop.bat" file and add "–m fast" flag to the command line, then save the file. * This is the recommended shutdown process. Please give this a minute or two to complete. *
5. Run the infobright-stop.bat file
6. Navigate to pg_data\ directory
7. Delete any files with a .pid extension from the directory
8. Navigate back up one level to the Infobright\ directory
9. Run the infobright-start.bat file
10. Then attempt to reconnect again using the SQL PI migration tool

NOTE: the user logged in using the RDP session should have FULL CONTROL to the Infobright directory and its subdirectories.