POSTGRES IMPORT AND EXPORT DATABASE

-

Create postgres database using command line:-

createdb -h localhost -p 5432 -U postgres databasename

Import database

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

Or for dump file extension:-

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

or

pg_restore -h localhost -U root -W -F t -d databasename database_dump_file.tar 

or

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

https://stackoverflow.com/questions/2732474/restore-a-postgres-backup-file-using-the-command-line

Export database

pg_dump -U postgres databasename > filename.sql

When we are getting error like

When we get error at the time of import the postgres database :-

: FATAL:  Peer authentication failed for user "postgres"

then:-

The problem is still your pg_hba.conf file (/etc/postgresql/9.1/main/pg_hba.conf). This line:

local   all             postgres                                peer

Should be

local   all             postgres                                md5
After altering this file, don't forget to restart your PostgreSQL server. If you're on Linux, that would be 

sudo service postgresql restart

http://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge

WE CAN REFER:-

 https://www.a2hosting.in/kb/developer-corner/postgresql/import-and-export-a-postgresql-database
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

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

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

CREATE API FOR USER SIGN UP, LOGIN AND CREATE PUBLISHER WITH CURRENT USER

-
Image
User Registration in Devise through API I have recently started developing REST APIs with rails 5. I am trying to do User crude actions through API calls. I have set up a basic devise for users.In my routes I have this: namespace :api do                                                                            
     namespace :v1 do                                                                         
         devise_scope :user do                                                               
            post 'signup' => 'registrations#create'                                   
            post 'signin' => 'sessions#create'                                          
            delete 'signout' => 'sessions#destroy'                                    
         end                                                                                          
         resources :publishers������������������������������������������…
Read more