Error Messages
If failure occurs during database replication, refer to
/var/log/replication.log
and
/opt/server/proteus/log/server.log
for error messages. The
following table displays the database replication task and the log files associated
with the task:
Database replication task | Log files to verify |
---|---|
Configuring database replication |
|
Adding a server to function as a Standby server |
|
Removing one Standby server |
|
Breaking database replication |
|
Resetting database replication |
|
Database replication failover |
|
Rogue files in /data/pgdata
Files that are not owned by PostgresSQL should be removed from the
/data/pgdata
directory. If rogue files exist the following
error messages will appear in
syslog:Mar 16 21:57:11 hostname postgres[16480]: [10] ERROR: could not open file "./z": Permission denied
Mar 16 21:57:11 hostname postgres[16480]: [14] LOG: could not receive data from client: Connection reset by peer
Mar 16 21:57:11 hostname postgres[16480]: [15] LOG: unexpected EOF on standby connection
To find files that are not owned by PostgresSQL, run the following
command:
find /data/pgdata ! -user postgres