Hi there,
is there an easy way to migrate an existing OTRS6 installation from MySQL to PostgreSQL? Wasn't able to find a howto or similar.
Regs,
Rob
OTRS6: Moving from MySQL to postgreSQL
Moderator: crythias
-
shipdownfall
- Znuny newbie
- Posts: 3
- Joined: 09 Feb 2021, 15:57
- Znuny Version: 6.0
- Real Name: Robert Heine
-
root
- Administrator
- Posts: 4250
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: OTRS6: Moving from MySQL to postgreSQL
Hi Rob,
Use the OTRSCloneDB add-on for this.
- Roy
Use the OTRSCloneDB add-on for this.
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
shipdownfall
- Znuny newbie
- Posts: 3
- Joined: 09 Feb 2021, 15:57
- Znuny Version: 6.0
- Real Name: Robert Heine
Re: OTRS6: Moving from MySQL to postgreSQL
Hi root,
thanks for you answer, by "OTRSCloneDB" you are referring to https://github.com/OTRS/OTRSCloneDB ?
Regs,
Rob
thanks for you answer, by "OTRSCloneDB" you are referring to https://github.com/OTRS/OTRSCloneDB ?
Regs,
Rob
-
root
- Administrator
- Posts: 4250
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: OTRS6: Moving from MySQL to postgreSQL
Yep
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
shipdownfall
- Znuny newbie
- Posts: 3
- Joined: 09 Feb 2021, 15:57
- Znuny Version: 6.0
- Real Name: Robert Heine
Re: OTRS6: Moving from MySQL to postgreSQL
After trying around a bit (and finding blob and unicode columns), I get tons of the following outputs.
Does that mean, my database is corrupted already? Using MariaDB-5.5 here; is there a better way to migrate to newer MySQL/MariaDB first, before moving to PostgreSQL?
Does that mean, my database is corrupted already? Using MariaDB-5.5 here; is there a better way to migrate to newer MySQL/MariaDB first, before moving to PostgreSQL?
You do not have the required permissions to view the files attached to this post.
-
root
- Administrator
- Posts: 4250
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: OTRS6: Moving from MySQL to postgreSQL
Hi,
Never seen this before. Please provide more details on the operating system, Perl version, character set and collation of the MariaDB.
- Roy
Never seen this before. Please provide more details on the operating system, Perl version, character set and collation of the MariaDB.
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?