Madan Thapa madan.feedback at gmail.com
Fri Jan 30 04:40:38 PST 2009
>
>
> I have installed postgresql using yum.
>
>
> -bash-3.2# rpm -qa |  grep postgres
> postgresql-libs-8.3.5-1PGDG.rhel5
> postgresql-8.3.5-1PGDG.rhel5
> postgresql-server-8.3.5-1PGDG.rhel5
> compat-postgresql-libs-4-1PGDG.rhel5
>
>
>
> -bash-3.2# ps faux |  egrep 'pgsql|postgres'
> postgres 23733  0.0  0.7  40716  4108 ?        S    Jan29   0:02
> /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
> postgres 23758  0.0  0.1  12040   888 ?        Ss   Jan29   0:00  \_
> postgres: logger process
> postgres 23761  0.0  0.2  40716  1228 ?        Ss   Jan29   0:00  \_
> postgres: writer process
> postgres 23763  0.0  0.1  40716  1028 ?        Ss   Jan29   0:00  \_
> postgres: wal writer process
> postgres 23764  0.0  0.2  40848  1136 ?        Ss   Jan29   0:00  \_
> postgres: autovacuum launcher process
> postgres 23765  0.0  0.1  12036   920 ?        Ss   Jan29   0:00  \_
> postgres: stats collector process
> root     11393  0.0  0.1   2992   704 pts/0    S+   05:44   0:00      \_
> egrep pgsql|postgres
> -bash-3.2#
>
>
>
>
> Now to install slony what would be pg_config path ?
>
> Docs sasy:
> *Normally,* it ought to be sufficient to run configure
> --with-pgconfigdir=3D/some/path/somewhere, where /some/path/somewhere is =
the
> place where the PostgreSQL program *pg_config* is located. From *pg_config
> *, the configure script can determine the various locations where
> PostgreSQL components are found, which indicates where the essential
> components of Slony-I must be installed.
>
>
> -bash-3.2# locate pg_config
> locate: can not open `/var/lib/mlocate/mlocate.db': No such file or
> directory
> -bash-3.2# updatedb
> -bash-3.2# locate pg_config
> -bash-3.2# ls /var/lib/pgsql/data/
> base    pg_clog      pg_ident.conf  pg_multixact  pg_tblspc    PG_VERSION
> postgresql.conf  postmaster.pid
> global  pg_hba.conf  pg_log         pg_subtrans   pg_twophase  pg_xlog
> postmaster.opts
> -bash-3.2#
>
>
>
> -bash-3.2# find / -name pg_config
> -bash-3.2#
> -bash-3.2#
>
>
>
>
>
> Path of some important binaries on my system are
> #################################################
> /usr/bin/psql
> /usr/bin/createdb
> /usr/bin/createlang
> /usr/bin/createuser
> /usr/bin/pg_dump
>
>
>
>
> Please advise.
>
>
> Thanks
>
>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D>

*yum install slony1   did it*


-bash-3.2# yum install slony1
pgdg83                    100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| 1.9 kB    00:00
rpmforge                  100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| 1.1 kB    00:00
base                      100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| 1.1 kB    00:00
updates                   100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D|  951 B    00:00
addons                    100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D|  951 B    00:00
extras                    100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| 1.1 kB    00:00
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package slony1.i386 0:1.2.15-3.rhel5 set to be updated
--> Processing Dependency: perl(DBI) for package: slony1
--> Processing Dependency: perl-DBD-Pg for package: slony1
--> Running transaction check
---> Package perl-DBD-Pg.i386 0:2.11.5-1.el5.rf set to be updated
--> Processing Dependency: perl(version) for package: perl-DBD-Pg
---> Package perl-DBI.i386 0:1.607-1.el5.rf set to be updated
--> Processing Dependency: perl(RPC::PlServer) >=3D 0.2001 for package:
perl-DBI
--> Processing Dependency: perl(RPC::PlClient) >=3D 0.2000 for package:
perl-DBI
--> Running transaction check
---> Package perl-version.i386 0:0.74-1.el5.rf set to be updated
---> Package perl-PlRPC.noarch 0:0.2020-1.el5.rf set to be updated
--> Processing Dependency: perl(Net::Daemon) for package: perl-PlRPC
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC
--> Running transaction check
---> Package perl-Net-Daemon.noarch 0:0.43-1.el5.rf set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
 Package                 Arch       Version          Repository        Size
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
Installing:
 slony1                  i386       1.2.15-3.rhel5   pgdg83            267 k
Installing for dependencies:
 perl-DBD-Pg             i386       2.11.5-1.el5.rf  rpmforge          301 k
 perl-DBI                i386       1.607-1.el5.rf   rpmforge          866 k
 perl-Net-Daemon         noarch     0.43-1.el5.rf    rpmforge           44 k
 perl-PlRPC              noarch     0.2020-1.el5.rf  rpmforge           33 k
 perl-version            i386       0.74-1.el5.rf    rpmforge           76 k

Transaction Summary
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
Install      6 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 1.6 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): slony1-1.2.15-3.rh 100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| 267 kB    00:00
(2/6): perl-PlRPC-0.2020- 100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D|  33 kB    00:00
(3/6): perl-version-0.74- 100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D|  76 kB    00:00
(4/6): perl-Net-Daemon-0. 100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D|  44 kB    00:00
(5/6): perl-DBD-Pg-2.11.5 100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| 301 kB    00:00
(6/6): perl-DBI-1.607-1.e 100% |=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| 866 kB    00:02
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: perl-version                 ######################### [1/6]
  Installing: perl-Net-Daemon              ######################### [2/6]
  Installing: perl-PlRPC                   ######################### [3/6]
  Installing: perl-DBI                     ######################### [4/6]
  Installing: perl-DBD-Pg                  ######################### [5/6]
  Installing: slony1                       ######################### [6/6]

Installed: slony1.i386 0:1.2.15-3.rhel5
Dependency Installed: perl-DBD-Pg.i386 0:2.11.5-1.el5.rf perl-DBI.i386
0:1.607-1.el5.rf perl-Net-Daemon.noarch 0:0.43-1.el5.rf perl-PlRPC.noarch
0:0.2020-1.el5.rf perl-version.i386 0:0.74-1.el5.rf
Complete!



-bash-3.2# slo
slogin                          slonik_drop_set
slonik_subscribe_set
slon                            slonik_drop_table
slonik_uninstall_nodes
slon_kill                       slonik_execute_script
slonik_unsubscribe_set
slon_start                      slonik_failover
slonik_update_nodes
slon_watchdog                   slonik_init_cluster
slony-cluster-analysis-mass.sh
slon_watchdog2                  slonik_merge_sets
slony-cluster-analysis.sh
slonik                          slonik_move_set
slony1_dump.sh
slonik_build_env                slonik_print_preamble
slony1_extract_schema.sh
slonik_create_set               slonik_restart_node
slony_logshipper
slonik_drop_node                slonik_store_node
slony_show_configuration
-bash-3.2# slo
slogin                          slonik_drop_set
slonik_subscribe_set
slon                            slonik_drop_table
slonik_uninstall_nodes
slon_kill                       slonik_execute_script
slonik_unsubscribe_set
slon_start                      slonik_failover
slonik_update_nodes
slon_watchdog                   slonik_init_cluster
slony-cluster-analysis-mass.sh
slon_watchdog2                  slonik_merge_sets
slony-cluster-analysis.sh
slonik                          slonik_move_set
slony1_dump.sh
slonik_build_env                slonik_print_preamble
slony1_extract_schema.sh
slonik_create_set               slonik_restart_node
slony_logshipper
slonik_drop_node                slonik_store_node
slony_show_configuration
-bash-3.2#
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090130/=
745eebf8/attachment-0001.htm


More information about the Slony1-general mailing list