Last active
August 9, 2018 10:16
-
-
Save jansenicus/88bb0fe1266ec9e968b3514f39a3ff35 to your computer and use it in GitHub Desktop.
PostgreSQL 10 installation on linux mint 18.3 based on ubuntu 16.04 along with common troubleshooting
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# *POSRTGRESQL INSTALLATION* | |
sudo apt-get install postgresql-10 postgresql-client-10 postgresql-server-dev-10 postgresql-doc-10 postgresql-contrib |
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.
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
How to Change Passwordless
psql
into securepsql
Create password for
postgres
Unix user$
sudo passwd postgres
Enter new UNIX password:
<p455w0rd>
Retype new UNIX password:
<p455w0rd>
Switch Unix user to
postgres
$
su - postgres
Enter into psql and create password
$
psql
postgres=#
ALTER USER postgres PASSWORD '<pass123>';
postgres=#
SHOW config_file;
/etc/postgresql/10/main/postgresql.conf
postgres=#
\q
edit configuration file
$
sudo nano /etc/postgresql/10/main/postgresql.conf
add the following line if not exists:
local all postgres md5
delete this line if exists:
local all postgres peer
restart
$
sudo /etc/init.d/postgresql restart
try calling
psql
with-U
flag and postgres username$
psql -U postgres
Password for user postgres:
<pass123>
postgres=#
congratulation! you succeeded