Hi Oliver, when I try to upload the schema to openxpki/config then I get the error:
"Uploads are disabled. File uploads require push access to this repository." I just have created this account so maybe this is the issue? Or did I have to upload the file somewhere else? I haven't uploaded anything to github yet :) Mit freundlichen Grüßen / Best regards Andreas Krieger -----Ursprüngliche Nachricht----- Von: Oliver Welter [mailto:[email protected]] Gesendet: Donnerstag, 9. Februar 2017 15:39 An: [email protected] Betreff: Re: [OpenXPKI-users] Converting MySQL Schema to Postgres 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! ------------------------------------------------------------------------------ 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
