cat  /etc/clickhouse-server/config.d/postgresql.xml
<clickhouse>
    <named_collections>
        <mypg>
            <user>pguser</user>
            <password>jw8s0F4</password>
            <host>127.0.0.1</host>
            <port>5432</port>
            <database>test</database>
            <schema>test_schema</schema>
	    <connection_pool_size>8</connection_pool_size>
        </mypg>
    </named_collections>
</clickhouse>


CREATE DATABASE mydatabase ENGINE = PostgreSQL(mypg);


select create_table_query from system.tables where database ='mydatabase';

SELECT create_table_query
FROM system.tables
WHERE database = 'mydatabase'

Query id: bab50629-6e0b-4f58-b89a-34142ef2c098

[clickhouse] 2022.03.15 22:40:58.234005 [ 1716073 ] <Fatal> BaseDaemon: ########################################
[clickhouse] 2022.03.15 22:40:58.234105 [ 1716073 ] <Fatal> BaseDaemon: (version 22.2.3.1, build id: A5B0B4691C628B55) (from thread 1715991) (query_id: bab50629-6e0b-4f58-b89a-34142ef2c098) (query: select create_table_query from system.tables where database ='mydatabase';) Received signal Segmentation fault (11)
[clickhouse] 2022.03.15 22:40:58.234161 [ 1716073 ] <Fatal> BaseDaemon: Address: 0xfffe60050000 Attempted access has violated the permissions assigned to the memory area.
[clickhouse] 2022.03.15 22:40:58.234181 [ 1716073 ] <Fatal> BaseDaemon: Stack trace: 0x10c4e8a8
[clickhouse] 2022.03.15 22:40:58.234226 [ 1716073 ] <Fatal> BaseDaemon: 0. ? @ 0x10c4e8a8 in /usr/bin/clickhouse
[clickhouse] 2022.03.15 22:40:58.330502 [ 1716073 ] <Fatal> BaseDaemon: Calculated checksum of the binary: 538AF8160703B75DF2469049563D9E84. There is no information about the reference checksum.
[clickhouse] 2022.03.15 22:40:58.234005 [ 1716073 ] <Fatal> BaseDaemon: ########################################

clickhouse-client_22.2.3.5_all.deb
clickhouse-common-static_22.2.3.5_arm64.deb
clickhouse-server_22.2.3.5_all.deb