Home CVS Mailinglists Documentation Download
[Slony1-general] Re: pg_config for slony1 install
marco perugini m.perugini at 4it.it
Sun Feb 1 08:47:08 PST 2009 
hi madan thapa, i had the same problem.. i solved it installing the =

devel rpm also;
so this is my rpm-postgres-list:
# rpm -qa | grep post
postgresql-contrib-8.3.5-1PGDG.rhel5
postgresql-libs-8.3.5-1PGDG.rhel5
postgresql-devel-8.3.5-1PGDG.rhel5
postgresql-server-8.3.5-1PGDG.rhel5
postgresql-8.3.5-1PGDG.rhel5

if you install the devel rpm you'll find pg_config in /usr/bin
# find / -name pg_config
/usr/bin/pg_config

good luck! ;)
marco


Madan Thapa ha scritto:
>
>
>     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#
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>   =



-- =


4it

	=


*4IT **S.r.l.
**Marco Perugini* *| junior-little-newbie-baby-mini-system-administrator** *
---------------------------------------------------------
Via Udine 30-36, 00161 Roma
Phone +39 06 97601680
Mobile +39 339.39.81.246
Fax +39 06 97601683
m.perugini at 4it.it <mailto:m.perugini at 4it.it>
www.4it.it <http://www.4it.it/>

"Il presente messaggio e gli eventuali allegati sono di natura =

confidenziale. Qualora vi fosse pervenuto per errore, vi preghiamo di =

cancellarlo immediatamente dal vostro sistema e di avvisare il mittente. =

Grazie."

"This electronic mail transmission and any accompanying attachments =

contain confidential information. If you have received this =

communication in error, please immediately delete the E-mail and either =

notify the sender. Thank you."


-------------- next part --------------
Skipped content of type multipart/related
More information about the Slony1-general mailing list

Content © 2007 Slony Development Group - Hosting provided by Command Prompt, Inc.