Re: [GENERAL] Streaming replication stacked.

2016-01-05 Thread Yoji
Hi Michael , 

Thank you for your information!!

I understand.
I'll consider to upgrade to 9.4.5.

I'm grateful for all your support.

Yoji 







--
View this message in context: 
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880550.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Streaming replication stacked.

2016-01-05 Thread Yoji
Hi Andreas and Michael,

Thank you for your information!

Let me know, which should I choose update to 9.4.5 or hot_standby_feedback
off?

Best regards. 


Yoji



--
View this message in context: 
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880487.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Streaming replication stacked.

2016-01-05 Thread Yoji
Hi Michael,

Thank you for replying.

I'm using version of 9.4.3.

And I have seen same behavior on  version of 9.3.4.

Best regards.


Yoji 



--
View this message in context: 
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880329.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Streaming replication stacked.

2016-01-05 Thread Yoji
Hi, Andreas 

Thank you for replying.

You're right, I have only 1 slave.

And I need running transactions on slave.
Once I restarted postgres service on slave and then process began to move.

Best regards.

Yoji



--
View this message in context: 
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880326.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Streaming replication stacked.

2016-01-04 Thread Yoji
Hi Chiru , 

Thank you for your information.

I send wals to standby server using  "wal sender"  processes.

And I had checked logs  but It was nothing.

Best regards.


Yoji




--
View this message in context: 
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880288.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Streaming replication stacked.

2016-01-04 Thread Yoji
Hi, Andreas 

Thank you for reply.

Below is the recovery.conf.

--
standby_mode = on
primary_conninfo = 'host=172.16.xxx.xxx user=xx'
trigger_file = '/tmp/trigger_file0'
------

Best regards.

Yoji



--
View this message in context: 
http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880287.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general