Re: speed up a logical replica setup - Mailing list pgsql-hackers

From Shlok Kyal
Subject Re: speed up a logical replica setup
Date
Msg-id CANhcyEWwYktDXG6=U5a9=3Ry_DMSht_UKJ1J8DJAAn5MX3fdUg@mail.gmail.com
Whole thread Raw
In response to Re: speed up a logical replica setup  (Shubham Khanna <khannashubham1197@gmail.com>)
List pgsql-hackers
Hi,
> I applied the v25 patch and did RUN the 'pg_createsubscriber' command.
> I was unable to execute it and experienced the following error:
>
> $ ./pg_createsubscriber -D node2/ -P "host=localhost port=5432
> dbname=postgres"  -d postgres -d db1 -p 9000 -r
> ./pg_createsubscriber: invalid option -- 'p'
> pg_createsubscriber: hint: Try "pg_createsubscriber --help" for more
> information.
>
> Here, the --p is not accepting the desired port number. Thoughts?

I investigated it and found that:

+ while ((c = getopt_long(argc, argv, "d:D:nP:rS:t:v",
+             long_options, &option_index)) != -1)
+ {

Here 'p', 's' and 'U' options are missing so we are getting the error.
Also, I think the 'S' option should be removed from here.

I also see that specifying long options like --subscriber-port,
--subscriber-username, --socket-directory works fine.
Thoughts?

Thanks and regards,
Shlok Kyal



pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: remaining sql/json patches
Next
From: Andy Fan
Date:
Subject: Re: a wrong index choose when statistics is out of date