Hi Andreas,the Postgres drivers uses native sequence support so - yes - stick with the sequence definitions. We have those tables in mysql as it still does not have native sequences.
I would appreciate if you add the schema to the repo and make a pull request so we can include it in the official release.
best regards Oliver Am 07.02.2017 um 11:35 schrieb [email protected]:
Hello, I’m trying to convert the MySQL Schema to Postgres. I’m using Postgres right now so I think I must have got it from an earlier version of OpenXPKI but I’m not sure. If I take a look into the MySQL Schema the normal tables should be no problem. I can see that my Postgres setup is using sequences for the tables like seq_certificate where MySQL is using normal tables. So the question is should I stay with the sequences or should I use also tables? I have attached a dump of my Postgres DB structure. This is running on a VM and I would like to be sure that the structure looks fine before I import this to a QS / Productive instance. Could someone have a look if this looks fine? Thank you. Mit freundlichen Grüßen / Best regards Andreas Krieger ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
-- Protect your environment - close windows and adopt a penguin!
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
