sql-ledger-users

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

[Jonathan W. <jw...@ma...>]

Hello,

I saw someone mention the other day that they are running SuSE 10.1 and they 
were having problems after installing SuSE updates because the data was too 
old for that version of Postgres - or something like that.

I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few 
years now, and I am about to make a fresh install and wanted to ask, is there 
a problem running the latest SQL-Ledger on SuSE 10.2?

Is there any version of PostgreSQL that is too new?

Thanks,

	JW

-- 

----------------------
jw...@ma... - System Administrator - Cedar Creek Software

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

[R P. <arc...@mt...>]

On Friday 09 February 2007 2:25 pm, Jonathan Wilson wrote:
> Hello,
> 
> I saw someone mention the other day that they are running SuSE 10.1 and they 
> were having problems after installing SuSE updates because the data was too 
> old for that version of Postgres - or something like that.
> 
> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few 
> years now, and I am about to make a fresh install and wanted to ask, is there 
> a problem running the latest SQL-Ledger on SuSE 10.2?
> 
> Is there any version of PostgreSQL that is too new?
> 
> Thanks,
> 
> 	JW
> 

The issue of newer versions of Postgresql....
Major version changes of Postgresql require you to backup you data.. do the upgrade.. then restore that data.
this is because the Postgresql developers have been known to change how Postgresql stores the data.
In other words... If you upgrade Postgresql.. the newer version can't read the older version's files.
Do search on the Postgresql site for info on upgrading between versions and it will explain all.

This has nothing to do with SQL-Ledger.

Cheers,
Roy

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

[Dirk E. S. <ds...@ca...>]

> Hello,
>
> I saw someone mention the other day that they are running SuSE 10.1 and
> they
> were having problems after installing SuSE updates because the data was
> too
> old for that version of Postgres - or something like that.
>
> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few
> years now, and I am about to make a fresh install and wanted to ask, is
> there
> a problem running the latest SQL-Ledger on SuSE 10.2?
>

We run installations of SQL-Ledger on SUSE 10.1 and OpenSUSE 10.2, no
problem at all. Migrating an existing installation between different
postgres versions might cause some haedaches, but this is not related to
the Linux flavour  you use.

-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

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

[Joseph A. M. <ja...@jo...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I had some problems with postgres yast online updates running on suse
10.1 - that required some minor tweaking - had to call in my computer
guy - but he quickly fixed it.


www.joemaffia.com



Dirk Enrique Seiffert wrote:
>> Hello,
>>
>> I saw someone mention the other day that they are running SuSE 10.1 and
>> they
>> were having problems after installing SuSE updates because the data was
>> too
>> old for that version of Postgres - or something like that.
>>
>> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a f=
ew
>> years now, and I am about to make a fresh install and wanted to ask, is
>> there
>> a problem running the latest SQL-Ledger on SuSE 10.2?
>>
>
> We run installations of SQL-Ledger on SUSE 10.1 and OpenSUSE 10.2, no
> problem at all. Migrating an existing installation between different
> postgres versions might cause some haedaches, but this is not related to
> the Linux flavour  you use.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFFznKC1Zo2InkR90QRAnoyAJ4oMNcR6lgUhJcrLE546kPaWOodQACdF7sK
RHn4D0XZfrCHtoZ/AmlqDTg=3D
=3DUfTR
-----END PGP SIGNATURE-----

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

[Paul T. <pt...@wa...>]

R Pennington schreef:
> On Friday 09 February 2007 2:25 pm, Jonathan Wilson wrote:
>   
>> Hello,
>>
>> I saw someone mention the other day that they are running SuSE 10.1 and they 
>> were having problems after installing SuSE updates because the data was too 
>> old for that version of Postgres - or something like that.
>>
>> I have been running an old 1.x version of SQL ledger on SuSE 9.0 for a few 
>> years now, and I am about to make a fresh install and wanted to ask, is there 
>> a problem running the latest SQL-Ledger on SuSE 10.2?
>>
>> Is there any version of PostgreSQL that is too new?
>>
>> Thanks,
>>
>> 	JW
>>
>>     
>
> The issue of newer versions of Postgresql....
> Major version changes of Postgresql require you to backup you data.. do the upgrade.. then restore that data.
> this is because the Postgresql developers have been known to change how Postgresql stores the data.
> In other words... If you upgrade Postgresql.. the newer version can't read the older version's files.
> Do search on the Postgresql site for info on upgrading between versions and it will explain all.
>
> This has nothing to do with SQL-Ledger.
>
> Cheers,
> Roy
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   
In my  personal  experience,  it is simpler to make a  backup using 
SQL-Ledger (save to file  or email)  and get that to a
USB stick / CD burner.

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

S.O.P here, proven to work even from desktop to portable.

Remember to fix rights to the sql-ledger dir and subdirs and edit the 
/var/lib/psql/data/pga_hba.conf.
Set services postgres and apache to startup at boot, then reboot once to 
make sure everything runs smooth.
Apart from that, peace of cake.

Heck, Suse 10.2 does the Ati x200 chipset in my Toshiba notebook without 
sweat.
With 10.1 I had to do all kind of commandline stuff to get the 
proprietary driver to boot up.
SInce all runs I did not bother this time round. All is well again ;-))

Greetz,
Paul

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 ================