Goldstar Logo
Your Source for PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
PSQL Database Engines
+ Actian PSQL v13
+ Actian PSQL v12
+ Actian PSQL Vx 12
+ Actian PSQL v11
+ Actian PSQL Vx 11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve v12
+ Btrieve 6.15

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users: Click Me Fix My PSQL License Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

  PSQLv12 Quick Links
Product Information
Pricing Information
Patch Downloads
Licenses Explained
Buy Now On-Line!
Ongoing Support
Why Goldstar?

Actian PSQL v12 Product Information

Click For PSQLv12 Product Data Sheet

Click for Online Database Defragmenter Data Sheet

Click for AAP for PSQL Data Sheet

The Actian PSQL v12 product line was released on December 17, 2014. Like previous versions like Actian PSQL v11 and older, PSQL v12 is available for Windows in both 32-bit and 64-bit levels. The Linux engine was released in April 2015 in a 64-bit version only. AuditMaster has been released, but we are still waiting for a compatible version of DataExchange.

Here is a list of the most important new features in this release:

  • Online Database Defragmenter: Most PSQL administrators are familiar with the venerable "Rebuild Utility", which can both reclaim deleted space and shrink index structures to their most optimal state. New with PSQLv12 is the ability to run this process on "live" files -- while the system is in use! This important new feature will allow you to maintain your database, even in 24x7 operational environments like airlines and health care!
  • More Unicode Support: As applications increasingly must perform correctly in the global marketplace, support for the full Unicode character space is more and more important. PSQLv12 adds even more Unicode support to the engine, including new SQL data types NCHAR, NVARCHAR, and NLONGVARCHAR, a new ODBC driver for Unicode applications, and support for Unicode in various utilities like BDU, PCC, and the Query Plan Viewer.
  • Rebranding: Although the product has been called Actian PSQL for a long time now, the dialog boxes and menus finally reflect this change. Additionally, the names of the services, the installation folder, and more are changing. This may be an issue for companies who support the PSQL environment, but not an issue for new installations.
  • Easier Installation: PSQLv12 brings some new capabilities to ease installation. First, the Workgroup Engine will install as a service by default, eliminating the common Status 7224 error message when applying a license. Second, there will only be ONE Client installer, and it will be smart enough to install all applicable components -- eliminating the issue caused when users install the 64-bit Client and find that their 32-bit applications do not work.
  • License Changes: There are two important licensing changes in the PSQL v12 release. First, *ANY* use of multiplexing (i.e. thin client solutions) or public web services will require a switch to the PSQL Vx licensing model, which is now licensed based on the size of the database only. (Note that PSQL Vx may offer a lower cost for some sites, as well.) Second, and perhaps more importantly, all PSQL v12 and PSQL Vx Server 12 licenses will no longer be tied to the entire hardware fingerprint of the server -- but ONLY the machine name. This makes all the v12 engines hypervisor-friendly for use in virtual machines and full-server failover environments! In a third change related to licensing, the PSQL Vx Server 12 engine no longer requires constant internet access to stay activated.
  • Developer-Level Updates: Software developers now have access to the ADO.NET v4.1 drivers (though 3.2 and 3.5 have been eliminated), new features through JDBC and ODBC for Unicode, and PDAC components for design-time (32-bit) and runtime (32 and 64-bit).
  • High-Speed Reporting: PSQL v12 Server Engine licenses also include a license to install the Actian Analytics Platform for PSQL. This new reporting solution leverages the eye-popping speed of Actian's Vector database engine and the fast data migration capabilities of Actian Dataflow (formerly DataRush) to bring incredible, high-speed reporting and analytics to your PSQL environment. The included license provides a whopping 1TB limit and no user count restrictions, so you can use it for all of your reporting needs.
  • 64-Bit Linux Engine ONLY: Actian has made a decision to release ONLY a 64-bit version of the PSQL v12 Server Engine for Linux. As such, PSQLv12 is NOT supported on 32-bit Linux installations. This new release will include all 64-bit utilities , as well. Users needing to run 32-bit applications on their Linux server can ALSO download and install the "Client Access" components, which will support running 32-bit applications on the 64-bit environment.
  • Windows 10 Support: On October 22, 2015, Actian announced support for PSQL v12 on Windows 10. All editions of PSQL v12 include support for Windows 10 Pro, Enterprise, and Enterprise 2015 LTSB. The Workgroup Engine and PSQL Client are also supported on Windows 10 Home Edition.
  • Mac OS X Support: In September 2015, Actian announced support for PSQL v12 Server Engines running on the Mac OS X platform. Support is currently available for v10.9 and v10.10 of OS X. Please note that Goldstar Software will be able to sell Mac licenses, but will not be able to provide any support for this platform, as we have no expertise with this OS at this time.
  • Standalone Server License: In February 2016, Actian announced a new Standalone Server Engine license for PSQL v12. This 1-User Server Engine is NOT expandable like other Server Base licenses, as it does NOT accept any user count increases, so it is somewhat limited in that regard. If you think you might need to add more users in the future, then the 32-bit Workgroup Engine may be a better option for you. However, if you have a 64-bit operating system and you want the extra security and features of a true Server Engine, or if you want the performance gains to be had with access to more than 4GB of memory for the database engine and cache, this is for you! The Standalone Server Engine is ideal for developer workstations with lots of memory, and the extra performance will certainly be noticed. Still not sure? Check out our Server vs. Workgroup comparison chart.
  • Windows Server 2016 Support: On November 8, 2015, Actian announced support for PSQL v12 on Windows Server 2016. All editions of PSQL v12 are now supported on this operating system!

Download your 30-day TRIAL from Actian's PSQL v12 Web Site now.

Important Note: Officially supported operating systems include Windows Vista and newer, and Windows Server 2008 and newer only. Windows XP, Server 2003, and older operating systems are not supported in this release! This does not mean that they will not work (though we know that Windows 2000 will not even accept the install), but only that they have not been tested and will not be supported by Actian. For minimum hardware and OS requirements, check the Actian PSQL v11/v12 Hardware Requirements page for more details.

If you're not sure if you want the Workgroup Engine or the Server Engine, check out this comparison chart.

We expect application vendors to announce support for Actian PSQL v12 soon after its release. If you are not sure, check our Application Support pages or contact your application vendor directly.

Pricing can be found on our Actian PSQL v12 price list, or you can BUY IT NOW from our on-line store. If you want to try it out before you buy it (a really good idea!), you can get a downloadable trial license of PSQLv12 from Actian's Web Site.

Not sure which license you need?


[Expand Entire Page... ] [Collapse Entire Page... ]

[+] Actian PSQL v12.10 (SP1)...

[+] Actian PSQL v12.00 (FCS)...

[+] Frequently Asked Questions About Actian PSQL v12...

[Expand Entire Page... ] [Collapse Entire Page... ]



If you have additional questions about the product, please contact us!

  Copyright © 1997-2017, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 3007 Carmel Dr | Flossmoor IL 60422 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us