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

Popular posts from this blog

c# - Better 64-bit byte array hash -

webrtc - Which ICE candidate am I using and why? -

php - Zend Framework / Skeleton-Application / Composer install issue -