What Postgres packages are really needed?

0
votes

I have new Vultr Ubuntu 18.04 server on which I plan to install a Rails 5.2 app on Postgres and RVM.

Which Postgres packages are needed for a Rails app? I will use PG Admin to view the database as well.

  • This tutorial says to install postgresql-common + postgresql-9.5 + libpq-dev
  • This one says postgresql + postgresql-contrib + libpq-dev
  • This one says postgresql + postgresql-contrib

Which is the right one? Isn't postgresql-10 better than postgresql-9.5?

1
postgresql

1 Answers

0
votes

you only need postgresql-common and postgresql on the server.

posstgresql-dev is needed if you are compiling clients

pg_admin is usually installed on your desktop, no the server.

version 10 is newer and considered stable by the developers, I'd pick it over 9.x