On 07/13/2012 07:08 AM, Thomas Raschbacher wrote:
> Hi.
>
> I've been having problems with the databas upgrade from 2.2.17 to 3.0.2
> (postgresql 8.3).
>
> just a quick list of what I did:
>
> 1) dbmail-util -a (2.2.17)
> 2) backup DB
> 3) install dbmail 3.0.2
> 4) run dbmail_2_2-3_0 upgrade script
> 5) run dbmail-util -a (3.0.2)
> --> Error:
>
> Jul 12 15:02:52 server dbmail/maintenance[31422]: [0x748a31a510]
> EMERGENCY:[db] check_table_exists(+803): 2.0 database incompatible. You need
> to add the header tables.
> Jul 12 15:03:08 server dbmail/maintenance[31442]: [0x5655692390]
> EMERGENCY:[db] check_table_exists(+803): 2.0 database incompatible. You need
> to add the header tables.
My guess is there is a permission/ownership problem.
Try psql dbmail
dbmail=# \d
all tables, sequences and views must be owned by the db-user specified
in your dbmail.conf
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/i...@nfg.nl/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
