- App Store
When you upgrade from one version of xTuple ERP to another, it is required that you upgrade the core xTuple software. For PostBooks users, this means the core PostBooks database must be upgraded. For commercial edition users, this means the core commercial database must be upgraded. Performing an upgrade to the core software is a prerequisite for moving from one version of xTuple ERP to the next. xTuple provides assistance with this process through its XTN (xTuple Network) service.
The xTuple Desktop client software runs on Windows (XP and up), Mac OS X (Snow Leopard and up), and Linux (recent version of Ubuntu, RHEL, or CentOS recommended). The xTuple Mobile Web client is optimized for the Chrome browser.
It is not always necessary, however, to upgrade the extension packages or other applications which operate with xTuple. That's where this compatibility matrix comes in. This matrix is designed to help ensure your extension packages and other applications are compatible with the xTuple ERP version you are currently running—or upgrading to. The following packages and applications are covered by this document:
- xTuple Connect
- Wholesale Distribution
- Time and Expense
- Project Accounting
- Enhanced Commissions
- QuickStart Wizard
- Desktop Package
- Fixed Assets
If you are a third-party application developer and would like to have your application information added to this compatibility matrix, we invite you to help us keep this matrix up-to-date.
xTuple Connect is a commercial application which operates with all xTuple ERP Editions. The xTuple Connect application consists of two parts: a GUI client and an extension package (xtbatch). The xTuple Connect GUI client version will always be the same as the xTuple Connect extension package version.
* Connect 3.6.1 cannot be installed for the first time on xTuple ERP 3.8.x. Upgrading your existing xTuple Connect to 3.6.1 is supported.
xTuple ERP versions prior to 3.0 are not supported on PostgreSQL 8.3.x. Also, as of xTuple ERP 3.8.x, versions of PostgreSQL prior to 8.4.x are not supported. If you are running xTuple 2.3.2 or older, you should not be running on PostgreSQL 8.3 or newer.
ALSO NOTE: Users who load backup files (e.g., empty.backup, quickstart.backup, and demo.backup) should be advised that as of xTuple 3.2.2 those backup files are being dumped from a PostgreSQL 8.3 database. That means the backups must also be loaded on PostgreSQL 8.3 (or higher) to avoid backward incompatibility problems.
|xTuple version||PostgreSQL Version|
|4.4.x - 4.5.x||9.1 - 9.3|
|4.1.x - 4.3.x||8.4 - 9.1|
|4.0.x||8.4 - 9.1|
xWD is a collection of core enhancements and extension packages designed to extend xTuple ERP to serve the Wholesale Distribution community.
The Time and Expense package (xttelite) is a free extension package which operates with all xTuple ERP Editions.
The Project Accounting package (xtprjaccnt) is a commercial package which can be added to any edition of xTuple ERP.
The Enhanced Commissions package (xtcommission) is a commercial package which can be added to any edition of xTuple ERP.
The QuickStart Wizard package (xtsetup) is a commercial extension package which operates with all xTuple ERP Editions. For the QuickStart Wizard to work, you must have the Desktop package (xtdesktop) installed.
The Updater is a free application used for upgrading databases and loading extension packages. The Updater may be used with all xTuple ERP Editions.
The Desktop package (xtdesktop) is a free extension package which operates with all xTuple ERP Editions.
|4.6.x - 4.2.x||4.0.x - 4.1.x|
The Fixed Asset Management packages are a series of packages available for all xTuple Editions. The following table indicates the xTuple and PostgreSQL database versions the packages have been tested on.
|Package||Package Version||xTuple Version||PostgreSQL Version|
|3.6.x||3.8.x||8.4||8.4 - 9.1|
|Fixed Asset (free extension package)||1.0.x||X||X|
|Fixed Asset Depreciation||1.0.x||X||X|
|Fixed Asset Maintenance||1.0.x||X||X|
Wed, 05/05/2010 - 10:02#1
.qm files included in compatibility matrix
I am using xTuple Postbooks Edition V.3.3.0. I have not updated to newer versions because in the translation portal the only .qm file available for spanish is for this older 3.3.0. It would be good to include the available translation files in this compatibility matrix.
Mon, 05/10/2010 - 14:03#2
The 3.5.0 .qm files are available on the translation portal now. We upgraded all the projects last week. Meanwhile, older .qm files are generally compatible with newer xTuple versions. But, to your point, using the .qm version to match your xTuple version is always a good idea.
Sun, 07/31/2011 - 12:47#3
I have purchased a Quickstart wizard for version 3.6 .. Will this wizard work for version 3.7.0 which i have just installed?
Wed, 11/30/2011 - 10:51#4
Does the Enterprise edition upgrade gz file include the upgrade of xtbatch/xtconnect, xtprjacct, xtdesktop, and te packages? I am preparing to upgrade from 3.6.0 to 3.7.0.
Wed, 11/30/2011 - 10:55#5
I've converted this question to a support ticket. Let's take up the conversation there.
Mon, 02/13/2012 - 12:02#6
xt desktop package
How about the xtdesktop? Will the latest 3.7.1 work with 3.7.x and 3.8.x of the xtcore?
Tue, 09/04/2012 - 14:20#7
Can't believe I have never discovered this post until now! Thank you!
Wed, 01/23/2013 - 12:57#8
Upgrading From xTuple 3.5.4 to xTuple 4.0
If we wanted to upgrade from xTuple 3.5.4 to xTuple 4.0, what would be the process? Here is what have right now.
xTuple 3.5.4 Clients running on PostgreSQL 8.4.15 Server
Would I need to update the PG server to 9.1? The DB Matrix says it should work, but when I try to run XT 4.0 client gui, it fails against pg 8.4. I am guessing it would need to be updated even though the above compat matrix says otherwise. Thank you very much!
Wed, 01/23/2013 - 13:13#9
I was also looking at using an update script to do the job, but there only seems to be script from the database immediately previous to the one in question (ie. 3.5.3 to 3.5.4) How would I update from one severl generations apart (3.5.4 - 4.0.0 or 4.0.1)? Would I have update one level at a time? That is a lot of work and a lot o chances for error it would seem.
Wed, 11/20/2013 - 10:29#10
Not compatible with new PostgreSQL
Trying use the updater or postbooks with PostgreSQL 9.2 fails. One reason is the name of a column has changed in pg_stat_actvivty; procpid is now pid.
I try to keep my servers up to date. PostgreSQL 9.1 is not even available on Fedora 19.
I know that PostBooks 4.2 just released, is there a version coming that will work with the most recent PostgreSQL?
Wed, 11/20/2013 - 11:40#11
4.3 Beta, which is close to
4.3 Beta, which is close to being ready for publishing, will have a fix for the Postgres pid problem.
Wed, 11/20/2013 - 13:31#12
Mon, 04/21/2014 - 11:40#13
Trying to use the updater to
Trying to use the updater to update PostBooks using PostgreSQL 9.2.6 get the error:
A System Error occurred at login2.cpp::373:
ERROR: column "procpid" does not exist
LINE 1: SELECT pg_try_advisory_lock(datid::integer, procpid)
QUERY: SELECT pg_try_advisory_lock(datid::integer, procpid)
WHERE(procpid = pg_backend_pid())
CONTEXT: PL/pgSQL function login(boolean) line 10 at PERFORM
PL/pgSQL function login() line 9 at RETURN
How can I upgrade to the newer PostBooks versions using pb42xto430.gz and pb43xto440.gz if the updater will not connect to the database?
Mon, 04/21/2014 - 12:24#14
What is the current (working)
What is the current (working) version that you have installed (xTuple and PostgreSQL)?
Note that the matrix above clearly states that PostgreSQL 9.2 isn't supported until xTuple 4.4.
Mon, 04/21/2014 - 14:04#15
I have XTuple 4.2 and
I have XTuple 4.2 and PostgreSQL 9.1.7
I just thought that the updater should be able to update an older xTuple to a newer one.
If I understand correctly, I have to update to 4.4 using the xTuple updater to get the database updated, then I can export the xTuple database and import it to PostgreSQL 9.2
Will the updater work in the future against PostgreSQL 9.2 after I upgrade to xTuple 4.4? Or will I have to keep a PostgreSQL 9.1 around indefinitely in order for the updater to work?
Mon, 04/21/2014 - 15:12#16
The Updater application only
The Updater application only updates the xTuple database (think of it as one file) - not the PostgreSQL database server. So you are correct, use the Updater to upgrade from 4.2 to 4.4, and confirm that everything is working correctly before attempting to upgrade the database server.
Once that's all looking good, then yes, dump the database to a file, and you can then restore that file to a PostgreSQL 9.2 database server.
The Updater application should work fine with PostgreSQL9.2 once you've followed the above steps.
Mon, 04/21/2014 - 16:32#17
Thanks. Up on PostgreSQL
Up on PostgreSQL 9.2 with xTuple 4.4
Tue, 07/15/2014 - 13:02#18
4.5.1 on PostgreSQL 9.3.4
I checked this compatibility matrix before upgrading my system. The matrix indicates that 4.4.x on 9.1 - 9.3. Of course that does not say anything about 4.5.1.
I upgraded using the updater and postbooks-upgrade-451.gz. It said it updated the database. I installed the 4.5.1 GUI client. When I try to run xTuple, I get an error:
"A connection could not be established with the specified Database as the Proper Database Drivers
have not been installed. Contact your Systems Administrator."
When run from a console, these additional lines are output:
Fontconfig error: "/etc/fonts/conf.d/10-scale-bitmap-fonts.conf", line 70: non-double matrix element
Fontconfig error: "/etc/fonts/conf.d/10-scale-bitmap-fonts.conf", line 70: non-double matrix element
Fontconfig warning: "/etc/fonts/conf.d/10-scale-bitmap-fonts.conf", line 78: saw unknown, expected number
Fontconfig warning: "/etc/fonts/conf.d/65-0-lohit-bengali.conf", line 32: unknown element "langset"
Fontconfig warning: "/etc/fonts/conf.d/69-gnu-free-sans.conf", line 24: unknown element "langset"
Fontconfig warning: "/etc/fonts/conf.d/69-gnu-free-serif.conf", line 24: unknown element "langset"
Tue Jul 15 13:49:52 2014 Warning: QSqlDatabase: QPSQL7 driver not loaded
Tue Jul 15 13:49:52 2014 Warning: QSqlDatabase: available drivers: QSQLITE
Fortunately, I have a backup server that is still running PostgreSQL 9.2.8. I upgraded that database to 4.5.1 and installed the 4.5.1 client and it runs fine.
Would appreciate guidance.
Thu, 07/17/2014 - 09:48#19
4.5.1 on PostgreSQL 9.3.4 - Solved
I found the issue.
I am using 64 bit OS and xTuple GUI 4.5.1 requires 32 libraries.