Groups > comp.databases.postgresql > #678

Re: migrate from mysql to pgsql

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups	comp.databases.postgresql
Subject	Re: migrate from mysql to pgsql
Date	Sun, 01 Nov 2015 22:09:32 +0100
Organization	A noiseless patient Spider
Lines	13
Message-ID	<m2si4pjuk3.fsf@2ndQuadrant.fr> (permalink)
References	<n10ens$huf$1@news.m-online.net>
Mime-Version	1.0
Content-Type	text/plain
Injection-Info	mx02.eternal-september.org; posting-host="d82aa4f1883ab7155c995516303c9b46"; logging-data="20915"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/kJQW0y1uZ+LNpABQQvjJr"
User-Agent	Gnus/5.13001 (Ma Gnus v0.10) Emacs/24.5 (darwin)
Cancel-Lock	sha1:UaoUD7+DQCdkrQWYMORgDrEqUlo= sha1:R6ggCoDWvFOhxNWtSX8uW0hS7F4=
Xref	csiph.com comp.databases.postgresql:678

Show key headers only | View raw

Magnus Warker <magnux@mailinator.com> writes:
> I would like to migrate a mysql database to pgsql.
> I would like to do it table for table.

See pgloader:

  http://pgloader.io
  http://pgloader.io/howto/quickstart.html
  https://github.com/dimitri/pgloader

-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2015-10-30 20:00 +0100
  Re: migrate from mysql to pgsql Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2015-10-30 20:26 +0100
    Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2015-11-14 04:25 +0100
      Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-11-14 20:32 +0100
        Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2015-11-18 17:58 +0100
  Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-11-01 22:09 +0100
  Re: migrate from mysql to pgsql Luuk <luuk@invalid.lan> - 2015-11-02 09:18 +0100
  Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2016-01-06 06:43 +0100
    Re: migrate from mysql to pgsql Robert Klemme <shortcutter@googlemail.com> - 2016-01-06 13:08 +0100
      Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2016-01-06 13:35 +0100
    Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2016-01-06 21:31 +0100
      Re: migrate from mysql to pgsql Magnus Warker <magnux@mailinator.com> - 2016-01-31 06:21 +0100
        Re: migrate from mysql to pgsql Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2016-01-31 22:19 +0100

csiph-web