After Installing PSQL for Windows
Common Questions and Information about Removing the Software
The following topics cover common questions and steps for removing PSQL from your system:
Common Questions After Installing PSQL
This section contains information that you should read after running the installation program. The questions apply to all of the database engine products unless specific products are mentioned. If you are having problems with your installation, see
Troubleshooting After Installation, or get help online from the PSQL knowledge base at the
Actian website.
What happened to PVSW\BIN on Windows platforms?
Starting with PSQL v10, files are no longer installed to <drive:>\pvsw\bin on Windows platforms. This change came as PSQL adapted to Microsoft guidelines.
Where are the PSQL files installed?
Table
2 lists the default locations where PSQL installs the program and application data files on Windows platforms. Table
18 lists similar information under
Where Do Files Reside After Installing PSQL on Linux, macOS, and Raspbian? Table 2 PSQL Default Windows Installation Locations
Platform | File Types | Default Installation Location |
Windows (64-bit) | PSQL Application Data | <drive:>\ProgramData\Actian\PSQL\ |
Program Files (64-bit) | <drive:>\Program Files\Actian\PSQL\ |
Program Files (32-bit) | <drive:>\Program Files (x86)\Actian\PSQL\ |
Windows (32-bit) | PSQL Application Data | <drive:>\ProgramData\Actian\PSQL\ |
| Program Files | <drive:>\Program Files\Actian\PSQL\ |
Note: The DOS Requester files are installed by default only on 32-bit Windows platforms at <drive:>\%WINDIR%\SYSTEM32\ |
What is an Application Data file?
Application data files are typically files to which the system can write. Examples of application data files include log files, tutorial files, and sample database files, such as Demodata and tempdb.
What is a Program File?
Program files are typically files the system requires in order to function. Examples of program files include binary system files, executable files, dynamic link libraries and .jar files.
What is the difference between 32- and 64-bit Program Files?
Microsoft guidelines recommend that 64-bit components are installed in a separate location from 32-bit components. PSQL 64-bit components are installed in the 64-bit program files location and are registered in the Windows Registry under the 64-bit hive. PSQL 32-bit components are installed in the 32-bit program files location and are registered in the Windows Registry under the 32-bit (x86) hive.
What if I need a 64-bit Client in a Workgroup environment?
The Workgroup installer installs all components appropriate to your 32- or 64-bit Windows system. No additional installation is required.
What happened to the Client install image?
Previous versions of PSQL contained an image used for installing the client software needed to access the PSQL database. This image is no longer needed, since PSQL now installs the Client components with the Server and the Workgroup editions. Use the Client installation packages to install on individual client machines.
Do I need to install the Client with a Workgroup engine?
If you are installing the Workgroup engine, you must have a license for and install the software on every computer that is expected to share data within your workgroup. Because every computer must have the Workgroup engine installed and the client software is installed with every engine by default, there is no need to install the client software separately.
How Do I Read the Online Documentation?
The viewer for the documentation library is integrated into PSQL Control Center (PCC). Access the documentation library through the PCC interface on the Welcome view, in the Help menu, by pressing F1 (Windows) or Shift F1 (Linux).
You can also view the documentation in the form of Adobe Acrobat (PDF) files. These PDF files are available on the PSQL installation media in the Books directory.
How Do I Verify or Update My User License?
Licenses from previous versions of PSQL are not migrated or transferable to a new release. You must have a license applicable for this release, unless you choose to install a trial version of the product.
The License Administrator utility allows you to view and adjust the keys used to license the PSQL products. For example, you can verify which keys have been authorized, check the state of a key, and check the number of authorizations remaining for a key. For a detailed discussion of the License Administrator utility, and a list of the tasks that you can perform, see
License Administration in
PSQL User's Guide.
What User License Was Installed with PSQL?
A trial license is installed if you leave the license number blank during installation.
There is no configuration necessary for the license. After installation, you can use the License Administrator utility to view your installed licenses. See PSQL User's Guide for more information on this utility.
Where to Go from Here
If you had trouble during installation or have questions regarding troubleshooting, see
Troubleshooting After Installation.
If you completed installation successfully, continue with your PSQL deployment by installing and configuring the clients for the machines that will connect to your servers. For more information, see
Installing PSQL Clients for Windows.
Uninstalling PSQL
The uninstall program removes the PSQL and all related components from your system that were added by the installation program, including registry settings, configurations and PSQL system and sample databases.
The uninstall program does not remove the following:
•PSQL keys
•Databases that you create under the PSQL installation directories
•DSNs and database names associated with those databases
•Databases in locations other than the installation directory for PSQL installation directory
•Other products related to PSQL such as AuditMaster, Backup Agent, or DataExchange. Such programs have their own uninstall programs. Refer to the documentation for each product.
►To uninstall PSQL
1 Use a PSQL license utility (GUI or CLI) to deauthorize the key that was used to authorize the product. This allows you to use the key for a different installation if you so choose. See
To Deauthorize a Key in
PSQL User's Guide, for example.
2 In the Windows Control Panel, select Programs and Features.
3 Select the installed PSQL product from the list.
4 Click Change then Next.
5 Click Remove then Next and follow any prompts during the uninstall.
If prompted, close or uninstall any running applications that may interfere with uninstalling PSQL.
Caution Unpredictable results may occur during the uninstall if you ignore programs that may interfere.
Restart your system if prompted to do so.