Le 02/04/2013 19:35, Rodrigo Renie Braga a écrit :
Hello everyone.
Hello
We're migrating our Bacula database from Postgres 8.4 to 9.2 and all
we've done so far is a generate a dump from 8.4 database (using the
9.2 pg_dump) and import it to the new server. And, of course, changing
the values in the Catalog section.
it seemed that this procedure worked just fine until I decided to run
a Restore job, which returns the following error AFTER i'm done
selecting the files to restore (when Bacula actually runs the Job):
*dir.ptibackup JobId 0: Fatal error: sql_create.c:102 Create DB Job record INSERT INTO
Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES
('job.restore.2013-04-02_14.17.32_05','job.restore','R','F','C','2013-04-02
14:17:17',1364923037,88,'') failed. ERR=ERRO: valor atual da sequência
"job_jobid_seq" ainda não foi definido nesta sessão
*
There's a error message there in Portuguese, but it says something like: "Current
value for sequence 'job_jobid_seq' was still not defined in this session".
I have NO idea why Bacula is returning this error, can anyone help?
Accordingly to the PostgreSQL documentation, you should use
pg_upgradecluster to migrate from one PostgreSQL cluster (8.4) to the
new one (9.2). I did it lately and it works like a charm :-)
George.
Thanks!
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
