| From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
|---|---|
| To: | Alfredo Alcala <alfrealcala(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: move databases from a MySQL server to Postgresql. |
| Date: | 2023-06-23 11:58:01 |
| Message-ID: | e4271373-7b5f-7da5-f7e1-798adcd87b0b@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 6/23/23 13:45, Alfredo Alcala wrote:
> Hello
>
> I need to move some databases from a MySQL server to Postgresql.
>
> Can someone tell me the migration procedure, tools and recommendations?
>
I'm not an expect on this, but migrations tend to be somewhat
application-specific. I'd suggest you take a look at this wiki page:
https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
and maybe try some of the tools mentioned there (pgloader, mysql2pgsql,
and so on).
You'll have to give it a try on your databases, and then ask questions
about practical issues you run ran into.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolas Seinlet | 2023-06-23 12:08:38 | plan using BTree VS GIN |
| Previous Message | Laurenz Albe | 2023-06-23 11:47:09 | Re: synchronous_commit= remote_apply | "The transaction has already committed locally..." |