From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 11328138330 for ; Wed, 10 Jan 2018 22:48:41 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 7D0E8E0C3F; Wed, 10 Jan 2018 22:48:36 +0000 (UTC) Received: from smtp.gentoo.org (mail.gentoo.org [IPv6:2001:470:ea4a:1:5054:ff:fec7:86e4]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 0D39BE0C14 for ; Wed, 10 Jan 2018 22:48:36 +0000 (UTC) Received: from martineau.localdomain (unknown [24.51.165.37]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: titanofold) by smtp.gentoo.org (Postfix) with ESMTPSA id DEB49335C47 for ; Wed, 10 Jan 2018 22:48:34 +0000 (UTC) Received: by martineau.localdomain (Postfix, from userid 1000) id C1AB0C69AA6F; Wed, 10 Jan 2018 17:48:32 -0500 (EST) Date: Wed, 10 Jan 2018 17:48:32 -0500 From: "Aaron W. Swenson" To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] News Item: GnuCash 2.7+ Breaking Change Message-ID: <20180110224832.GH15225@martineau.grandmasfridge.local> Mail-Followup-To: gentoo-dev@lists.gentoo.org References: <20180110183135.GD15225@martineau.grandmasfridge.local> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="o7gdRJTuwFmWapyH" Content-Disposition: inline In-Reply-To: <20180110183135.GD15225@martineau.grandmasfridge.local> User-Agent: Mutt/1.7.2 (2016-11-26) X-Archives-Salt: c0520d70-e09f-48be-bbda-92ad07590623 X-Archives-Hash: 0f7bbdf3fd6f12801bfd31485cd27dd8 --o7gdRJTuwFmWapyH Content-Type: multipart/mixed; boundary="9jHkwA2TBA/ec6v+" Content-Disposition: inline --9jHkwA2TBA/ec6v+ Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Modified a bit. This should show for anyone who has GnuCash installed. The 2.7.3 ebuild I have in my overlay does have a postinst note about this as well, but I think this is important enough to tell them as soon as possible and on systems that may never have had GnuCash installed but will be working with files/databases that are made by GnuCash 2.6. Title: GnuCash 2.7+ Breaking Change Author: Aaron W. Swenson Posted: 2018-01-10 Revision: 1 News-Item-Format: 2.0 Display-If-Installed: app-office/gnucash Along with changes to updates to use modern libraries, GnuCash 2.7+ has changed the schema [1] it uses for both databases and files. GnuCash will automatically modify the file or database in place upon open. Therefore, it is imperative that you back up any files or databases before using GnuCash 2.7 in case you run into an issue and want or need to revert back to 2.6. Instructions for backing up are as follows: For XML (plain files): $ cp /path/to/file.gnucash /path/to/file.gnucash.bak For MySQL: $ mysqldump gnucash_db | mysql gnucash_db_bak For PostgreSQL: $ createdb -U dbadmin -T gnucash_db -O gnucash_user gnucash_db_bak For SQLite: $ cp /path/to/gnucash/sqlite.file.gnucash /path/to/gnucash/sqlite.file.gnucash.bak [1] https://github.com/Gnucash/gnucash/releases/tag/2.7.0a --9jHkwA2TBA/ec6v+ Content-Type: text/plain; charset=utf-8 Content-Disposition: attachment; filename="2018-01-08-GnuCash-Breaking-Change.en.txt" Title: GnuCash 2.7+ Breaking Change Author: Aaron W. Swenson Posted: 2018-01-10 Revision: 1 News-Item-Format: 2.0 Display-If-Installed: app-office/gnucash Along with changes to updates to use modern libraries, GnuCash 2.7+ has changed the schema [1] it uses for both databases and files. GnuCash will automatically modify the file or database in place upon open. Therefore, it is imperative that you back up any files or databases before using GnuCash 2.7 in case you run into an issue and want or need to revert back to 2.6. Instructions for backing up are as follows: For XML (plain files): $ cp /path/to/file.gnucash /path/to/file.gnucash.bak For MySQL: $ mysqldump gnucash_db | mysql gnucash_db_bak For PostgreSQL: $ createdb -U dbadmin -T gnucash_db -O gnucash_user gnucash_db_bak For SQLite: $ cp /path/to/gnucash/sqlite.file.gnucash /path/to/gnucash/sqlite.file.gnucash.bak [1] https://github.com/Gnucash/gnucash/releases/tag/2.7.0a --9jHkwA2TBA/ec6v+-- --o7gdRJTuwFmWapyH Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iNUEAREKAH0WIQRPTtQ2xj0Ap7RjpAAol2NzYdYtXQUCWlaYQF8UgAAAAAAuAChp c3N1ZXItZnByQG5vdGF0aW9ucy5vcGVucGdwLmZpZnRoaG9yc2VtYW4ubmV0NEY0 RUQ0MzZDNjNEMDBBN0I0NjNBNDAwMjg5NzYzNzM2MUQ2MkQ1RAAKCRAol2NzYdYt XfMcAP9veUHqRaPDNKSklCyRssuEMo/IDcNcpRJiUc0dYKr4xwD+JfLq4i9+MNwf UHxW4chzY9LO4+dYJVidGoO2L/8hXl4= =sI4O -----END PGP SIGNATURE----- --o7gdRJTuwFmWapyH--