[Postgres-xc-general] FATAL: unrecognized recovery parameter "application_name"

[Theodotos A. <th...@ub...>]

Hi guys,

I am using Koichi's HA guide to setup a two node pgxc cluster:

wiki.postgresql.org/images/4/44/Pgxc_HA_20121024.pdf 
<https://duckduckgo.com/k/?u=https%3A%2F%2Fwiki.postgresql.org%2Fimages%2F4%2F44%2FPgxc_HA_20121024.pdf>

I am in page 48 "configuring coordinator slaves"

I have this config:

$ cat CN2/recovery.conf
standby_mode = on
primary_conninfo = 'host = node01 port = 5432 user = postgres-xc'
application_name = 'cnmaster01'
restore_command = 'cp CN2_ArchLog/%f %p'
archive_cleanup_command = 'pg_archivecleanup CN2_ArchLog %r'

$ cat CN2/postgresql.conf
listen_addresses = '*'
port = 5433
max_connections = 150
shared_buffers = 1024MB
work_mem = 64MB
maintenance_work_mem = 400MB
wal_level = hot_standby
synchronous_commit = on
archive_mode = on
archive_command = 'rsync %p node02:CN2_ArchLog/%f'
max_wal_senders = 5
synchronous_standby_names = 'cnmaster01'
hot_standby = on
cpu_tuple_cost = 0.1
effective_cache_size = 2048MB
logging_collector = on
log_rotation_age = 1d
log_rotation_size = 1GB
log_min_duration_statement = 250ms
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
datestyle = 'iso, mdy'
lc_messages = 'en_US.UTF-8'
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
default_text_search_config = 'pg_catalog.english'
pooler_port = 6668
gtm_host = 'localhost'
gtm_port = 6666
pgxc_node_name = 'cnmaster01'

When I try to start the slave node:

$  pg_ctl start -Z coordinator -D CN2

I get this in the logs:

LOG:  database system was interrupted; last known up at 2013-03-17 
06:29:44 EET
FATAL:  unrecognized recovery parameter "application_name"
LOG:  startup process (PID 6562) exited with exit code 1
LOG:  aborting startup due to startup process failure


Another question:
Why do I have to start the server:
'pg_ctl start -Z coordinator -D coordSlaveDir"

then reconfigure:
"cat >> coordMasterDir/postgresql.conf" <EOF
synchronous_commit = on
synchronous_standby_names = 'coordName'
EOF
"cat >> coordSlaveDir/postgresql.conf" <<EOF
hot_standby = on
port = coordPort
EOF

and then reload?
pg_ctl reload -Z coordinator -D coordMasterDir

Can I just use all the configuration at once and just start the server?

I am using postgres-xc 1.0.2