Breaking News: Grepper is joining You.com. Read the official announcement!

postgres error

Xabos answered on December 2, 2022 Popularity 8/10 Helpfulness 2/10

answer postgres error

postgres error

Comment

43.9.1. Reporting Errors and Messages
Use the RAISE statement to report messages and raise errors.

RAISE [ level ] 'format' [, expression [, ... ]] [ USING option = expression [, ... ] ];
RAISE [ level ] condition_name [ USING option = expression [, ... ] ];
RAISE [ level ] SQLSTATE 'sqlstate' [ USING option = expression [, ... ] ];
RAISE [ level ] USING option = expression [, ... ];
RAISE ;

Popularity 8/10 Helpfulness 2/10 Language sql

Source: www.postgresql.org

Tags: sql

Link to this answer
Share Copy Link

Contributed on Dec 02 2022

Xabos

0 Answers Avg Quality 2/10

Closely Related Answers

postgresql error

Comment

error postgres
1.  sudo -u postgres psql # enter sql
2.	SHOW hba_file;
3.	sudo nano /path/to/pg_hba.conf
4.	add password to user:postgres with password:postgres5
5.	change from ...
	# TYPE  DATABASE  USER      ADDRESS   METHOD
	local   all       postgres            peer
6.	to ...
	# TYPE  DATABASE  USER      ADDRESS   METHOD
	local   all       postgres            md5
7.	sudo systemctl restart postgresql
8.	psql -U postgres -h localhost -d postgres
9.	use username:postgres password:postgres to your app

Popularity 6/10 Helpfulness 2/10 Language shell

Source: Grepper

Tags: shell postgresql

Link to this answer
Share Copy Link

Contributed on Aug 13 2023

0 Answers Avg Quality 2/10

postgres error

Contents

More Related Answers

postgres error

Closely Related Answers

postgresql error

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.