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