Dear Thomas, In message <52d555c5.9070...@mtl.mit.edu> you wrote: > My guess is that during the migration from MySQL to Postgres, the > sequences in Bacula did not get seeded right and probably are starting > with a seed value of 1.
Do you have any idea why this would happen? Is this something I can influence? Are there any other variables that might hit by similar issues? > the filesetid field in the fileset table is automatically populated by > the fileset_filesetid_seq sequence. > > Run the following two queries and see what the results are - in > particular, see what the last_value is for the sequence. This should be > equal to the max value from the fileset table which it is in my Bacula > database. If not, you'll need to manually fix it via a sql update > command to the sequence. > > select max(filesetid) from fileset; > > select * from fileset_filesetid_seq; This is what I get: Enter SQL query: select max(filesetid) from fileset; +------+ | max | +------+ | 75 | +------+ Enter SQL query: select * from fileset_filesetid_seq; +-----------------------+------------+-------------+--------------+---------------------------+-----------+-------------+---------+-----------+-----------+ | sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called | +-----------------------+------------+-------------+--------------+---------------------------+-----------+-------------+---------+-----------+-----------+ | fileset_filesetid_seq | 4 | 1 | 1 | 9,223,372,036,854,775,807 | 1 | 1 | 32 | f | t | +-----------------------+------------+-------------+--------------+---------------------------+-----------+-------------+---------+-----------+-----------+ Enter SQL query: Sorry, my DB / sql knowledge is somewhat limited (read: non-existient). Could you please be so kind and tell me how I could fix that? Thanks in advance! Best regards, Wolfgang Denk -- DENX Software Engineering GmbH, MD: Wolfgang Denk & Detlev Zundel HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: w...@denx.de Of course there's no reason for it, it's just our policy. ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users