From: | "Gregorio, Albert" <AGregorio(at)VoltDelta(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com> |
Subject: | Please Post |
Date: | 2012-07-11 15:13:25 |
Message-ID: | 93C2917C1E56FC43AB5BF8158345DB895FDEAE@ca100ex4.west.vis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am working with PostgreSQL 9.1.3 - I setup a master and standby -
Initiated replication and verified that it was occurring - Failed over
from master to standby and verified that the database could be updated
on the new master - I then configured the former standby as a master,
the former master as a standby and used the following command from the
new master to transfer data to the new standby:
rsync -av --exclude postgresql.conf --exclude pg_xlog
/var/lib/pgsql/9.1/data/* 192.7.143.213:/var/lib/pgsql/9.1/data (with
all previous data being removed by rm -rf *)
I then started the new standby first and after a short wait the new
master - The standby starts and initially has connect errors but after
the master is started the standby appears to start streaming replication
and then errors with a timeline error - On the new master all looks good
and the database can be accessed via psql.
Here is the content of my recovery.conf file:
standby_mode=on
primary_conninfo='host=192.7.143.111 port=5432 user=ruser
password=ruserpass'
trigger_file='/var/lib/pgsql/9.1/data/failover'
recovery_target_timeline = 'latest' (same effect when this line is
removed)
Before New Master Starts:
2012-07-11 10:43:04.476 EDT---10876-LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2012-07-11 10:43:09.476 EDT---10877-FATAL: XX000: could not connect to
the primary server: could not connect to server: Connection refused
Is the server running on host "192.7.143.111" and
accepting
TCP/IP connections on port 5432?
2012-07-11 10:43:09.476 EDT---10877-LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2012-07-11 10:43:14.476 EDT---10878-FATAL: XX000: could not connect to
the primary server: could not connect to server: Connection refused
Is the server running on host "192.7.143.111" and
accepting
TCP/IP connections on port 5432?
After new Master Starts:
2012-07-11 10:43:14.476 EDT---10878-LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2012-07-11 10:43:19.479 EDT---10879-LOG: 00000: streaming replication
successfully connected to primary
2012-07-11 10:43:19.479 EDT---10879-LOCATION: libpqrcv_connect,
libpqwalreceiver.c:171
2012-07-11 10:43:20.749 EDT---10738-LOG: 00000: unexpected timeline ID
1 in log file 0, segment 2, offset 0
2012-07-11 10:43:20.749 EDT---10738-LOCATION: ValidXLOGHeader,
xlog.c:4123
2012-07-11 10:43:20.749 EDT---10879-FATAL: 57P01: terminating
walreceiver process due to administrator command
2012-07-11 10:43:20.749 EDT---10879-LOCATION: ProcessWalRcvInterrupts,
walreceiver.c:150
2012-07-11 10:43:20.849 EDT---10738-LOG: 00000: unexpected timeline ID
1 in log file 0, segment 2, offset 0
2012-07-11 10:43:20.849 EDT---10738-LOCATION: ValidXLOGHeader,
xlog.c:4123
2012-07-11 10:43:24.849 EDT---10738-LOG: 00000: unexpected timeline ID
1 in log file 0, segment 2, offset 0
2012-07-11 10:43:24.849 EDT---10738-LOCATION: ValidXLOGHeader,
xlog.c:4123
2012-07-11 10:43:29.849 EDT---10738-LOG: 00000: unexpected timeline ID
1 in log file 0, segment 2, offset 0
2012-07-11 10:43:29.849 EDT---10738-LOCATION: ValidXLOGHeader,
xlog.c:4123
2012-07-11 10:43:34.850 EDT---10738-LOG: 00000: unexpected timeline ID
1 in log file 0, segment 2, offset 0
2012-07-11 10:43:34.851 EDT---10738-LOCATION: ValidXLOGHeader,
xlog.c:4123
2012-07-11 10:43:38.415 EDT---10731-LOG: 00000: received fast shutdown
request
2012-07-11 10:43:38.415 EDT---10731-LOCATION: pmdie, postmaster.c:2251
2012-07-11 10:43:38.415 EDT---10738-LOG: 00000: unexpected timeline ID
1 in log file 0, segment 2, offset 0
2012-07-11 10:43:38.415 EDT---10738-LOCATION: ValidXLOGHeader,
xlog.c:4123
2012-07-11 10:43:38.416 EDT---10731-LOG: 00000: startup process (PID
10738) exited with exit code 1
2012-07-11 10:43:38.416 EDT---10731-LOCATION: LogChildExit,
postmaster.c:2867
2012-07-11 10:43:38.416 EDT---10731-LOG: 00000: aborting startup due to
startup process failure
2012-07-11 10:43:38.416 EDT---10731-LOCATION: reaper, postmaster.c:2377
Al Gregorio
Volt Delta
585-899-8812
"When you're moving in the positive, your destination is the brightest
star."
Stevie Wonder
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremaine Johnson | 2012-07-11 15:17:10 | Fulltext Search Function |
Previous Message | KOTa | 2012-07-11 14:47:29 | installation problem with postgres password |