Dear Dimitri, In message <52d5c764.4050...@bmrb.wisc.edu> you wrote: > > > I didn't use any precanned procedure (is there one? I mean a > > recommended/working one?). Basically whay I did is dumping the DB > > under MySQL=20 > > > 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? > > Enter SQL query: alter sequence fileset_filesetid_seq restart with = > 76; > > Query failed: ERROR: must be owner of relation fileset_filesetid_s= > eq > > Interesting... "select current_user" will tell you what role name > bconsole is using. It was "postgres". > With psql you can connect as any role: > > psql -U <username w/ id 10> -d <bacula database name> Indeed, running as user "postgres" fixed the issue. Thanks a lot! 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 God is real, unless declared integer. ------------------------------------------------------------------------------ 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
