Wed Oct 16 10:38:29 PDT 2019
- Previous message: [Slony1-general] Is it safe to subscribe multiple slaves concurrently?
- Next message: [Slony1-general] Changing node names without adding/removing.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I'm doing another migration , but this time I'm keeping the same host
names, so that I'm not forcing configuration changes in our various
applications.
This means that
nodes 1-4 are currently subscribed and have their hostnames in the config.
We use scripts that call a file to get the host, it's db and password
When I go to add nodes
11-14, I'm using the syntax, where xxx is the IP (not the hostname)
Node, hostname
11, xxx.xxx.xxx.xxx
12, xxx,xxx,xxx,xxx
etc
the sl.path looks like this:
dbname=clsdb host=xxx.xxx.xxx.xxx user=postgres
the sl.node contains
no_id | no_active | no_comment | no_failed
-------+-----------+------------+-----------
11 | t | Node 11 | f
12 | t | Node 12 | f
13 | t | Node 13 | f
Wondering if there is a way to change the sl_path to be the hostname vs the
IP (it will be the same, but does slony care?) Can I just alter the line in
the sl_path and change IP to hostname without everything blowing up (given
that I put the right hostname for that particular IP and of course it's in
DNS)??
Thinking through this more, this actually may not be an issue, as I'm
thinking if I change hosts i'm added and dropping and can add the hostname
at that time, but something is bothering me about leaving it as the IP
(although in reality it's not going to change unless it's dropped). Well
ignore the fact that this may not be warranted and focus on whether I can
make the edits without causing mass hysteria
Thanks
Tory
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20191016/6bb3d2d7/attachment.htm
- Previous message: [Slony1-general] Is it safe to subscribe multiple slaves concurrently?
- Next message: [Slony1-general] Changing node names without adding/removing.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list