Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    13

    Unanswered: Migrate database from mysql to postgresql

    I am working under LINUX. I have created a database in mysql. How can i transfer database from mysql to postgres.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    take a look at PostgreSQL Migrating from other Databases to PostgreSQL. There are quite a few references which deal with migrating MySQL to PostgreSQL. Note that any of them refer to older versions of PostgreSQL, so don't take the exact directions literally. They do a good job of describing how to perform the job, but unless you're running an outdated version of PostgreSQL (and if you are, you shouldn't be) treat them as general guidelines.

    For instance, I recommend pgAdminIII, which comes with PostgreSQL v8, rather than psql. Later versions also have additional functionality.

    I also believe (verify at the postgresql.org site) that there's an add-on project so that individuals could add some of MySQL's non-standard functions and views to Postgresql, to make migration easier.
    Last edited by loquin; 11-17-06 at 12:52.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •