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