I am trying to get postgres working on my droplet.
If I do a port scan for the ip of 5432, it says the port is closed. If I try to access with PGAdminIII, I get an error of ‘server doesn’t listen’
If I do a psql \conninfo I get
You are connected to database “rails” as user “rails” via socket in “/var/run/postgresql” at port “5432”.
I am able to connect with psql and create a test table
rails=> create table test (test varchar (10) ); CREATE TABLE rails=> /dt rails-> \d List of relations Schema | Name | Type | Owner --------+------+-------+------- public | test | table | rails (1 row) rails->
I think the problem could be in my database.yml. Is this the correct code for production?
production: <<: *default database: rails username: rails password: <%= ENV['APP_DATABASE_PASSWORD'] %>
I’d appreciate any help in getting pg working
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.