On 01/15/2014 02:54 PM, Wolfgang Denk wrote: > Dear Dimitri, >>> Basically whay I did is dumping the DB >>> under MySQL >> >>> and then importing the dump into PostgreSQL. >> >> That's why the sequences didn't get reinitialized properly. > > Would there have been a better way to do that?
Nope. The way to do it is what you've done: for each sequence/table+autoincrement-column select max(column) and then alter sequence. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ 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
