pgSql Data Directory 옮기기

1. Pgsql Data Directory Check 
psql -U myDbUserName -d myDatabase -W
myDbUserName# show data_directory; 

=============================

 data_directory 
----------------
 /var/lib/pgsql/data

 

1. Data Directory Copy
cp -rfvp /var/lib/pgsql/data /data/pgData (target Directory)

2. /etc/init.d/postgresql Edit 
PGDATA=/var/lib/pgsql/data => PGDATA=/data/pgData

3. /data/data/postmaster.opts Edit
/usr/bin/postgres "-p" "5432" "-D" "/var/lib/pgsql/data" => /usr/bin/postgres "-p" "5432" "-D" "/data/data"

4. pgsql restart
/etc/init.d/postgresql restart

5. Pgsql Data Directory ReCheck
psql -U myDbUserName -d myDatabase -W
myDbUserName# show data_directory; 

=============================

 data_directory  
---------------- 
 /data/pgData 

 

Success !!!! 짝짝짝~~~