Skip to content

Instantly share code, notes, and snippets.

@jansenicus

jansenicus/postgresql.sh

Last active August 9, 2018 10:16
Show Gist options
  • Save jansenicus/88bb0fe1266ec9e968b3514f39a3ff35 to your computer and use it in GitHub Desktop.
Save jansenicus/88bb0fe1266ec9e968b3514f39a3ff35 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL 10 installation on linux mint 18.3 based on ubuntu 16.04 along with common troubleshooting
Raw
postgresql.sh
# *POSRTGRESQL INSTALLATION*
sudo apt-get install postgresql-10 postgresql-client-10 postgresql-server-dev-10 postgresql-doc-10 postgresql-contrib
@jansenicus
Copy link
Author

jansenicus commented Jul 19, 2018 •
edited
Loading

Common Misconception of User Name: postgres

  • postgres as a unix username has a password <p455w0rd>;
  • postgres as a postgresql username has a password <pass123>;
  • they have the same user name: postgres ;
  • they can have different passwords;
  • two different environment: operating system and database server.

@jansenicus
Copy link
Author

How to Avoid the Error

Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Clean removal of postgres
$ sudo apt-get remove --purge postgres*

delete all configuration files
$ sudo rm -rf /etc/postgresql/

reinstall postgresql
$sudo apt-get install postgresql-10

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment