Diff mode was set to SVN, but /root/freebsd-ports/databases/clickhouse is not a svn working copy.
Trying /usr/ports ... found
===> Generating patch
===> Viewing diff with more
diff -ruN /usr/ports/databases/clickhouse/Makefile ./Makefile
--- /usr/ports/databases/clickhouse/Makefile	2017-05-02 09:48:10.000000000 +0300
+++ ./Makefile	2017-05-25 22:44:34.173721000 +0300
@@ -2,11 +2,9 @@
 # $FreeBSD: head/databases/clickhouse/Makefile 439934 2017-05-02 06:48:10Z jbeich $
 
 PORTNAME=	clickhouse
-PORTVERSION=	1.1.54214
+PORTVERSION=	1.1.54236
 DISTVERSIONPREFIX=	v
-#DISTVERSIONSUFFIX=	-stable
-DISTVERSIONSUFFIX=	-testing
-PORTREVISION=	1
+DISTVERSIONSUFFIX=	-stable
 CATEGORIES=	databases
 
 MAINTAINER=	proler@gmail.com
@@ -62,7 +60,8 @@
 .endif
 
 post-patch:
-	@${REINPLACE_CMD} -e 's|/var/lib/clickhouse|/var/db/clickhouse|;s|/var/log/clickhouse-server|/var/log/clickhouse|' ${WRKSRC}/dbms/src/Server/config.xml
+	@${REINPLACE_CMD} -e 's|/var/lib/clickhouse|/var/db/clickhouse|;s|/var/log/clickhouse-server|/var/log/clickhouse|;s|/etc/clickhouse-server|${PREFIX}/etc/clickhouse-server|' ${WRKSRC}/dbms/src/Server/config.xml
+	@${REINPLACE_CMD} -e 's|<listen_host>::1</listen_host>|<\!-- <listen_host>::1</listen_host> -->|;s|<listen_host>127.0.0.1</listen_host>|<\!-- <listen_host>127.0.0.1</listen_host> -->|' ${WRKSRC}/dbms/src/Server/config.xml
 
 post-install:
 	@${RM} ${STAGEDIR}${PREFIX}/bin/clickhouse-compressor
diff -ruN /usr/ports/databases/clickhouse/distinfo ./distinfo
--- /usr/ports/databases/clickhouse/distinfo	2017-04-25 13:47:21.000000000 +0300
+++ ./distinfo	2017-05-25 19:52:44.558521000 +0300
@@ -1,3 +1,3 @@
-TIMESTAMP = 1492025852
-SHA256 (yandex-ClickHouse-v1.1.54214-testing_GH0.tar.gz) = 42d45c4154be269d00fb6cd1533ca798eb85714debd9bbf05ced6c761eb92125
-SIZE (yandex-ClickHouse-v1.1.54214-testing_GH0.tar.gz) = 48685881
+TIMESTAMP = 1495731164
+SHA256 (yandex-ClickHouse-v1.1.54236-stable_GH0.tar.gz) = 0b8d26de7487c7df3e2dae800f8b84068cb076b50af6a7ac53d97a48aab42648
+SIZE (yandex-ClickHouse-v1.1.54236-stable_GH0.tar.gz) = 14217680
diff -ruN /usr/ports/databases/clickhouse/pkg-plist ./pkg-plist
--- /usr/ports/databases/clickhouse/pkg-plist	2017-04-25 13:47:21.000000000 +0300
+++ ./pkg-plist	2017-05-25 20:25:45.942738000 +0300
@@ -3,6 +3,7 @@
 bin/clickhouse-client
 bin/clickhouse-local
 bin/clickhouse-server
+bin/clickhouse-zookeeper-cli
 @dir(clickhouse,,) etc/clickhouse-server
 @dir(clickhouse,,) etc/clickhouse-client
 @sample etc/clickhouse-client/config.xml.sample
====> Cleaning up
===> Done