Kamis, 01 Oktober 2020

POSTGRESQL-cek lokasi pghba

root@ubuntu:~# su - postgres   
postgres@ubuntu:~$ psql
psql (9.6.19)
Type "help" for help.

postgres=# show hba_file;
              hba_file                
--------------------------------------
/etc/postgresql/9.6/main/pg_hba.conf
(1 row)

postgres=# exit
postgres-# \q
postgres@ubuntu:~$ pwd
/var/lib/postgresql
postgres@ubuntu:~$ exit
logout
root@ubuntu:~# cd /etc/postgresql/9.6/main/
root@ubuntu:/etc/postgresql/9.6/main# ls
conf.d  environment  pg_ctl.conf  pg_hba.conf  pg_ident.conf  postgresql.conf  start.conf
root@ubuntu:/etc/postgresql/9.6/main# vi pg_hba.conf  
root@ubuntu:/etc/postgresql/9.6/main# vi postgresql.conf  
root@ubuntu:/etc/postgresql/9.6/main# service postgresql restart
root@ubuntu:/etc/postgresql/9.6/main#

----------------------------------------------------------------------------------------------- 

Open a command prompt.

> psql -U postgres
=# show hba_file;
=# show config_file

When they change the names of the config settings, or you want to see something else.

=# show all;

Tidak ada komentar:

Posting Komentar