Re: Backup and restore

[Dieter S. <dsi...@sq...>]

The columns are not in the right order.

You could re-arrange the ar and parts tables or save the schema and
re-create your new database from the existing. This way they will match.

Or reorder the columns in the sql/Pg-tables.sql file to match yours and
create a new dataset.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sun, 3 Mar 2002, David A. Bandel wrote:

> Hey folks,
> 
> Got a question about the backup and restore.
> 
> I have one system I've upgraded from like version 1.2 all the way to
> current (1.8.2).  Previously I did backups (OK, still do) from a command
> line and they worked fine.  Thought I'd give Dieter's backup a try.
> 
> So I installed another box, set up the database (empty), and tried to
> restore from the backup file (after all, that's what I'd do if the hard
> drive crashed).
> 
> However, some tables are giving me fits.  Here are the error messages from
> the restore (I used a command line \i <filename.db> to restore):
> psql:pananix.db:347: ERROR:  copy: line 1, Bad date external
> representation '10071' psql:pananix.db:347: PQendcopy: resetting
> connection and:
> psql:pananix.db:671: ERROR:  copy: line 1, Bad float8 input format
> '06-02-2002' psql:pananix.db:671: PQendcopy: resetting connection
> 
> I suspect for some reason the columns are being input in the wrong order. 
> The specific tables are: DELETE FROM ar;
> COPY ar FROM stdin;
> 10091   1001    21-11-2000      10071   0       502.5   500     502.5  
> 07-12-2000      20-12-2000      1       FOB David       30      \N      \N
>      \N
> 
> and:
> DELETE FROM parts;
> COPY parts FROM stdin;
> 10264   LS-Desktop      Complete Linux System Installed & Configured    ea
>      550     795     \N      06-02-2002      3.5     -1      \N      0    
>   0       0       0       10058   10063   10046   \N      0
> 
> When I created the original database, it only had the default table, so
> that's what I set up via the admin screen with 1.8.2 (Default dataset). I
> figured it'd be closest to the original from 1.2 (with all the updates). 
> 
> Thoughts, ideas, ???
> 
> Thanx,
> 
> David A. Bandel
>