To install basic tools and nokogiri libraries sudo apt-get install git build-essential patch ruby-dev zlib1g-dev liblzma-dev sudo apt-get install -y libssl-dev libreadline-dev Uglifier required library sudo apt-get install nodejs Postgres required library sudo apt-get install libpq-dev Install and Setup Nginx…
Blog Archives
postgress import db command
Import DB command: psql -U <username> -d <dbname> -1 -f <filename>.sql -h localhost -p 5432 OR pg_restore –verbose –clean –no-acl –no-owner -h localhost -U Export DB command: postgres -d database_name pgfile_name.extension https://devcenter.heroku.com/articles/heroku-postgres-import-export stackoverflow accepted answer
Make work CREATE EXTENSION command.
You have to install contrib package in postgresql to make work CREATE EXTENSION command. sudo apt-get install postgresql-contrib Restart postgresql server: sudo /etc/init.d/postgresql restart Command to check list of postgresql all extensions: ls /usr/share/postgresql/9.1/extension/ Login postgresql command: psql -U username…
Complete Step wise isntallation of PgAdmin, User Creation
1. Follow installtion introductions from the link below: Postgree Installation and Server plus Client Setup 2. Don’t forget to add this in your database.yml host: localhost port: 5432 3. Run this command sudo -u postgres createuser –superuser $your_user_name this will…
Ident authentication failed for user “username” OR createdb: could not connect to database postgres: FATAL: Peer authentication failed for user “user_name”
Error#1 createdb: could not connect to database postgres: FATAL: Peer authentication failed for user “user_name” OR Error#2 Ident authentication failed for user “username” Solution Error Occured to me while runing rake db:create For postgres Database creation. sudo find / -name…
createdb: could not connect to database postgres: FATAL: Peer authentication failed for user “postgres”
FATAL: Peer authentication failed for user “postgres” Solution 1: 1.Add these to your database.yml file development and test environments? host: localhost port: 5432 2. rake db:create 3. rake db:migrate Solution 2: Still getting the issue try Altenative way Error: createdb:…
could not connect to server: Connection refused Is the server running on host “localhost” (127.0.0.1) and accepting TCP/IP connections on port 5434?
Error: could not connect to server: Connection refused Is the server running on host “localhost” (127.0.0.1) and accepting TCP/IP connections on port 5434? Just Change the port number to 5432 in database.yml file Database.yml file: defaults: &defaults adapter: postgres username:…
Postgree installation error solution for rails 3 on ubuntu
1. You just required to run this command in ubuntu terminal sudo apt-get install libpq-dev 2. If you did not installed postgreSQl before then after above command you have to install postgreSQl on Ubuntu follow the following link: https://help.ubuntu.com/community/PostgreSQL 3.…
Learning with Earning 