When attempting to create a new database on a PostgreSQL server running walmgr, which is part of SkyTools by Skype Developers, for real time failover I received an error. Initially I was a bit baffled by the error however I remembered after racking my brain for a little bit that you must stop walmgr’s syncdaemon when adding a new database. Below are more details about the error as well as how to stop walmgr’s syncdaemon and then create the new database.
Read the rest of this entry »
Tags:
backup,
createdb,
creation,
database,
error,
failed,
pgsql,
postgres,
PostgreSQL,
psql,
python,
setup,
skype developers,
skytools,
source database,
syncdaemon,
template1,
users,
walmgr
No Comments »
Earlier a client with a fairly complex network setup had a power outage in one of their data centers in Dallas, TX. The power outage caused three servers and a firewall to lose power causing all sorts of other issues on the servers themselves. One of the primary issues was getting the PostgreSQL cluster back in 100% operational.
Read the rest of this entry »
Tags:
log shipping,
pgsql,
PID,
pidfile,
postgres,
PostgreSQL,
power outage,
process ID,
ps -ef,
psql,
rm,
skype,
skytools,
syncdaemon,
wal-master.ini,
walmgr,
walmgr.pid
No Comments »
You might receive the below error in your postgresql.log file after issuing the walmgr.py syncdaemon command as explained below.
Error: CDTFATAL: role “root” does not exist
Command Issued:
walmgr.py conf/wal-master.ini syncdaemon -d
Read the rest of this entry »
Tags:
Linux,
master.ini,
pgsql,
postgres,
PostgreSQL,
postgresql.log,
root,
syncdaemon,
walmgr,
walmgr.pid,
walmgr.py
No Comments »
Entries (RSS)