Re: [SL] Will SQL-Ledger run ok on SuSE 10.2, or, is there any version of PostgreSQL that's too new?

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

On Mon, 12 Feb 2007, Paul Tammes wrote:
>
> Then simply do a fresh OpenSuse 10.2 install,  install required
> packages as per  the readme, install  using the sql-ledger setup.
> Again as per readme / FAQ Make database using admin.pl and than do a
> psql  <  backup.sql

do not create a database with admin.pl, a restore will fail if the 
versions are different. Use psql to create a blank database and restore.

restoring from a 1.x version is a bit different because the schema has to 
be recreated from the sql files. A 1.x backup does not contain the schema. 
I don't recall when I added the schema but if there are none of the 
"CREATE TABLE suchandsuch' in the backup then the schema has to be created 
with the same version dataset first before a restore can be done.

createdb -U sql-ledger dbname
psql -U sql-ledger dbname < Pg-tables.sql
psql -U sql-ledger dbname < backup.sql
psql -U sql-ledger dbname < Pg-indices.sql

If the schema is in the backup all you need to do is

createdb -U sql-ledger dbname
psql -U sql-ledger dbname < backup.sql

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