Obtaining a dump file for the Shared Services database (PostgreSQL) in the SAS® 9.4 Web Infrastructure Platform Data Server


This article explains how to capture a dump file (for both UNIX and Microsoft Windows operating environments) for the Shared Services PostgreSQL database in SAS 9.4 Web Infrastructure Platform Data Server.

Under UNIX

    1. Using your SAS installation ID, log on to the machine where SAS 9.4 Web Infrastructure Platform Data Server is configured.

 

       2. Open a terminal session for UNIX operating environments and submit the following commands:

POSTGRES_HOME=SASHOME/SASWebInfrastructurePlatformDataServer/9.4 export PATH=${POSTGRES_HOME}/bin:$PATH export LD_LIBRARY_PATH=${POSTGRES_HOME}/lib:$LD_LIBRARY_PATH

          In the HOME= path shown above, replace SASHOME with the actual path for the SAS home directory in your environment.
          Note: In the AIX operating environment, the parameter for the library path is LIBPATH rather than LD_LIBRARY_PATH.

 

       3. Change to the SASHOME/SASWebInfrastructurePlatformDataServer/9.4/bin folder or directory.

 

       4. Submit the following command in SASHOME/SASWebInfrastructurePlatformDataServer/9.4/bin to obtain a complete Shared Services database dump file.

pg_dump -f "SharedServices.backup" -p 9432 -U dbmsowner SharedServices

 

Under Windows

    1. Using your SAS installation ID, log on to the machine where SAS 9.4 Web Infrastructure Platform Data Server is configured.

 

      2. Open a Windows command prompt and submit the following commands:

set POSTGRES_HOME=SASHOME\SASWebInfrastructurePlatformDataServer\9.4
set PATH=%POSTGRES_HOME%/bin:%PATH%
set LIBPATH=%POSTGRES_HOME%/lib

In the HOME= path shown above, replace SASHOME with the actual path for the SAS home directory in your environment.

 

      3. Change to the SASHOME\SASWebInfrastructurePlatformDataServer\9.4\bin folder or directory.

 

      4. Submit the following command in SASHOME\SASWebInfrastructurePlatformDataServer\9.4\bin to obtain a complete Shared Services database dump file.

pg_dump -f "SharedServices.backup" -p 9432 -U dbmsowner SharedServices