If i grep for errors i get some invalid page header in block 56072 of relation base/16385/77373 errors.
But not sure what else to look for ?
On 2 July 2015 at 10:41, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 07/01/2015 05:20 PM, Andy Erskine wrote:
I initially populated the directory using basebackup and pulled the data
directory across from the master.
So what does the standby log show?
On 2 July 2015 at 10:13, Adrian Klaver <adrian.klaver@xxxxxxxxxxxadrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx><mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
On 07/01/2015 05:04 PM, Andy Erskine wrote:
the cmd you listed did work it didn't like the -d option
however on the master :
data]$ du -h
7.9M ./pg_clog
168K ./pg_subtrans
232K ./pg_multixact/members
120K ./pg_multixact/offsets
356K ./pg_multixact
12K ./pg_notify
1.9G ./pg_log
127G ./base/16385
6.3M ./base/12865
4.0K ./base/pgsql_tmp
6.3M ./base/1
6.4M ./base/12870
127G ./base
764K ./pg_stat_tmp
4.0K ./pg_tblspc
364K ./pg_xlog/archive_status
8.1G ./pg_xlog
2.2M ./global
4.0K ./pg_serial
4.0K ./pg_snapshots
4.0K ./pg_twophase
137G .
And the secondary :
data]$ du -h
6.4M ./base/12870
4.0K ./base/pgsql_tmp
6.3M ./base/1
141G ./base/16385
6.3M ./base/12865
141G ./base
12K ./pg_multixact/offsets
232K ./pg_multixact/members
248K ./pg_multixact
348K ./pg_xlog/archive_status
79G ./pg_xlog
2.1M ./global
4.0K ./pg_serial
4.0K ./pg_snapshots
4.0K ./pg_twophase
12K ./pg_notify
7.8M ./pg_clog
288K ./pg_stat_tmp
4.0K ./pg_tblspc
68K ./pg_subtrans
53M ./pg_log
220G .
So we have 80GB in the pg_xlog on the secondary ?
Does the log for the secondary show anything unusual?
Also how did you set up the secondary?
In other words how did you populate the $DATA directory?
pg_xlog]$ du -h
364K ./archive_status
8.1G .
pg_xlog]$ du -h
348K ./archive_status
79G .
--
*Andy Erskine*
--
Adrian Klaver
--
*Andy Erskine*
**
*JDS Australia**
**P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578
*E:*_andy.erskine@xxxxxxxxxx <mailto:andy.erskine@xxxxxxxxxx>_
*W*: www.jds.net.au <http://www.jds.net.au/>
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
JDS Signature v1
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
Andy Erskine
JDS Australia
P 1300 780 432 | M 0431919301 | F 03 90124578
E: andy.erskine@jds.net.au
W: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
