IMPORT AND EXPORT DATABASE IN POSTGRES

-

Create postgres database using command line:-

createdb -h localhost -p 5432 -U postgres dbname

Import database

psql -h localhost -U username -d dbname -f /filepath/filename.sql

Import AWS RDS dump file:

Example :  pg_dump -Fc -v -h [endpoint of instance] -U [master username] [database] > [database].dump

pg_dump -Fc -v -h example-database.ctctk95487r5.us-east-1.rds.amazonaws.com -U rohit Blogger > blogger.dump

password:  rohit

Or

pg_restore -U username -d dbname -1 filename.dump

Or

pg_restore -h localhost -U root -W -F t -d dbname db_dump_file.tar 

Or

pg_restore -h localhost -p 5432 -U postgres -d databasename -v "pro.dump"

Export database

pg_dump -U postgres databasename > filename.sql

Export AWS RDS dump file in local database:

Example :  pg_restore -v -h [endpoint of instance] -U [master username] -d [new database name] [database].dump

pg_restore -v -h localhost -U postgres -d Blogger blogger.dump

Comments

Post a Comment

Popular posts from this blog

CARRIERWAVE - UPLOAD ANY MEDIA (AUDIO , VIDEO AND IMAGE ) FILE IN RAILS

-
Image
UPLOADING ANY MEDIA FILE WITH CARRIER-WAVE RAILS Multiple file uploads Add it to your Gemfile:      gem 'mime-types'
      gem 'mini_magick'
      gem 'rmagick'
      gem 'carrierwave', '~> 1.0'
      gem 'carrierwave-video'
      gem 'carrierwave-video-thumbnailer'
      gem 'carrierwave-ffmpeg'
Run
      bundle
Start off by generating an uploader:app/uploaders/vimeo_uploader.rb      rails generate uploader Vimeo Check out this file for some hints on how you can customize your uploader. It should look something like this:class VimeoUploader < CarrierWave::Uploader::Base
storage :file
end If we want to upload video or image then we will have to use :-class VimeoUploader < CarrierWave::Uploader::Base
include CarrierWave::MiniMagick
      include CarrierWave::Video
      include CarrierWave::Video::Thumbnailer
      include CarrierWave::FFmpeg

      storage :file
      def store_dir
         "uploads/#{model.class.to_s.undersc…
Read more

RAILS: UPLOADING PHOTOS VIA AMAZON S3 AND PAPERCLIP (UPLOADING FILES TO S3 IN RUBY WITH PAPERCLIP)

-
Set up Ruby on Rails with Paperclip and S3 using AWS SDK
Uploading Files to S3 in Ruby with Paperclip Paperclip requires the following gems added to your Gemfile. If your paperclip version is 5.1.0 then we are using 'aws-sdk' version 2.3.# Gemfile
gem 'paperclip'
gem 'aws-sdk', '~> 2.3' or our paperclip version is 4.1.0 then we need to use 'aws-sdk' version < 2  (note: add version less than 2.0 otherwise you will get paperclip error)gem 'paperclip'
gem 'aws-sdk', '< 2.0'

Run bundle install and restart the Rails server after modifying the Gemfile. Then run the command :-rails generate paperclip user image Define the file attribute in the Modelclass User < ActiveRecord::Base
    has_attached_file :image, styles: { medium: "300x300>", thumb: "100x100>" }, default_url: "/images/:style/missing.png"
      validates_attachment_content_type :image, content_type: /\Aimage\/.*\z/
end Migration…
Read more

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

-
Country State Select is a library that provides an easy API to generate Country , State / Province and City dropdowns for use in forms.We will refer :-

https://github.com/arvindvyas/Country-State-Select Gemfilegem 'chosen-rails'
gem 'country_state_select', git: 'git://github.com/arvindvyas/Country-State-Select', branch: :master
gem "simple_form"#, "~> 3.2"
gem "reform"#, "~> 2.0"
gem "reform-rails" orders_controller.rbclass OrdersController < ApplicationController
    def shipping_address
        @location = Address.new
    end
end shipping_address.html.erb<%= simple_form_for @location,  :html => {class: 'subscribe-from'} ,url: orders_shipping_address_path do |f| %>
  <div class="row">
    <div class="col-md-6">
      <div class="form-group">
        <%= f.input :address_line1, label: "Country", collection: CountryStateSelect.countries_co…
Read more

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

