On 01/14/2014 04:57 PM, Wolfgang Denk 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
> and then importing the dump into PostgreSQL. That's why the sequences didn't get reinitialized properly. > Enter SQL query: alter sequence fileset_filesetid_seq restart with 76; > Query failed: ERROR: must be owner of relation fileset_filesetid_seq Interesting... "select current_user" will tell you what role name bconsole is using. > SELECT c.relname,c.relowner FROM pg_class c WHERE c.relkind = 'S'; > +-----------------------------------+----------+ > | relname | relowner | > +-----------------------------------+----------+ > | filename_filenameid_seq | 10 | > OK, now I know which sequences I have to check, but I still don't know > what owner "10" means... "select * from pg_user" will give you username and userid -- see if userid 10 and the role from bconsole match. Or run select usename from pg_user where usesysid=10; With psql you can connect as any role: psql -U <username w/ id 10> -d <bacula database name> then you'll have update permissions. -- 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
