How can I change from SQLite database to PostgreSQL database in a working Rails project for localhost?

Question

in database.yml

development:
  adapter: postgresql
  encoding: unicode
  database: demo_test_development
  pool: 5
  username: adarsh
  password: 
  timeout: 5000
  host: localhost
  port: 5432

test:
  adapter: postgresql
  encoding: unicode
  database: demo_test_test
  pool: 5
  username: adarsh
  password: 
  timeout: 5000
  host: localhost
  port: 5432

in gem file

group :development do

    gem 'pg'
    gem 'taps'

end

then I do

1) Bundle install (is working)

2)rake db:setup,db:create,db:migrate(but is not working)

Getting 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 5432? Couldn't create 'demo_test_development' database. Please check your configuration.

Please check if postgres service has started or not and have you installed postgresql in your system???and created a user named adarsh — Sumanth Madishetty
– Sumanth Madishetty, Commented Jan 3, 2019 at 6:34
add a password to your user and place the same in database.yml file — Sumanth Madishetty
– Sumanth Madishetty, Commented Jan 3, 2019 at 8:55
you can use pgadmin that comes with postgres can refer to this question stackoverflow.com/questions/9667264/gui-tool-for-postgresql — Sumanth Madishetty
– Sumanth Madishetty, Commented Jan 3, 2019 at 10:30

Sumanth Madishetty · Accepted Answer · 2019-01-03 12:29:11Z

1

You need to install postgresql package into your system you can refer to this link for instruction regarding installing postgres all you need to do is execute the following commands

sudo apt-get install postgresql postgresql-contrib

this installs postgres into your system

then you need to create a user with the details that you have mentioned in the database.yml file of your rails application

You can use pgadmin for db browser you can refer to this question for other tools

to install pgadmin3 run the following command

 sudo apt-get install pgadmin3

then configure it with the details like host port etc that you are using(refer to database.yml)

edited Jan 3, 2019 at 12:29

answered Jan 3, 2019 at 12:22

Sumanth Madishetty

3,5952 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abdul Baig · Accepted Answer · 2019-01-03 12:28:13Z

0

You are using gem 'pg' in development group in gem file.

group :development do

    gem 'pg'
    gem 'taps'

end

Include it in every environment by moving this line out of development group.

edited Jan 3, 2019 at 12:28

answered Jan 3, 2019 at 11:39

Abdul Baig

3,7413 gold badges23 silver badges48 bronze badges

5 Comments

adarsh Over a year ago

gd i solve that, now i am confusing with seup pgadmin...EX = in sqllite we just do for open database, open database button/my Documents/app name/db/development.sqlite3 like that in pgadmin how can i open database?

Abdul Baig Over a year ago

You need to add New Server under file => Add Server. There will be localhost in the list under the server. There you will find you DB.

adarsh Over a year ago

ya i got it in place of localhost i add host num 127.0.0.1 it work thanks all, for helping me...........

Abdul Baig Over a year ago

Please accept the answer then to help others as well

Jake Over a year ago

@AdarshKL Only accept the answer if it solved your problem, it seemed that Sumanth contributed the most to solve your problem, maybe they will leave an answer based on their comments.

Collectives™ on Stack Overflow

How can I change from SQLite database to PostgreSQL database in a working Rails project for localhost?

2 Answers 2

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related