6 ms·

I'd love to migrate to postgresql. Unfortunately none of the published tools work well.

Roboprog 15y ago
OK, I'll bite: what are the tools that MySQL is supporting that PostgreSQL isn't? PHP blog generation software, or some lower level, more general purpose tool???
- MostAwesomeDude 15y ago
  The biggest one is PHPMyAdmin. LAMP's a pervasive thing. (Not that I like LAMP, mind you, but it's important to be aware of why Pg hasn't made large dents in the MySQL market share over the past decade.)
  - jwingy 15y ago
    phppgadmin? I've used both (using phppgadmin right now), and they're similar enough. It's not as nice as phpmyadmin, but that shouldn't be a determining factor over whether to use mysql over postgresql.
  - Roboprog 15y ago
    Thanks for the feedback. That explains a lot then. I always preferred to use the command line, so that I could either make scripts, or at least screen shots, of changes made. Thus, my utter lack of concern about the admin GUIs. PostgreSQL has a kick-ass command line tool, with online help, GNU readline (including auto-complete), annd good output formatting options. Contrast with Oracle's sql*plus tool (yee-UCK!). I seem to remember mysql having at least readline, but not sure about the rest (probably comparable, but who knows).
- amccloud 15y ago
  I should clarify. None of the tools for migrating my (rather simple) mysql database to pg work well or at all... But on that note PgAdmin3 is pretty crap. At least on my mac.
  - Roboprog 15y ago
    Thanks for the clarification. I've noticed a lot of that in this thread: people started with MySQL, and now they have a serious code base dependent upon it. That is a tough problem to solve. Sorry.
    - amccloud 15y ago
      My code does not depend on mysql. If could reliably migrate the data from mysql to postgresql, i'd switch in a heart beat.
sheff 15y ago
I'm migrating an old MySQL based app to Postgres at the moment. Heres some of the things I'm looking at in addition to the base tools. 1) taps ( done by some people from Heroku ) : https://github.com/ricardochimal/taps https://github.com/ricardochimal/taps and http://adam.heroku.com/past/2009/2/11/taps_for_easy_database_transfers/ http://adam.heroku.com/past/2009/2/11/taps_for_easy_database... 2) mysql2psql : https://github.com/maxlapshin/mysql2postgres https://github.com/maxlapshin/mysql2postgres 3) Just slurping in the data via the FDW feature for 9.1 , http://www.pgxn.org/dist/mysql_fdw/1.0.0/ http://www.pgxn.org/dist/mysql_fdw/1.0.0/

OK, I'll bite: what are the tools that MySQL is supporting that PostgreSQL isn't? PHP blog generation software, or some lower level, more general purpose tool???

MostAwesomeDude 15y ago
The biggest one is PHPMyAdmin. LAMP's a pervasive thing. (Not that I like LAMP, mind you, but it's important to be aware of why Pg hasn't made large dents in the MySQL market share over the past decade.)
- jwingy 15y ago
  phppgadmin? I've used both (using phppgadmin right now), and they're similar enough. It's not as nice as phpmyadmin, but that shouldn't be a determining factor over whether to use mysql over postgresql.
- Roboprog 15y ago
  Thanks for the feedback. That explains a lot then. I always preferred to use the command line, so that I could either make scripts, or at least screen shots, of changes made. Thus, my utter lack of concern about the admin GUIs. PostgreSQL has a kick-ass command line tool, with online help, GNU readline (including auto-complete), annd good output formatting options. Contrast with Oracle's sql*plus tool (yee-UCK!). I seem to remember mysql having at least readline, but not sure about the rest (probably comparable, but who knows).
amccloud 15y ago
I should clarify. None of the tools for migrating my (rather simple) mysql database to pg work well or at all... But on that note PgAdmin3 is pretty crap. At least on my mac.
- Roboprog 15y ago
  Thanks for the clarification. I've noticed a lot of that in this thread: people started with MySQL, and now they have a serious code base dependent upon it. That is a tough problem to solve. Sorry.
  - amccloud 15y ago
    My code does not depend on mysql. If could reliably migrate the data from mysql to postgresql, i'd switch in a heart beat.

sheff 15y ago

I'm migrating an old MySQL based app to Postgres at the moment. Heres some of the things I'm looking at in addition to the base tools. 1) taps ( done by some people from Heroku ) : https://github.com/ricardochimal/taps https://github.com/ricardochimal/taps and http://adam.heroku.com/past/2009/2/11/taps_for_easy_database_transfers/ http://adam.heroku.com/past/2009/2/11/taps_for_easy_database... 2) mysql2psql : https://github.com/maxlapshin/mysql2postgres https://github.com/maxlapshin/mysql2postgres 3) Just slurping in the data via the FDW feature for 9.1 , http://www.pgxn.org/dist/mysql_fdw/1.0.0/ http://www.pgxn.org/dist/mysql_fdw/1.0.0/