I'm very new to this trigger based slony and I use FC6 rpm 8.14 PG X86_64
and slony 1.16rpm and I still rather confuseed howto get start with it since
no exact way of administration by rpm. I used localhost machine to test
database named node1. home and node2. home_repl ,both of them were in
localhost.
First I started with slon_tools.conf
[EMAIL PROTECTED] ~]# /usr/bin/slony_show_configuration
Slony Configuration
-------------------------------------
Slony-I Cluster: homc_slony
Logs stored under /var/log/slony
Slony Binaries in: /usr/bin/
Node information
--------------------------------
Node: 1 Host: localhost User: postgres Port: 5432 Forwarding?
Parent: 0 Database: home
DSN: host=localhost dbname=home user=postgres port=5432
Node: 2 Host: localhost User: postgres Port: 5432 Forwarding?
Parent: 0 Database: home_rep
DSN: host=localhost dbname=home_rep user=postgres port=5432
[EMAIL PROTECTED] ~]#
And then I looked at bin file in /usr/bin which has many of them.
[EMAIL PROTECTED] ~]# ls /usr/bin/slon*
/usr/bin/slon /usr/bin/slonik_subscribe_set
/usr/bin/slonik /usr/bin/slonik_uninstall_nodes
/usr/bin/slonik_build_env /usr/bin/slonik_unsubscribe_set
/usr/bin/slonik_create_set /usr/bin/slonik_update_nodes
/usr/bin/slonik_drop_node /usr/bin/slon_kill
/usr/bin/slonik_drop_set /usr/bin/slon_start
/usr/bin/slonik_execute_script /usr/bin/slon-tools
/usr/bin/slonik_failover /usr/bin/slon_watchdog
/usr/bin/slonik_init_cluster /usr/bin/slon_watchdog2
/usr/bin/slonik_merge_sets /usr/bin/slony1_dump.sh
/usr/bin/slonik_move_set /usr/bin/slony1_extract_schema.sh
/usr/bin/slonik_restart_node /usr/bin/slony_show_configuration
/usr/bin/slonik_store_node
[EMAIL PROTECTED] ~]#
Which would be the first thing to do and step by step to do it?
Any one could suggest me , it doesn't like online user manual.
Amrit Angsusingh
Thailand
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general