Thursday, January 29, 2015

where is my postgresql database located

i don't know.
# ps aux | grep postgres | grep -- -D

postgres  1058  0.0  0.0  94636  5772 ?        S     2014   8:57 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main 
     \-c config_file=/etc/postgresql/8.4/main/postgresql.conf

# lsof | postgres


postgres  31723   postgres  424u      REG              251,0        8192   16515564 /var/lib/postgresql/8.4/main/base/493462/494067
postgres  31723   postgres  425u      REG              251,0       16384   16515567 /var/lib/postgresql/8.4/main/base/493462/494073
postgres  31723   postgres  438u      REG              251,0       24576   16515903 /var/lib/postgresql/8.4/main/base/493462/494141_fsm
whew.

No comments: