Online Documentation for SQL Management Studio for PostgreSQL

Product Installation

If you are installing SQL Studio for the first time on your PC:

• download the SQL Studio distribution package from the download page available at our site;
• unzip the downloaded file to any local directory, e.g. C:\unzipped;
• run pgstudio.msi from the local directory and follow the instructions of the installation wizard;
• after the installation process is completed, find the SQL Studio shortcut in the corresponding group of Windows Start menu.

If you want to upgrade an installed copy of SQL Studio to the latest version:

• download the SQL Studio distribution package from the download page available at our site;
• unzip the downloaded file to any local directory, e.g. C:\unzipped;
• close SQL Studio application if it is running;
• run pgstudio.msi from the local directory and follow the instructions of the installation wizard.

During the installation process you will be offered to select either to run SQL Studio as an application or a service.

Installed as a service, SQL Studio will run independently of the user account currently logged in and will use the Windows user account User name and Password specified during the installation process.

Note: Use DOMAIN_NAME\USER_NAME format to specify a domain user account.

Please note that the service should be run under the Windows user account the SQL Management Studio for PostgreSQL application will be used.

In order to install the program in the silent mode as an application you should execute the following command:

msiexec.exe /i /quiet xxstudio.msi

In order to install the program in the silent mode as a service execute the following command:

msiexec.exe /i /quiet xxstudio.msi SERVICE_INSTALL=1 SERVICE_USERNAME="computer_name\user_name" SERVICE_PASSWORD="password"

Please remember that the User account must be defined with the domain name or the computer name, as it is shown in the example above. You can use the ".\user_name" format as well.