Home directory Postgresql in Ubuntu 14.04 -
i installed postgresql 9.3 using terminal in ubuntu 14.04 by
sudo apt-get install postgresql postgresql-contrib
my postgresql running, can't find home directory. tutorial says home directory located in /usr/local/pgsql, can't find mine. i've been searching week, , found nothing.
and directory should use if wanna set ld_library_path? appreciated. thank you.
to set ld_library_path
want add path globally, creating *.conf file in /etc/ld.so.conf.d/
(i use oracle client library path example):
$ echo '/usr/lib/oracle/12.1/client64/lib/' | sudo tee /etc/ld.so.conf.d/oracle.conf
then need rebuild library cache , restart postgres:
$ sudo ldconfig $ sudo service postgresql restart
and home in /var/lib/postgresql
. users homes set in /etc/passwd
file:
$ grep postgres /etc/passwd postgres:x:116:125:postgresql administrator,,,:/var/lib/postgresql:/bin/bash
Comments
Post a Comment