Do you use the provided update scripts? I did several installs, updates and
what not and found the procedure with these scripts pretty straight forward.
1) Did you remember to change the security settings for local use (in
/var/lib/pgsql/data/pg_hba.conf i believe)? That might cause the permission
denied errors. If that does not fix it, consider option
2) Updating both SQL and postgres a the same time might be a problem,
especially with exisiting 7.x database. I did a clean install, including
Postgres 8.
That leaves you to copy over /users /templates and /images by hand if you
changed anything there. The rest of the data is in the saved sql-file iirc.
Update that with the updatre scripts and follow the install howto if needed.
Plus: this works on new machine too, nice in case of update (or in my case
install to netbook)
Minus: manual copy fo some dirs and files and re-creation of users.
Create user(s) with database db_new_2.8.24, remeber to give the user a Pg
driver (via admin login). Then check if you can su postgres and do the psql
db_new_2.8.24 < db_old_2.6_1.sql
Hth
Paul
2009/4/16 <wj...@pa...>
> Further to below mail I managed to get a bit further but am now getting
> following error as soon as I try to login to the now updated (I think!)
> dataset:
> Error! SELECT * FROM defaults
> ERROR: permission denied for relation defaults.
>
> Quite puzzled as to what is going on.
>
>
>
> I am attempting to upgrade 2.6.1 database(PG 7.3) to version 2.8.24(with
> PG 8.3).
>
> Created new empty dataset "db_new_2.8.24",
> Fixed SETVAL etc as per FAQ in old database "db_old_2.6_1"
> then restore with psql db_new_2.8.24 < db_old_2.6_1.sql
>
> BUT getting scores of errors "relation xyz etc does not exist".
>
> I also tried fixing all the tables by putting "WITH OIDS" in
> db_old_2.6_1.sql but that does not work either (the inserts now appeared
> to work but getting same errors at the end - maybe INDEXES may be an
> issue)
>
> Any suggestions anyone?
> Thanks and regards
>
>
>
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today.
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
|