-
If we are getting error after creating database in postgres like this :-psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? Then use following link :- https://stackoverflow.com/questions/42653690/psql-could-not-connect-to-server-no-such-file-or-directory-5432-errorsudo chmod 777 -R /var/run/postgresql/Then restart the postgres:-  sudo service postgresql restart orsudo systemctl start postgresql@9.6-main
Read more

SEARCHING USING AJAX IN RAILS

-
Search any entry from Database using ajaxRoutes
get 'search'

Controller

def search
          @companies = Company.search(params[:search].split("=").last)
          respond_to :js
      end

Model

def self.search(search)
          if search
                Company.where("name LIKE '%#{search}%'")
          else
                Company.all
          end
      end

index.html.erb :-

      <%= text_field_tag :search, "", class: "search_companies" %>

      <tbody class="company_tbody_content">
           <%= render 'index_content' %>
      </tbody>


      <script type="text/javascript">
           $(".search_companies").keyup(function() {
               $.ajax({
                  url: '/super_admin/companies/search',
                  data: {search: $(this).serialize()}
               });
           });
      </script>

search.js.erb

$(".company_tbody_content").html("<…
Read more

UNINITIALIZED CONSTANT PAPERCLIP::STORAGE::S3::AWS

-
Set up Ruby on Rails with Paperclip and S3 using AWS SDK Paperclip requires the following gems added to your Gemfile. If your paperclip version is 5.1.0 then we are using 'aws-sdk' version 2.3.gem 'paperclip'
gem 'aws-sdk', '~> 2.3' or our paperclip version is 4.1.0 then we need to use 'aws-sdk' version < 2  (note: add version less than 2.0 otherwise you will get paperclip error)gem 'paperclip'
gem 'aws-sdk', '< 2.0'

Run bundle install and restart the Rails server after modifying the Gemfile.

WE CAN FOLLOW THE LINK BELOW :-

https://github.com/thoughtbot/paperclip/issues/2388
https://coderwall.com/p/vv1iwg/set-up-ruby-on-rails-with-paperclip-5-and-s3-using-aws-sdk-v2
Read more

UPLOAD ANY MEDIA FILE IN RAILS USING PAPERCLIP

-
Image
Steps to Upload any type of media in ruby on rails by paperclip Upload video in RailsGemfile

gem 'paperclip'
gem 'paperclip-ffmpeg'
gem 'paperclip-av-transcoder' Apply validation in modelhas_attached_file :file, :styles => {:medium => { :geometry => "300x300", :format => 'flv'},:thumb => {:geometry => "100x100#", :format => 'jpg', :time => 15}
    }, :processors => [:ffmpeg]
When you will get some validation errors then we can use this below code :-validates_attachment_content_type :file, content_type: %w(video/mp4 video/3gp video/webm image/jpeg image/jpg image/png) Install ffmpeg on your systemsudo apt-add-repository ppa:jon-severinsson/ffmpeg
sudo apt-get update
sudo apt-get install ffmpeg

When we will get some ppa error then run:-

http://stackoverflow.com/questions/29125229/how-to-reinstall-ffmpeg-clean-on-ubuntu-14-04

Play video in rails using video_tag

video_tag("trailer.ogg", controls: true,…
Read more

Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension.

-
When we are getting problem with mysql like :-Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension.If we want to solve this problem so firstly we need to uninstall the mysql :-
Uninstall mysql :- https://www.linuxhelp.com/how-to-remove-mysql-package-completely-on-ubuntu-16-04/Then we need to install the mysql :-
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04
Then install the mysql gem :-
gem install mysql 
After that run the below command :-
sudo apt-get install libmysqlclient-dev
Read more

HOW TO CALL RAILS API FROM SIMPLE HTML PAGE.

-
Calling the rails API from simple HTML page. Step 1:  Create new form in the HTML page. index.html.erb<form action="javascript:void(0)">
  <input type="text" name="first_name" id="first_name">
  <select name="resident" id="resident">
    <option value="">Select</option>
    <option value="true">true</option>
    <option value="false">false</option>
  </select>
  <textarea type="textarea" name="notes" id="notes"></textarea>
  <input type="file" name="image" id="image">
  <button type="button" name="submit" id="form_submit_api">Send Data</button>
</form>  <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.js" integrity="sha256-DZAnKJ/6XZ9si04Hgrsxu/8s717jcIzLy3oi35EouyE=" crossorigi…
Read more