Postgresql implementation

Jean Helou <[email protected]>
Newsgroups gmane.comp.jakarta.james.devel
Message-ID <CAP00-x_P2y-Q1Wi9YMWV7s8BFd=1Q9vgyCXCM2KNoOJ8ZeGs7g@mail.gmail.com>
Hello everyone,

I am looking into switching the scaling-pulsar-smtp from the JPA stack to
the Postgresql stack.
The scaling-pulsar-smtp assembly uses a SQL database to store
- domains
- users
- recipient rewrite tables
- mail repository url store

I naively used the JPA implementation to connect to a postgresql db so I
thought migrating would be easy enough : swith the implementation and
restart the server
Unfortunately it doesn't seem as easy as that :
the JPA implementation generated tables in the configured schema with a
`james_` prefix
- domains => `james_domain`
- mail repository url store => `james_mail_repos`
- users => `james_user`
- recipient rewrite tables => `james_recipient_rewrite`

whereas the postgresql implementation expects different table names:
- domains => `domains`
- mail repository url store => `mail_repository_url`
- users => `users`
- recipient rewrite tables => `rrt`

The name of the columns within each table are different too.
the objectives for the new implementation state that it is destined to
replace the jpa build but the migrating documentation only mentions
migrating the mailbox contents not migrating all the data from data-api ...
sounds like this is not going to help adoption of the new implem :grimacing:

Do you happen to have a migration tool I missed to help with switching
implementation ?

Thanks
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.