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>
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

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