Search
 
SCRIPT & CODE EXAMPLE
 

TYPESCRIPT

password authentication failed for user postgres

# It's fairly simple to solve:
# follow this step:

# go to etc/postgresql/14/main --(assuming your version is 14)
# open terminal in this folder and type
# if nano not installed install first.. it's so good.

sudo nano pg_hba.conf 

# repalce all method from peer/md5/ to trust like this

local all  all			  		trust
local all  all 			  		trust
host  all  all 	127.0.0.1/32 	trust
host  all  all 	a::1/128 		trust

ctrl + s
ctrl + x

# then run 

sudo service postgresql restart

# then type

sudo -u postgres psql

# after that, type

ALTER USER postgres WITH PASSWORD 'postgres'

# now exit out of it by typing 

q

# now run again

sudo service postgresql restart


# That's all you have to do, congrats, everything will work now.
Comment

PREVIOUS NEXT
Code Example
Typescript :: how to declare a boolean in typescript 
Typescript :: material ui svg icons 
Typescript :: capacitor base64 to file 
Typescript :: typescript check undefined 
Typescript :: typescript valueof interface 
Typescript :: typescript get all enum values 
Typescript :: typescript filter list by property 
Typescript :: see conda enviroments 
Typescript :: add key value pair to all objects in array 
Typescript :: what is children type in react 
Typescript :: output requirements conda 
Typescript :: how to update typescript in global 
Typescript :: angular firestore timestamp date pipe 
Typescript :: html download tag not working angular 
Typescript :: typescript-eslint disable 
Typescript :: mysqli_real_escape_string() expects parameter 1 to be mysqli 
Typescript :: linq check if exists in list 
Typescript :: add digits java 
Typescript :: if shorthand typescript 
Typescript :: verify if room exists in socket.io 
Typescript :: check if schema exists sql server 
Typescript :: Generate module in ionic 4|5|6 
Typescript :: SocketException: An attempt was made to access a socket in a way forbidden by its access permissions. in core 6.0 
Typescript :: basic tsconfig file 
Typescript :: declare object array in typescript 
Typescript :: how to add an element to a Typescript array 
Typescript :: nodemailer typescript 
Typescript :: typescript type or null 
Typescript :: search an array of objects with specific object property value 
Typescript :: check if file exists on s3 python 
ADD CONTENT
Topic
Content
Source link
Name
1+9 =