Yes -- but turns out the Update routine must be run by the postgres user even if another user created the database.
Thanks for your help. Steve Doerr wrote: > Did you update the correct dataset? > > per the FAQ: > > > "Incorrect Dataset version > > The dataset you are trying to use is not compatible with the version. > When you upgrade datasets use the same database user in the "Connect to" > field as the one listed in the Database section for the user." > > So if user "Joe" uses db "acctglive", then those would go in the User > and Connect To fields. > > That script doesn't create a database. > > Good luck, > Steve > > Lee Hughes wrote: > >> More background on this: I tried it on a test server where I have >> superuser rights and it worked fine. Could the Update Dataset routine >> be failing but giving me a bogus status message because my PostgreSQL >> account does not have CreateDatabase rights? >> >> Thanks much for any help, I need to get this resolved quickly... >> >> Lee Hughes wrote: >> >>> I moved my 1.8.0 data onto a new server with a fresh install of >>> 1.8.7. I did the Update Dataset operation but got "All Datasets up to >>> date!" However when I try to log in I get "Error! Incorrect Dataset >>> version!" >>> >>> Please help! >>> >>> Thanks, Lee >>> >>> >>> >>> ------------------------------------------------------- >>> Sponsored by: AMD - Your access to the experts on Hammer Technology! >>> Open Source & Linux Developers, register now for the AMD Developer >>> Symposium. Code: EX8664 http://www.developwithamd.com/developerlab >>> ------------------------------------------------------- >>> (un)subscribe: >>> http://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>> Archive: http://www.mail-archive.com/[email protected]/ >> >> >> >> >> >> ------------------------------------------------------- >> Sponsored by: AMD - Your access to the experts on Hammer Technology! >> Open Source & Linux Developers, register now for the AMD Developer >> Symposium. Code: EX8664 http://www.developwithamd.com/developerlab >> ------------------------------------------------------- >> (un)subscribe: >> http://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> Archive: http://www.mail-archive.com/[email protected]/ >> > > > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: AMD - Your access to the experts > on Hammer Technology! Open Source & Linux Developers, register now > for the AMD Developer Symposium. Code: EX8664 > http://www.developwithamd.com/developerlab > ------------------------------------------------------- > (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive: http://www.mail-archive.com/[email protected]/ ------------------------------------------------------- This SF.NET email is sponsored by: AMD - Your access to the experts on Hammer Technology! Open Source & Linux Developers, register now for the AMD Developer Symposium. Code: EX8664 http://www.developwithamd.com/developerlab ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
