This site uses cookies. By continuing to browse the site, you agree to our use of cookies. Find out more about cookies.
Skip to main content
Metadecidim's official logo
  • English Triar la llengua Elegir el idioma Choose language
    • Català
    • Castellano
Sign Up Sign In
  • Home
  • Processes
  • Assemblies
  • Initiatives
  • Consultations
  • Conferences
  • Help

Support Forum

#supportforum Any doubts or questions on how to use Decidim? Check them with the Community!

  • The process
  • I have a question
  • Community Tutorials
chevron-left Back to list

Installation process: postgres connection problem

Avatar: Jean-Philippe Prost Jean-Philippe Prost
22/06/2019 19:14  

Hello,

I'm trying to install decidim following the nice step-by-step procedure described at
https://github.com/Platoniq/decidim-install/blob/master/decidim-bionic.md
but I am stuck in the middle :-(

At the point where "Decidim should be able to start working", I have a problem with the following command:
$ bin/rails db:create RAILS_ENV=production

which triggers the following output:
=== beginning output
could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
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 'decidim_prod' database. Please check your configuration.
rails aborted!
PG::ConnectionBad: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
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?
bin/rails:4:in `

'
Tasks: TOP => db:create
(See full trace by running task with --trace)
==== end output

I must say that I have never come across postgres before and I have no knowledge of it.
I have been applying all kinds of suggestions found on postgres forums but nothing seems to work: any suggestions?

I have installed postgreSQL 10.9 on an Ubuntu 18.04 server (installed from scratch).

Thank you for your help.

Cheers,
JP

  • Filter results for category: Decidim Installation Decidim Installation
Endorsements count0
Installation process: postgres connection problem Comments 2

Reference: MDC-PROP-2019-06-14666
Version number 1 (of 1) see other versions
Check fingerprint

Fingerprint

The piece of text below is a shortened, hashed representation of this content. It's useful to ensure the content hasn't been tampered with, as a single modification would result in a totally different value.

Value: 46072e69aa8300596c0c9a1d9f3358ca17a90b537fb60ab443ebfb7afd961ee1

Source: {"body":{"en":"Hello,\r\n\r\nI'm trying to install decidim following the nice step-by-step procedure described at\r\nhttps://github.com/Platoniq/decidim-install/blob/master/decidim-bionic.md\r\nbut I am stuck in the middle :-(\r\n\r\nAt the point where \"Decidim should be able to start working\", I have a problem with the following command:\r\n$ bin/rails db:create RAILS_ENV=production\r\n\r\nwhich triggers the following output:\r\n=== beginning output\r\ncould not connect to server: Connection refused\r\n\tIs the server running on host \"localhost\" (::1) and accepting\r\n\tTCP/IP connections on port 5432?\r\ncould not connect to server: Connection refused\r\n\tIs the server running on host \"localhost\" (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 5432?\r\nCouldn't create 'decidim_prod' database. Please check your configuration.\r\nrails aborted!\r\nPG::ConnectionBad: could not connect to server: Connection refused\r\n\tIs the server running on host \"localhost\" (::1) and accepting\r\n\tTCP/IP connections on port 5432?\r\ncould not connect to server: Connection refused\r\n\tIs the server running on host \"localhost\" (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 5432?\r\nbin/rails:4:in `<main>'\r\nTasks: TOP => db:create\r\n(See full trace by running task with --trace)\r\n==== end output\r\n\r\nI must say that I have never come across postgres before and I have no knowledge of it.\r\nI have been applying all kinds of suggestions found on postgres forums but nothing seems to work: any suggestions?\r\n\r\nI have installed postgreSQL 10.9 on an Ubuntu 18.04 server (installed from scratch).\r\n\r\nThank you for your help.\r\n\r\nCheers,\r\nJP"},"title":{"en":"Installation process: postgres connection problem"}}

This fingerprint is calculated using a SHA256 hashing algorithm. In order to replicate it yourself, you can use an MD5 calculator online and copy-paste the source data.

Share:

link-intact Share link

Share link:

Please paste this code in your page:

<script src="https://meta.decidim.org/processes/supportforum/f/705/proposals/14666/embed.js"></script>
<noscript><iframe src="https://meta.decidim.org/processes/supportforum/f/705/proposals/14666/embed.html" frameborder="0" scrolling="vertical"></iframe></noscript>

Report inappropriate content

Is this content inappropriate?

Reason

Comment details

Order by:
  • Older
    • Best rated
    • Recent
    • Older
    • Most discussed
You are seeing a single comment

View all comments

Avatar: Ivan Vergés Ivan Vergés verified-badge
25/06/2019 11:37
  • Get link Get link

As this seems something particular with the guide, I answered there.
It seems to me though that you still have problems to get up and running postgresql

Loading comments ...

  • Terms and conditions of use
  • About the community
  • Download Open Data files
  • Metadecidim at Twitter Twitter
  • Metadecidim at Instagram Instagram
  • Metadecidim at YouTube YouTube
  • Metadecidim at GitHub GitHub
Creative Commons License Website made with free software.
Decidim Logo

Confirm

OK Cancel

Please sign in

decidim Sign in with Decidim Barcelona
Or

Sign up

Forgot your password?