I recently had a system fubar that required building a new machine, which I installed RH7.3 and SL-1.8.7 on. My previous machine was running RH7.2 and SL-1.8.4. IIRC, I was running posgresql 7.2 on that machine as well as on this one.
Here are the headers from the backup that I am trying to restore: -- SQL-Ledger Backup -- Dataset: accounts -- Version: 1.8.4 -- Host: localhost -- Login: kmastin -- User: Keith Mastin -- Date: Mon Oct 7 18:55:52 2002 -- DELETE FROM acc_trans; COPY acc_trans FROM stdin; 10367 10004 -289.43 31.03.2002 \N 0 0 10367 10019 18.73 31.03.2002 \N 0 0 10367 10020 3.2 31.03.2002 \N 0 0 Here is the output of psql in restore: [kmastin@soldier kmastin]$ psql accounts < accounts-1.8.4.sql DELETE 937 DELETE 39 DELETE 0 ERROR: copy: line 1, pg_atoi: error in "21.06.2002": can't parse ".06.2002" lost synchronization with server, resetting connection DELETE 0 DELETE 87 NOTICE: copy: line 1, CopyReadNewline: extra fields ignored NOTICE: copy: line 2, CopyReadNewline: extra fields ignored NOTICE: copy: line 3, CopyReadNewline: extra fields ignored NOTICE: copy: line 4, CopyReadNewline: extra fields ignored NOTICE: copy: line 5, CopyReadNewline: extra fields ignored NOTICE: copy: line 6, CopyReadNewline: extra fields ignored NOTICE: copy: line 7, CopyReadNewline: extra fields ignored NOTICE: copy: line 8, CopyReadNewline: extra fields ignored NOTICE: copy: line 9, CopyReadNewline: extra fields ignored NOTICE: copy: line 10, CopyReadNewline: extra fields ignored NOTICE: copy: line 11, CopyReadNewline: extra fields ignored NOTICE: copy: line 12, CopyReadNewline: extra fields ignored NOTICE: copy: line 13, CopyReadNewline: extra fields ignored NOTICE: copy: line 14, CopyReadNewline: extra fields ignored NOTICE: copy: line 15, CopyReadNewline: extra fields ignored NOTICE: copy: line 16, CopyReadNewline: extra fields ignored NOTICE: copy: line 17, CopyReadNewline: extra fields ignored NOTICE: copy: line 18, CopyReadNewline: extra fields ignored NOTICE: copy: line 19, CopyReadNewline: extra fields ignored NOTICE: copy: line 20, CopyReadNewline: extra fields ignored NOTICE: copy: line 21, CopyReadNewline: extra fields ignored NOTICE: copy: line 22, CopyReadNewline: extra fields ignored NOTICE: copy: line 23, CopyReadNewline: extra fields ignored NOTICE: copy: line 24, CopyReadNewline: extra fields ignored NOTICE: copy: line 25, CopyReadNewline: extra fields ignored NOTICE: copy: line 26, CopyReadNewline: extra fields ignored NOTICE: copy: line 27, CopyReadNewline: extra fields ignored NOTICE: copy: line 28, CopyReadNewline: extra fields ignored NOTICE: copy: line 29, CopyReadNewline: extra fields ignored NOTICE: copy: line 30, CopyReadNewline: extra fields ignored NOTICE: copy: line 31, CopyReadNewline: extra fields ignored NOTICE: copy: line 32, CopyReadNewline: extra fields ignored NOTICE: copy: line 33, CopyReadNewline: extra fields ignored NOTICE: copy: line 34, CopyReadNewline: extra fields ignored NOTICE: copy: line 35, CopyReadNewline: extra fields ignored NOTICE: copy: line 36, CopyReadNewline: extra fields ignored NOTICE: copy: line 37, CopyReadNewline: extra fields ignored NOTICE: copy: line 38, CopyReadNewline: extra fields ignored NOTICE: copy: line 39, CopyReadNewline: extra fields ignored NOTICE: copy: line 40, CopyReadNewline: extra fields ignored NOTICE: copy: line 41, CopyReadNewline: extra fields ignored NOTICE: copy: line 42, CopyReadNewline: extra fields ignored NOTICE: copy: line 43, CopyReadNewline: extra fields ignored NOTICE: copy: line 44, CopyReadNewline: extra fields ignored NOTICE: copy: line 45, CopyReadNewline: extra fields ignored NOTICE: copy: line 46, CopyReadNewline: extra fields ignored NOTICE: copy: line 47, CopyReadNewline: extra fields ignored NOTICE: copy: line 48, CopyReadNewline: extra fields ignored NOTICE: copy: line 49, CopyReadNewline: extra fields ignored NOTICE: copy: line 50, CopyReadNewline: extra fields ignored NOTICE: copy: line 51, CopyReadNewline: extra fields ignored NOTICE: copy: line 52, CopyReadNewline: extra fields ignored NOTICE: copy: line 53, CopyReadNewline: extra fields ignored NOTICE: copy: line 54, CopyReadNewline: extra fields ignored NOTICE: copy: line 55, CopyReadNewline: extra fields ignored NOTICE: copy: line 56, CopyReadNewline: extra fields ignored NOTICE: copy: line 57, CopyReadNewline: extra fields ignored NOTICE: copy: line 58, CopyReadNewline: extra fields ignored NOTICE: copy: line 59, CopyReadNewline: extra fields ignored NOTICE: copy: line 60, CopyReadNewline: extra fields ignored NOTICE: copy: line 61, CopyReadNewline: extra fields ignored NOTICE: copy: line 62, CopyReadNewline: extra fields ignored NOTICE: copy: line 63, CopyReadNewline: extra fields ignored NOTICE: copy: line 64, CopyReadNewline: extra fields ignored NOTICE: copy: line 65, CopyReadNewline: extra fields ignored NOTICE: copy: line 66, CopyReadNewline: extra fields ignored NOTICE: copy: line 67, CopyReadNewline: extra fields ignored NOTICE: copy: line 68, CopyReadNewline: extra fields ignored NOTICE: copy: line 69, CopyReadNewline: extra fields ignored NOTICE: copy: line 70, CopyReadNewline: extra fields ignored NOTICE: copy: line 71, CopyReadNewline: extra fields ignored NOTICE: copy: line 72, CopyReadNewline: extra fields ignored NOTICE: copy: line 73, CopyReadNewline: extra fields ignored NOTICE: copy: line 74, CopyReadNewline: extra fields ignored NOTICE: copy: line 75, CopyReadNewline: extra fields ignored NOTICE: copy: line 76, CopyReadNewline: extra fields ignored NOTICE: copy: line 77, CopyReadNewline: extra fields ignored NOTICE: copy: line 78, CopyReadNewline: extra fields ignored NOTICE: copy: line 79, CopyReadNewline: extra fields ignored NOTICE: copy: line 80, CopyReadNewline: extra fields ignored NOTICE: copy: line 81, CopyReadNewline: extra fields ignored NOTICE: copy: line 82, CopyReadNewline: extra fields ignored NOTICE: copy: line 83, CopyReadNewline: extra fields ignored NOTICE: copy: line 84, CopyReadNewline: extra fields ignored NOTICE: copy: line 85, CopyReadNewline: extra fields ignored NOTICE: copy: line 86, CopyReadNewline: extra fields ignored NOTICE: copy: line 87, CopyReadNewline: extra fields ignored DELETE 0 DELETE 47 DELETE 90 DELETE 0 ERROR: copy: line 1, value too long for type character varying(5) lost synchronization with server, resetting connection DELETE 0 DELETE 35 DELETE 494 DELETE 35 DELETE 1 DELETE 2 DELETE 0 ERROR: copy: line 1, Bad float8 input format 'ea' lost synchronization with server, resetting connection DELETE 339 DELETE 3 DELETE 18 DELETE 48 DROP CREATE Then when I try to login to the sql-ledger/login.pl page, I get the following error: Error! Incorrect Dataset version! I checked the FAQ and found this: The dataset you are trying to use is not compatible with the version. When you upgrade datasets use the same database user in the "Connect to" field as the one listed in the Database section for the user. The database user on both machines is/was kmastin Since it's a new install, I need to import the data from the old system using psql, and obviously it's not going very well. In the database administration page, when I enter user "postgres" (or "kmastin") and connect to the "accounts" dataset to update the dataset, all seems to go well with "All Datasets up to date!" Subsequent logins with username kmastin as user postgres return with "User postgres does not exist!" error, yet the user postgres does exist when accessing postgresql from the command line. This is getting confusing, and I'm hopping someone can see what I'm dong wrong. Thanks again for taking the time to help.
