change Data base mysql to pg

1. Create same database(database_name-thera_dev) both rails application in mysql and pg

2. Import sql file in mysql rails application.

3. then run this command for pg rails application .

"pgloader mysql://root:root@127.0.0.1/DATABASE_NAME_SAME postgresql://root:root@127.0.0.1/DATABASE_NAME_SAME"

4. then Export pg dupm file---this command run pg application

pg_dump -U root DATABASE_NAME_SAME > sql_file_name.sql

Then Enter Password.

Comments

Post a Comment

Popular posts from this blog

rvm setup new ruby install system

  # Install rbenv $ brew install rbenv # Completely uninstall rbenv $ brew uninstall rbenv # list all available versions $ rbenv install -l # install a specific Ruby version $ rbenv install 2.3.0 # Sets a local application-specific Ruby version # by writing the version name to a `.ruby-version` $ rbenv local 2.2.2 # Sets the global version of Ruby to be used in all shells # by writing the version name to the `~/.rbenv/version` file $ rbenv global 2.2.1 # Sets a shell-specific Ruby version by setting the # RBENV_VERSION environment variable in your shell. $ rbenv shell 2.2.1 # Lists all Ruby versions known to rbenv $ rbenv versions # Displays the currently active Ruby versions $ rbenv version # Run this command after you install a new version of Ruby, # or install a gem that provides commands. $ rbenv rehash # Displays the full path to the executable that rbenv will # invoke when you run the given command $ rbenv which irb
Read more

masking account number

 <script type="text/javascript">   $('#acnumber').text(function(_, str) {     return str = str.replace(/\d(?=\d{4})/g, "X");   }); </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="ccnumber">1234567891234567</div>
Read more

Ruby install for new system

  sudo apt install curl curl -sL https: //deb.nodesource.com/setup_12.x | sudo -E bash - curl -sS https: //dl.yarnpkg.com/debian/pubkey.gpg | sudo apt-key add - echo "deb https://dl.yarnpkg.com/debian/ stable main" | sudo tee /etc/apt/sources.list.d/yarn.list sudo apt-get update sudo apt-get install git-core zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev software-properties-common libffi-dev nodejs yarn sudo apt-get install libgdbm-dev libncurses5-dev automake libtool bison libffi-dev gpg --keyserver hkp: //keys.gnupg.net --recv-keys 409B6B1796C275462A1703113804BB82D39DC0E3 7D2BAF1CF37B13E2069D6956105BD0E739499BDB Got this error: gpg: keyserver receive failed: Server indicated a failure -------------------------------------------------------------------------------------------------- Then run for this command:  curl -sSL https: //get.rvm.io | bash -s stable then got this error: Downl...
Read more