Re: [Ledger-smb-users] Migrating from 1.3.30 to 1.5.3

2017-02-27 Thread David G
Hi Bill, There are a few things in your script I'm not happy are correct. Unfortunately I can't get to a machine and confirm the best changes for another 4 hours or so. Once I'm back in the office I'll do that and responded with more info. You may find it useful to join us in Te support cha

Re: [Ledger-smb-users] Migrating from 1.3.30 to 1.5.3

2017-02-27 Thread bill Ott
Eric, I am migrating to new hardware. I use a virtual machine running the new OS as a test bed for each of the programs I am migrating. So, starting over again is a 10 minute job. Stop the virtual machine, delete the virtual machine file, copy the saved virtual machine file over and restart the

Re: [Ledger-smb-users] Migrating from 1.3.30 to 1.5.3

2017-02-27 Thread Erik Huelsmann
Hi Bill, On Mon, Feb 27, 2017 at 8:27 PM, bill Ott wrote: > Hi, Erik. Apparently I am not migrating this properly. The version from > the SQl select command was 1.3.30. > > I moved the database by doing "pg_dumpall -c > dumpdata" from the 1.3.30 > system but using the pg_dumpall program from th

Re: [Ledger-smb-users] Migrating from 1.3.30 to 1.5.3

2017-02-27 Thread bill Ott
Hi, Erik. Apparently I am not migrating this properly. The version from the SQl select command was 1.3.30. I moved the database by doing "pg_dumpall -c > dumpdata" from the 1.3.30 system but using the pg_dumpall program from the 1.5.3 system. I then issued "psql -f dumpdata postgres" on t

Re: [Ledger-smb-users] Migrating from 1.3.30 to 1.5.3

2017-02-27 Thread Erik Huelsmann
Hi Bill, On Mon, Feb 27, 2017 at 6:28 PM, bill Ott wrote: > I have successfully moved the database from ledgersmb 1.3.30 (postgresql > 9.1.7) to ledgersmb 1.5.3 (postgresql 9.5.6). I can do SQL selects in > either and get the same results. > Great news! Thanks for sharing! > When I attemp

[Ledger-smb-users] Migrating from 1.3.30 to 1.5.3

2017-02-27 Thread bill Ott
I have successfully moved the database from ledgersmb 1.3.30 (postgresql 9.1.7) to ledgersmb 1.5.3 (postgresql 9.5.6). I can do SQL selects in either and get the same results. When I attempt to access the database from ledgersmb 1.5.3 I get an error saying that the is a Database mismatch. T