� Downloads� Contact� Buy� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support � Resources� Knowledge Base� Documentation� Forums� Newsletter� Component Zone� Register Product� Find a Distributor� PSQL Developer� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support What's New�in�Pervasive�PSQL�v11 SP3� Certified for Windows Server 2012� Support for Windows 8� Repair - New License Administration Feature� New SDK - Java Persistence API� ADO.NET 4.0 and PDAC for RAD Studio XE3� Capacity Usage Viewer - for PSQL Vx Sizing� 30 License Authorizations Allowed� IPv6 Support for ODBC, ADO.NET, KDBC, JCL� New Monitor ViewSupport for Windows 8 and Windows Server 2012Pervasive PSQL v11 SP3 is Certified for Windows Server 2012 and will support Windows 8 editions.
Here's a table with the�new Windows OS Support for Pervasive PSQL v11 SP3. Operating SystemEditionVx Server?ServerWorkgroupClientWindows 8Windows 8? vvvv?Professional?v?v?v?v?Enterprisev?vvvRT? XXXXWindows Server 2012Foundationv?vvvEssentialv?vvvStandardv?vvvDatacenterv?vvvAll operating systems should be updated to their latest service packs.
New License Administrator FeaturesRepair - Before PSQL v11 SP3, a hardware change or VM move without first deauthorizing the PSQL key would sometimes put the key into a failed validation state.
The simplest way to resolve this was to contact Support and get the key repaired. With the latest version of the PSQL License Administrator, customers can repair failed validation or disabled keys on their own.
Click here to learn more about Repair. .New Buttons on License Administrator GUI - We have updated the License Administrator GUI to make it more consistent with documentation. Here are the changes: Before PSQL v11 SP3New with PSQL v11 SP3N/A??RepairApply?AuthorizeDelete?DeauthorizeValidate?(removed)Refresh(removed)? Similar changes have been made to the command line version of the License Administrator. New and Updated SDKsJPA for PSQL - If you write applications with the EclipseLink platform, you can now use Pervasive PSQL as a database.
Java persistence API maps objects to relational databases. EclipseLink is an open source implementation of JPA. Pervasive has added PSQL as an EclipseLink JPA platform. Download the SDK. Check out the JPA SDK readme.ADO.NET - Pervasive PSQL Data Provider 4.0 can run under all .NET Frameworks from 2.0 SP1 to 4.0. Download the ADO.NET SDK. Check out the ADO.NET SDK readme. Note: Data Provider 3.2 will not be included in future releases.PDAC - The newest PDAC SDK includes new compile time binaries for RAD Studio XE3 and provides support for 32-bit PDAX through Delphi RAD Studio XE3.
Download the PDAC SDK. Check out the PDAC SDK readme. New SQL FeaturesORDER BY - A table subquery within a SELECT now supports ORDER BY clause.CREATE INDEX - Now supports the specification of an index number with USING index_Number clause. IPv6 EnhancementsAccess Methods - In addition to Btrieve and DTI, PSQL v11 SP3 includes IPv6 support for ODBC, ADO.NET, JDBC and JCL.Utilities - DDF builder now includes support for IPv6. Updated Utilities Capacity Usage Viewer - Pervasive Engineering has added a great new tool for analyzing PSQL Vx Server capacity requirements.
With the Capacity Usage Viewer you can:� Track daily peaks for data in use and concurrent sessions� Select specific date ranges for analysis� Define Usage Levels for data in use and concurrent sessions and track how many times in a given date range those levels were exceeded� Export usage data to Excel The Capacity Usage Viewer is a very simple tool to use, but you will need a few weeks of data to make things interesting.
We have provided a sample pvcapacity.log file that includes 5 years of data. Replace the existing pvcapacity.log file with the download and then check out all the features of the Capacity Usage Viewer.
You can find the pvcapacity.log file in these locations:� Windows 7 - C:ProgramDataPervasive SoftwarePSQLlogs� Windows XP - C:|Documents and SettingsAll UsersApplication DataPervasive SoftwarePSQLlogs Notes: 1) Using this file will wipe out the existing log, so don't run this test on a production system, 2) to get rid of the sample usage history, delete the file, stop and restart PSQL services.
For more information on the Capacity Usage Viewer, please read pages 72 - 76 of the PSQL User's Guide Monitor: New View - The new view of monitor data is a simple refresh - the same data as in the current monitor utility in a new layout. The new layout is tab based, which will make it simpler to add new information in future generations of Pervasive PSQL.
Here's a screen shot: This article contains content that is written like an advertisement. Please help improve it by removing promotional content and inappropriate external links, and by adding encyclopedic content written from a neutral point of view.
(December 2015) ( Learn how and when to remove this template message)Pervasive PSQL Developer(s)Actian CorporationStable release PSQL v12 / September 2015Development statusActiveOperating systemCross-platformAvailable inEnglish, JapaneseTypeDBMS, RDBMS, NotOnlySQLLicenseProprietary software, trial editions availableWebsitewww.actian.comPervasive PSQL is an ACID-compliant DBMS [1] developed by Pervasive Software.
It is optimized for embedding in applications [2] and used in several different types of packaged software applications offered by independent software vendors (ISVs) and original equipment manufacturers ( OEMs).
It is also pervasive psql v11 server for windows for software as a service (SaaS) deployment [3] due to a file-based architecture enabling partitioning of data for multitenancy needs.Applications can store the data and the relationships in tables in a relational model ( RDBMS) or store the data in a schema-less way with no fixed data model ( key-value store).Pervasive PSQL runs on system platforms that include Microsoft Windows, Linux, and Mac OS Both 32-bit and 64-bit editions of Pervasive PSQL are available.
Editions are also specifically designed for different computer networking deployment needs, such as workgroup, client-server, and highly virtualized environments, including Cloud computing.The original name for Pervasive PSQL was Btrieve. [4] Pervasive Software was acquired by Actian Corporation in 2013. [5] Contents� 1 Uses and customers� 2 DBMS architecture� 2.1 MicroKernel Database Engine� 2.2 Relational Database Engine� 3 Additional features� 4 Interfaces� 4.1 Management interfaces� 4.2 Application interfaces� 5 Tools� 6 Versions� 7 Editions and licensing� 7.1 Editions� 7.2 Licensing� 8 Limitations� 9 References� 10 See alsoUses and customers [ edit ]Pervasive PSQL has a world-wide presence, but because Pervasive PSQL is an embedded database, its extensiveness is not well known.
�Although Pervasive PSQL has been available for more than twenty five years, not many know of its existence. Competing products such as Oracle and Microsoft SQL Server are, without a doubt, better known and more noticeable. This obscurity is undeserved, because the number of installations worldwide is impressive. .Organizations buy applications from the ISVs and VARs without knowing that Pervasive PSQL is the engine running all their applications.� [4] �The company has 3,500 partners worldwide, including roughly 200 OEMs and 45 distributors who provide some of the traditional services a value-added reseller does, such as training and consulting work.� [6]Examples of Pervasive distributors include Goldstar Software for the US market, [7] SOS Software Service AG for the German, Swiss, and Austrian market, [8] DSCallands and Southdown House Software Ltd.
for the United Kingdom and Irish market, Poly-Asia e-Technology for the Chinese and Southeast Asian market, AG-TECH for the Japanese market, and Stern Software for the South American market. [9]Pervasive PSQL is embedded by OEMs like Sage, [10] maestro* Technologies, ABACUS Research AG (Switzerland), and Unikum (Sweden) in packaged software applications that address the accounting, finance, retail, point-of-sale, entertainment, reservation system, and medical and pharmaceutical industry segments.
�Users include Novell, Microsoft, PeachTree Software, Fair Isaac, Disney World, Radio Shack, Cardiff and others.� [11] The accounting industry forms a large part of the Pervasive PSQL market. �In the year ended June 30, 2007, approximately 20 percent of database revenues were from sales related to applications from such vendors as Sage, Intuit, Exact Software, Cyma Systems and Epicor.� [11] An example of the use of PSQL in the medical industry is WebMD.Historically, Pervasive PSQL has served as a DBMS for the small- to medium-sized business (SMB) commercial section.
�According to Wayne Kernochan, senior analyst for Illuminata, 'Pervasive takes a different direction from enterprise databases in several different areas, with positive results for low-IT users.'.'Pervasive PSQL is particularly useful and offers especially low TCO in mass-deployment architectures, wherein multiple workgroups or branch offices in multiple localities each use a local server which may be linked back to a central server,� added Kernochan.� [12] DBMS architecture [ edit ] See also: Architecture of BtrievePervasive PSQL supports stand-alone, client-server, peer-to-peer [13] and software-as-a-service (SaaS) [3] architecture.The central architecture of Pervasive PSQL consists of two database engines: (1) the storage engine, known as MicroKernel Database Engine (MKDE) and described by Pervasive Software as a transactional database engine and (2) the relational database engine, known as SQL RPervasive PSQL v11 SP3 -README Pervasive PSQL v11 SP3 Release NotesGeneral Release �January 2013 ContentsWelcome to the General Release of Pervasive PSQL v11 SP3.This file contains the following topics: � Citrix XenServer 5.6 and 6Note For information onspecific operating system service packs, please refer to the Pervasive website at https://www.pervasive.com/database Third-Party CertificationFor information related to third-party certification forPervasive PSQL v11 SP3, refer to the Pervasive Software web site for detailedstatus information.
Product AuthorizationPervasive PSQL v11 SP3 comes with a trial key (Server 20 useror Workgroup 5 user) for evaluation installations.If you are installing this release of Pervasive PSQL v11 SP3 ona machine with a previously authorized version of Pervasive PSQL v11, you arenot required to authorize the product at installation; you can continue to useyour previous product key.If you are installing this release of Pervasive PSQL v11 SP3 ona machine without a previously authorized version of Pervasive PSQL v11, you arerequired to authorize the product, either at the time of installation or afterinstallation using the License Administrator utility.
Product Authorization on WindowsOn Windows, product authorization is required for PervasivePSQL Server or Workgroup. Product authorization can be performed duringinstallation or using the license administrator utility after installation.
Toauthorize Pervasive PSQL v11 SP3 during installation requires an Internetconnection. To authorize Pervasive PSQL v11 SP3 after installation, see thealternative authorization procedures outlined in the Pervasive PSQL User�sGuide. Product Authorization on LinuxOn Linux, product authorization is required for Pervasive PSQLServer on Linux and must be performed using the license administrator utilityafter installation.
To authorize Pervasive PSQL v11 SP3 during installationrequires an Internet connection. License Authorization Access Through Proxy Servers onWindowsIf you are using a proxy server, Pervasive Software recommendsthat you configure it through Windows Internet Explorer for the best results.Pervasive PSQL v11 SP3 license authorization is designed to work seamlessly withno modifications needed when configured through Window Internet Explorer.If you are using a proxy server that was not configured usingWindows Internet Explorer, Pervasive Software recommends that you do so.If using Windows Internet Explorer to configure your proxyserver is not an option, you need to follow these steps:1.
Install Pervasive PSQL v11 SP3 without performingauthorization.2. In the Windows registry, add the following to theHKEY_LOCAL_MACHINESoftwarePervasive SoftwareELS key: Note: The proxy_host and proxy_port values are theonly ones required by Pervasive PSQL v11 SP3. Depending on theconfiguration of your proxy server, you might also need to addproxy_userid and proxy_passwd. Caution Editing the registry is an advanced procedure.
If done improperly, theediting can cause your operating system not to boot. If necessary, obtain theservices of a qualified technician to perform the editing.
Pervasive Softwaredoes not accept responsibility for a damaged registry.3. Authorize Pervasive PSQL v11 SP3 using the LicenseAdministrator utility. License Authorization Access Through Proxy Server on LinuxIf you are using a proxy server on Linux, you need to followthese steps:1.
Install Pervasive PSQL v11 SP3 without performingauthorization.2. Manually edit the ELS.INI file to include thefollowing: Note: The proxy_host and proxy_port values are theonly ones required by Pervasive psql v11 server for windows PSQL v11 SP3. Depending on theconfiguration of your proxy server, you might also need to addproxy_userid and proxy_passwd.3. Authorize Pervasive PSQL v11 SP3 using the command lineinterface License Administrator utility.
Client CompatibilityThe General Release of Pervasive PSQL v11 SP3 Server andWorkgroup supports Pervasive PSQL v10 or later Clients. New Features and EnhancementsSee What�s New in Pervasive PSQL for a discussion ofthe new and changed features in Pervasive PSQL v11 SP3. Installing Pervasive PSQLThis section discusses topics pertaining to the installation ofthe product on Windows and Linux. Before reading this section, review thecontent in ProductAuthorization in the previous section.The installation files are available for download from thePervasive Web site: https://www.pervasive.com/databasePervasive Software requires that you uninstall any previouslyinstalled pre-release version, such as a Beta or Release Candidate from anyversion, prior to installing the final General Availability (GA) release ofPervasive PSQL v11 SP3.
WindowsIf you have not installed the product and want to read aboutinstallation, see the portable document format (PDF) book Getting Startedwith Pervasive PSQL, available on the installation media or the PervasiveSoftware web site.Installing Pervasive PSQL on WindowsTo start the installation, run the appropriate setupappli� Downloads� Contact� Buy� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support � Resources� Knowledge Base� Documentation� Forums� Newsletter� Component Zone� Register Product� Find a Distributor� PSQL Developer� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support What is new in PSQL v11 SP3?PSQL v11 SP3 is certified on Windows Server 2012, supports Windows 8, has new license administration utility called Repair and some SDK updates.
Some of the key features are:� Windows OS Support - Certified on Windows Server 2012 and support for Windows 8� Repair - Allows end users to repair keys that have failed validation� New SDK - Java Persistence API (JPA)� Capacity Usage Viewer - PSQL Vx Sizing Analysis� Updated ADO.NET (.NET 4.0 Support) and PDAC (RAD XE3 Support)� Enhanced IPv6 SupportWhat was new in PSQL v11 SP2?PSQL v11 SP2 includes two backup options, has an updated monitor utility, and simplified licensing.
Some of the key features are:� Backup Agent Included - PSQL v11 SP2 Server includes a license for Backup Agent v3.1� Microsoft Volume Shadow Copy Service Support - PSQL v11 SP2 Server includes support for VSS� Updated Monitor - Monitor utility tracks concurrent sessions, data in use and uptime for the microkernel.� Multi-OS Product Key - Product keys for PSQL v11 SP2 are not operating system specific.� Delphi XE2 Support - PDAC now supports Embarcadero's Delphi XE2 How do I get Backup Agent with PSQL v11 SP2?A license for Backup Agent v3.1 is included with PSQL v11 SP2.
For Windows customers, the Backup Agent executables are included in the PSQL v11 SP2 Windows media. For Linux customers, Backup Agent is available as a separate download. Backup Agent is a no-charge option with PSQL v11 SP2 and requires no additional product key. Can I get Backup Agent if I have an earlier version of PSQL v11?Yes.
Updating your existing PSQL v11 installation to SP2 will allow you to install Backup Agent 3.1 (either from the choices in the Windows install or as a separate Linux download. What is Microsoft VSS?Microsoft's Volume Shadow Copy Service (VSS) is Windows' framework for application backups. If your backup software is VSS-aware, PSQL is automatically invoked during VSS backups.
Click here to learn more about PSQL v11 SP2 backup options. Are Backup Agent and VSS available for PSQL v11 Workgroup?Backup Agent for Workgroup is available as a separately licensed product. VSS support for PSQL v11 SP2 Workgroup is not currently available. Click here to learn more about PSQL v11 SP2 backup options. What's new in the Monitor utility for PSQL v11 SP2?The Monitor utility in PSQL v11 SP2 now has the same features as the monitor that ships with PSQL Vx Server - specifically that it includes information about Concurrent Sessions and Data in Use.
The key benefit of these added features is that it provides a very simple way for customers to determine their application's requirements for moving to a PSQL Vx Server license.
Learn more about monitor for PSQL v11 SP2 and PSQL Vx Server. How does a single PSQL v11 SP2 key work for multiple operating systems?Starting with PSQL Vx Server and continuing with PSQL v11 SP2, product keys are no longer tied to a particular operating system. That means a single product key will fork for 32- and 64-bit Windows and 32- and 64-bit Linux. Licenses are still per machine (virtual or physical) and product keys will still authorize only one PSQL instance at a time. Will my existing UCI keys work with PSQL v11 SP2?UCI keys for PSQL v11 will work with PSQL v11 SP2.
Updating an existing PSQL v11.x installation with SP2 does not require deauthorization of any keys. The PSQL pervasive psql v11 server for windows SP2 install replaces prior versions and does not require a new key. What was new in PSQL v11 SP1?PSQL v11 SP1 has updated developer tools, enhanced license administration, performance monitoring and OS support.
Below is a short list of the highlights. For more details read What's New in PSQL v11 SP1� New performance monitor counters to help analyze and tune PSQL applications� 64-bit support for DTO (including the .NET framework)� PDAC support for RAD Studio XE� 64-bit ODBC for Linux� 32- and 64-bit Support for Red Hat Enterprise 6� Doubled allowed authorization/deauthorizations to 10� Added Remaining Authorizations counter� Added new key state to provide 14 day period to correct licensing issues� New PSQL Notification Viewer provides easy access to licensing related notices Why optimize for multi-core hardware?Any new server hardware purchased today will have a minimum of dual core and most are being sold with quad and eight-way cores.
Users with new hardware may notice performance problems with applica� Downloads� Contact� Buy� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support � Resources� Knowledge Base� Documentation� Forums� Newsletter� Component Zone� Register Product� Find a Distributor� PSQL Developer� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support New in Actian PSQL Vx Server 12� PSQL Vx Server 12 SP1 - Full update for existing PSQL Vx Server 12 installations� PSQL Vx Server 12 for Apple OS X - Now PSQL developers can expand into Apple-only markets.� Unlimited Session Counts pervasive psql v11 server for windows PSQL Vx Server 12 is licensed based on the amount of data in use only.
Unlimited users, unlimited cores (on one machine), unlimited devices.� No More Ongoing Internet Connection - PSQL Vx Server 12 requires an Internet connection only once - during initial product authorization. After that - you're good to go.� Online Defragmenter - Brand new feature for v12 that allows you to defrag live PSQL files.� Unicode Support - PSQL v12 includes new data types and ODBC driver to make it easier to internationalize your PSQL application.PSQL Vx Server 12� PSQL Vx Server 12 SP1� PSQL Vx Server 12 for OS X - Downloads� PSQL Vx Server 12 - Update 8 June 2016� PSQL Vx Server Product Guide� PSQL Vx Server Essentials - Just the Basics� Information Management: Virtualization is the New Norm� PSQL Vx 12 SP1 What's New� PSQL Vx 12 SP1 Readme� Learn About Online Defrag in the v12 Advanced Ops Guide� PSQL v12 FAQ� PSQL Vx Server Licensing� Estimating PSQL Vx Capacity RequirementsPSQL Vx Server 12 SP1 Downloads - Full Install DownloadsVersion DataDocumentationPSQL Vx Server 12 SP1 - Windows32 & 64-bitDateJune 2016ReadmePSQL v12 SP1 Client - Windows32 & 64-bitVersionVx Server 12 SP1What's NewBuild Number12.10.067Known IssuesPSQL Vx Server 12 SP1 - OS XDMGTARPSQL Vx Server 12 SP1 - LinuxRPMTAR PSQL Vx Server 12 Updates - Requires Existing PSQL Vx Server 12 Installation DownloadsVersion DataDocumentationPSQL Vx Server 12 Update - Windows32 & 64-bitDateJune 2016ReadmePSQL Vx Server 12 Update - LinuxRPMTARVersionv12 Update 8PSQL v12 Client Update- Windows32 & 64-bitBuild Number12.01.070 PSQL Vx Server 11 SP3 Updates - Requires Existing PSQL Vx Server 11 SP3 Installation DownloadsVersion DataDocumentationPSQL Vx Server Update - Windows32-bit64-bitDateJune 2016Readme for v11.31PSQL Vx Server Update - Linux RPM32-bit64-bitVersionv11.30 Update 25PSQL Vx Server Update - Linux TAR32-bit64-bitBuild Number11.31.101 What is PSQL Vx Server?�PSQL Vx is the hypervisor friendly edition of PSQL.
Running your PSQL database application on a virtual machine with your favorite hypervisor from VMware, Microsoft or Citrix is now very, very simple to do.Why is PSQL Vx Server important? Customers are moving to virtual machines at an increasing rate, and virtualization is a fundamental component of running software in the Cloud, either for hosting or just shifting IT infrastructure.
PSQL Vx will help you get there.What are the key features of PSQL Vx Server?�Live�migration support.�Now PSQL engines running on VM's can move easily from one�physical�machine or appliance to another. PSQL Vx Server enables hypervisor initiated automated moves of VM's across physical machines.�Failover and high availability support.�When a hypervisor is alerted to a potential failure of a physical machine, it automatically moves the VM to another server.
PSQL Vx Server's updated licensing process works in synch with the hypervisor operation, making sure failovers take place without�a hitch.�Simplified license validation.�PSQL Vx Server product key authorization requires only VM hostname and all VM NIC MAC addresses remain unchanged.
This is what makes support for live migration possible. A single product key can be used on any operating system supported by PSQL Vx Server (Windows, Linux, Mac OS, 32- or 64-bit). Changing operating systems has never been easier.�VM and Cloud-Centric Pricing.�With PSQL Vx Server, there is no need to count users or CPU's.
PSQL Vx Server license pricing is based on how much work the database engine can do - a combination of concurrent sessions and data in use.�Improved backup. A license for Backup Agent and the Backup Agent executable are included with each purchase of PSQL Vx Server. For Windows users, PSQL Vx Server supports Microsoft Volume Shadow Copy Service (VSS) full backup and full copy. The combination of VSS support and Backup Agent will make it much easier to automate backups of live PSQL Vx Server databases.�Expanded hypervisor support.�PSQL Vx includes support for hypervisors from VMware, Microsoft and Citrix.�Application compatibility.
PSQL v11 applications will run with no changes on PSQL Vx Server 11. Software Devel� Downloads� Contact� Buy� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support � Resources� Knowledge Base� Documentation� Forums� Newsletter� Component Zone� Register Product� Find a Distributor� PSQL Developer� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support If you have never read the PSQL v11 License Agreement - the one that you accept every time you install the software - you are not alone.
Most people never read licenses; they just click "Accept" and forget all about it. There are two good reasons to read and understand what's in these agreements: 1) making sure that the license rights match your business requirements (in other words, make sure you've picked the right product) and 2) understanding what you are allowed to do with the software will help keep you from potentially expensive compliance problems. This guide will identify and review some of the more important sections of the PSQL v11 License Agreement and provide direction about which products fit particular distribution models.
Where relevant, the specific section of the License Agreement is included next to the paragraph header. Read the guide below or download it here. Actian PSQL has a license agreement for the Server and Workgroup products and another license for Clients.
Client licenses are in place primarily to restrict the use of the client software to support of and use with PSQL Workgroup, Server or Vx Server. Client has no concept of user count or the number of copies (except that copies are to be used solely for accessing a PSQL engine). Client software is included with Workgroup, Server and Vx Server media and can be downloaded from the Pervasive website for no charge. This guide will focus on the terms of the Server and Workgroup license.
License = Restricted Right to Use (Not Ownership) (Section 2. License) What you pay for when you buy a software license is the right to use the software under a given set of rules. For PSQL Workgroup and Server, the right to use the software is a license for a specific number of users to simultaneously access the database on a single machine. For PSQL Vx Server, this means a specific capacity (sessions and data � more on this later) on one or more machines.
There are some restrictions on those rights to use � Actian retains all rights, title and interest in the software, and the rights to use the software granted in the license may not be transferred or sublicensed without written approval from Actian. From Perpetual On-Premise to Subscriptions in the Cloud Until recently, most software licenses have been perpetual and for a single on-premise machine.
However, more and more are term limited (subscriptions) and in the cloud. Keeping track of concurrent users on a single machine is not a problem. Doing the same thing in an environment full of virtual machines and users accessing the application via the Internet is a lot more difficult. This shift in software use models has prompted the addition of a new licensing model for a new edition of PSQL � capacity based licensing for PSQL Vx Server.
Before we cover the licensing new model, let's look at a more familiar one. Perpetual/On-Premise -> Concurrent Use Licenses � PSQL Server and PSQL Workgroup (Section 1. Definitions, Section 2. License) PSQL Workgroup and Server both have perpetual concurrent user licenses � the customer pays for a specific number of users to access the database simultaneously and the license doesn't expire. PSQL Workgroup is limited to 5 users, while PSQL Server starts at 6 users and goes to 500.
PSQL Server and PSQL Workgroup are licensed for one machine at a time (It's ok to move an instance of PSQL Server or Workgroup from one machine to another, but not to create a copy to put on another machine.) Using Terminal Server? Make sure to count all users correctly (Section 2.2. Multiplexing)Lots of customers use terminal servers as a simple way to access a database server.
That's fine � it's a great technical solution � but it is important to remember that using a terminal server doesn't reduce size of the concurrent user license that is required for PSQL. For example, if you have 6 customers accessing the PSQL Server database directly and 4 others going through a terminal server, you need a concurrent user license for 10 users.
Cloud Based/No Hypervisor: Internet/Intranet License for PSQL Server (Section 2.1.a. Server Edition License Grant) PSQL Server also offers unlimited concurrent user licenses that allow internal hosting (Intranet) and hosting for third parties (Internet). If you are hosting an application for access by users outside of your company (SaaS, for example), you need an Interne� Downloads� Contact� Buy� Products� PSQL Vx� PSQL v12� Pervasive psql v11 server for windows v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support � Resources� Knowledge Base� Documentation� Forums� Newsletter� Component Zone� Register Product� Find a Distributor� PSQL Developer� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support Learn More About PSQL v11PSQL v11 FAQWhat's New PSQL v11Documentation/Whitepapers� PSQL v11 Transition Support Starts January 1, 2016� PSQL v11 End of Support July 1, 2016� PSQL v11 Support for Windows Server 2012 R2 and Windows 8.1� PSQL v11 SP3 Update 25 - June 2016� PSQL v11 SP3 - Download Now� Support for Windows 8 and Windows Server 2012� New License Admin Feature - Self Repair� PSQL v11 SP3 Update�24 Readme� PSQL and OData� Creating an OData Producer for PSQL� PSQL as a Windows App Database� Creating an OData Java Producer for PSQL� Accessing PSQL Data from Java OData� Accessing PSQL Data from Javascript OData� Using PSQL as a Data Store with VMware SQL Fire� Moving to the Cloud with PSQL� Building a Multi-tenant Application with PSQLNeed help with PSQL licensing?
Click the image to troubleshoot. PSQL v11 SP3 Updates - Requires Existing PSQL v11 SP3 Installation DownloadsVersion DataDocumentationPSQL Server Update - Windows32-bit64-bitDateJune 2016Readme for v11.31PSQL Server Update - Linux RPM32-bit64-bitVersionv11.30 Update 25PSQL Server Update - Linux TAR32-bit64-bitBuild Numberv11.31.101PSQL Client Update - Windows32-bit64-bitPSQL Workgroup Update - Windows32-bit PSQL v11 SP1 Updates - Requires Existing PSQL v11 SP1 Installation DownloadsVersion DataDocumentationPSQL v11 Server Update - Windows32-bit64-bitDateJuly 2012ReadmePSQL v11 Server Update - Linux RPM32-bit64-bitVersionv11PSQL v11 Server Update - Linux TAR32-bit64-bitBuild Number11.11.020PSQL v11 Client Update - Windows32-bit64-bitPSQL v11 Workgroup Update - Windows32-bit Software Development Kit DownloadsBtrieve for WindowsDownloadReadmeBtrieve for LinuxDownloadReadmeADO.NET 3.5DownloadReadmeADO.NET 4.0DownloadReadmeADO.NET 4.1DownloadReadmeActive XDownloadReadmeDTI SDK for WindowsDownloadReadmeDTI SDK for LinuxDownloadReadmeDTO SDKDownloadReadmePDACDownloadReadmeJCL SDK for WindowsDownloadReadmeJCL SDK for LinuxDownloadReadmeJDBC SDK for WindowsDownloadReadmeJDBC SDK for LinuxDownloadReadmeJava Persistence API SDKDownloadReadmeOLE DBDownloadReadmeDownload Archived SDK Components, Snippets and Samples � Downloads� Contact� Buy� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support � Resources� Knowledge Base� Documentation� Forums� Newsletter� Component Zone� Register Product� Find a Distributor� PSQL Developer� Products� PSQL Vx� PSQL v12� PSQL v11� PSQL v10� PSQL v9� AuditMaster� BackupAgent� DataExchange� Btrieve 12� Support� Get Support� Knowledge Base� Submit Ticket� PSQL Insurance� PSQL Authorization� PSQL License Support Click here for a list of hypervisors supported by PSQL Vx.Operating SystemEditionVxServerWorkgroupClientWindows 8.1Windows 8.1vvvvProfessionalvvvvEnterprisevvvvRTXXXXWindows Server 2012 R2FoundationvvvvEssentialvvvvStandardvvvvDatacentervvvvWindows 7EnterprisevvvvUltimatevvvvProfessionalvvvvHome PremiumXXvvWindows Server 2008 R2 SP1 (64-bit only)EnterprisevvvvDatacentervvvvStandardvvvvFoundation (MS limit of 15 concurrent users)vvvvHyper-VvvvvTerminal ServicesvvvvWindows Server 2008Enterprise 32- and 64-bitvvvvDatacenter 32- and 64-bitvvvvStandard 32- and 64-bitvvvvHyper-VvvvvTerminal ServicesvvvvWindows Small Business Server 2011Premium and StandardvvvvWindows Small Business Server 2008Premium 64-bitvvvvStandard 64-bitvvvvWindows VistaEnterprise 32- and 64-bitvvvvUltimate 32- and 64-bitvvvvBusiness 32- and 64-bitvvvvHome Premium 32- and 64-bitXXvvHome Basic 32- and 64-bitXXvvWindows Server 2003*R2 Server 64-bitvvvv*Windows Server 2003 support is notR2 Server and Small Business Servervvvvincluded with PSQL v12 products.R2 Server Failover ClustervvvvR2 Server Terminal ServicesvvvvServer 64-bit (SP2)vvvvServer and Small Business Server (SP2)vvvvServer Terminal Services (SP2)vvXvFailover ClustervvXvWindows XP*Professional and Home (SP3)XXvv*Windows XP support is not includedProfessional 64-bit (SP2)XXvvwith PSQL v12 products.XP EmbeddedXXvvXP Embedded for Point of ServiceXXvvLinuxRed Hat Enterprise Linux 4, 5, and 6vvXvSUSE Linux Enterprise�10 and 11vvXvCitrixXenApp 6.0vvvvXenServer 5.6vvvvAll operating systems should be updated to their latest service packs.