啟動PostgreSQL時, 無法Binding IP Address

當啟動PostgreSQL時, 發生無法binding to IP Address, 原始錯誤訊息如下::

$> ./postmaster

LOG: could not bind IPv4 socket: Can't assign requested address
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
WARNING: could not create listen socket for "myserver"
FATAL: could not create TCP/IP listen socket

解決方式::
用root的身份登入, 檢查/etc/hosts, 發現myserver's IP是192.168.1.100,
但目前myserver's IP是192.168.1.105, 因該Server是採Dynamic IPAddress,
故IP已變動, 只需將hosts的IP修正即可!!

當啟動PostgreSQL時, 發生IP Address已被使用, 原始錯誤訊息如下::

$> ./postmaster

LOG: could not bind IPv4 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
FATAL: could not create TCP/IP listen socket

解決方式::
一. 以root的身份登入, 執行 lsof -i | grep 5432, 查看是否有其它程式佔用此port,
若有, 請將該程式kill, 或是posgresql以另一個port啟動,

二. 亦或是執行 ps -aux | grep post, 查看是否另有postgres已啟動,
若有, 請將已執行的postgresql kill, 重新啟動postgres