Première chose

SAS/ = 14 Novembre, 2007 - 12:07

Bonjour,

Quitte à installer Slony, essayez d'installer la version 1.2.12. Elle apporte de très nombreuses améliorations par rapport aux versions 1.1.x qui sont maintenues, mais ne doivent pas être utilisées lors d'installations "fraîches" de Slony.

Librement,
Stéphane Schildknecht
dalibo
PostgreSQLFr

j'ai toujours le meme probleme !

lola/ = 15 Novembre, 2007 - 11:27

bonjour,
merci d'avoir répondu assez tôt, mais je pense que c'est pas un probleme de version !

pg02:/home/projet_postgres/slony1-1.2.12# make
make[1]: entrant dans le répertoire « /home/projet_postgres/slony1-1.2.12/src »
make[2]: entrant dans le répertoire « /home/projet_postgres/slony1-1.2.12/src/xxid »
gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I../.. -I/usr/local/postgresql8.2.5/bis/include -I/usr/local/postgresql8.2.5/bis/include/server -c -o xxid.o xxid.c
xxid.c:27:25: error: operator '>' has no left operand
xxid.c: In function '_Slony_I_xxid_snapshot_in':
xxid.c:327: warning: implicit declaration of function 'SET_VARSIZE'
make[2]: *** [xxid.o] Erreur 1
make[2]: quittant le répertoire « /home/projet_postgres/slony1-1.2.12/src/xxid »
make[1]: *** [all] Erreur 2
make[1]: quittant le répertoire « /home/projet_postgres/slony1-1.2.12/src »
make: *** [all] Erreur 2
pg02:/home/projet_postgres/slony1-1.2.12#

merci pour votre aide

bis?

Jean-Paul Argudo/ = 15 Novembre, 2007 - 11:58

bonjour,

Dans votre chaîne de compilation, quelque chose m'interpelle: la présence du sous-répertoire "bis" sous /usr/local/postgresql8.2.5/...

De quoi s'agit-il? Pouvez-vous nous en dire plus sur le sujet? Il ne faudrait pas que ce soit un /include/ d'une autre version de PostgreSQL, par exemple...

En tout cas je trouve cela très curieux.

--
Jean-Paul ARGUDO
http://dalibo.com | http://dalibo.org

probleme de xxid.c !

lola/ = 15 Novembre, 2007 - 11:58

c'est un probleme de ce fichier C, j'ai regardé, mais je n'ai reussi à localiser le probleme !

/slony1-1.2.12/src/xxid/xxid.c

la présence du sous-répertoire "bis"

lola/ = 15 Novembre, 2007 - 12:04

Bonjour et merci d'avoir repondu à ma question,
ca n'a rien d'anormal , juste un repertoire que créer pour installer une deuxieme version, ..../postgresql8.2.5/ j'ai mes bin include,lib ...
et dans ......../postgresql8.2.5/bis/ j'ai mes bin, include,lib .... et je suis en trains d'installer slony1 sur le cluster ..../bis et lui donnant les options suivantes:

./configure --with-pgconfigdir=/usr/local/postgresql8.2.5/bis/bin --with-pgbindir=/usr/local/postgresql8.2.5/bis/bin --with-pgincludedir=/usr/local/postgresql8.2.5/bis/include --with-pgincludeserverdir=/usr/local/postgresql8.2.5/bis/include/server --with-pglibdir=/usr/local/postgresql8.2.5/bis/lib --with-pgpkglibdir=/usr/local/postgresql8.2.5/bis/lib --with-pgsharedir=/usr/local/postgresql8.2.5/bis/share --with-perltools --with-docs
--with-datadir=/usr/local/postgresql8.2.5/bis/data

merci d'avance

./configure ?

SAS/ = 16 Novembre, 2007 - 14:06

N'y a-t-il vraiment aucune erreur dans le résultat de la commande ./configure ?

Je viens de tenter la compilation de slony-1.2.12 sans paramètre pour le ./configure, c'est passé.

Je pense qu'il manque des fichiers d'inclusion.

Librement,
Stéphane Schildknecht
dalibo
PostgreSQLFr

pas d'erreur !

lola/ = 16 Novembre, 2007 - 16:55

aucune erreur, il a bine crée ce qu'il faut, mais impossible de faire make !

resulta ./configure

lola/ = 21 Novembre, 2007 - 11:49

pg02:/home/projet_postgres/slony1-1.2.12# ./configure --with-pgconfigdir=/usr/local/postgresql8.2.5/bis/bin --with-pgbindir=/usr/local/postgresql8.2.5/bis/bin --with-pgincludedir=/usr/local/postgresql8.2.5/bis/include --with-pgincludeserverdir=/usr/local/postgresql8.2.5/bis/include/server --with-pglibdir=/usr/local/postgresql8.2.5/bis/lib --with-pgpkglibdir=/usr/local/postgresql8.2.5/bis/lib --with-pgsharedir=/usr/local/postgresql8.2.5/bis/share --with-perltools --with-docs
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking which template to use... linux
configure: using CFLAGS=
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for perl... /usr/bin/perl
checking for tar... /bin/tar
checking for flex... no
checking for ,... no
checking for lex... no
checking for bison... no
checking for ,... no
checking for yacc... no
checking for sed... sed
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking for cc_r... gcc
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking stddef.h usability... yes
checking stddef.h presence... yes
checking for stddef.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking for inttypes.h... (cached) yes
checking for gettimeofday... yes
checking for dup2... yes
checking for alarm... yes
checking for memset... yes
checking for select... yes
checking for strdup... yes
checking for strerror... yes
checking for strtol... yes
checking for strtoul... yes
checking for int32_t... yes
checking for uint32_t... yes
checking for u_int32_t... yes
checking for int64_t... yes
checking for uint64_t... yes
checking for u_int64_t... yes
checking for ssize_t... yes
checking for POSIX signal interface... yes
checking if you have requested slony1-engine building... yes
overriding pgbindir with /usr/local/postgresql8.2.5/bis/bin
overriding pglibdir with /usr/local/postgresql8.2.5/bis/lib
overriding pgincludedir with /usr/local/postgresql8.2.5/bis/include
overriding pgpkglibdir with /usr/local/postgresql8.2.5/bis/lib
overriding pgincludeserverdir with /usr/local/postgresql8.2.5/bis/include/server
overriding pgsharedir with /usr/local/postgresql8.2.5/bis/share
checking for pg_config... /usr/local/postgresql8.2.5/bis/bin/pg_config
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
pg_config: could not find own executable
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
pg_config: could not find own executable
checking for correct version of PostgreSQL... checking for PQunescapeBytea in -lpq... yes
checking libpq-fe.h usability... yes
checking libpq-fe.h presence... yes
checking for libpq-fe.h... yes
checking postgres.h usability... yes
checking postgres.h presence... yes
checking for postgres.h... yes
checking for utils/typcache.h... yes
checking for plpgsql.so... skipped due to override
checking for postgresql.conf.sample... skipped due to override
checking for PQputCopyData in -lpq... yes
checking for PQsetNoticeReceiver in -lpq... yes
checking for PQfreemem in -lpq... yes
checking for typenameTypeId... yes, and it takes 2 arguments
checking for standard_conforming_strings... yes
checking whether GetTopTransactionId is declared... yes
checking for DBI::Pg... checking if you have requested documentation building... yes
checking for groff... groff
checking for ps2pdf... no
checking for eps2pdf... no
checking for djpeg... no
checking for pnmtops... no
checking for convert... no
checking for postgresql_autodoc... no
checking for pgautodoc... no
checking for onsgmls... no
checking for nsgmls... no
checking for sgmlspl... no
checking for docbook2man-spec.pl... not found, skipping manpages.
Please use --with-d2mdir to specify the path to docbook2man-spec.pl
checking for openjade... no
checking for jade... no
checking for DocBook V4.2... no
checking for DocBook stylesheets... no
checking for collateindex.pl... no
configure: creating ./config.status
config.status: creating Makefile.global
config.status: WARNING: Makefile.global.in seems to ignore the --datarootdir setting
config.status: creating GNUmakefile
config.status: creating postgresql-slony1.spec
config.status: creating Makefile.port
config.status: creating config.h
config.status: config.h is unchanged

Que d'erreurs !!!

SAS/ = 21 Novembre, 2007 - 12:34

Bonjour,

Il semblerait au contraire que le configure vous raporte de nombreuses erreurs :

checking for flex... no
checking for ,... no
checking for lex... no
checking for bison... no
checking for ,... no
checking for yacc... no

Vous devriez installer lex/flex/bison/yacc.

Ensuite, et c'est probablement pour cela que la compilatioin ne passe pas, le binaire pg_config ne semble pas reconnu :

checking for pg_config... /usr/local/postgresql8.2.5/bis/bin/pg_config
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
pg_config: could not find own executable
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
pg_config: could not find own executable

Vous devriez vérifier votre installation de PostgreSQL.

Librement,
Stéphane Schildknecht
dalibo
PostgreSQLFr

installation de flex

lola/ = 21 Novembre, 2007 - 14:30

bonjour,
j'ai installé flex, et tout s'est passé sauf, invalid binary ...pg_config !!!!!!

rien d'anormal au niveau de la base, il marche bien, mais je ne peux pas aller plus loins !!

voici le resultat de ma configue:

pg02:/home/projet_postgres/slony1-1.2.12# ./configure --with-pgconfigdir=/usr/local/postgresql8.2.5/bis/bin/ --with-pgbindir=/usr/local/postgresql8.2.5/bin --with-pgincludedir=/usr/local/postgresql8.2.5/include --with-pgincludeserverdir=/usr/local/postgresql8.2.5/include/server --with-pglibdir=/usr/local/postgresql8.2.5/lib --with-pgpkglibdir=/usr/local/postgresql8.2.5/lib --with-pgsharedir=/usr/local/postgresql8.2.5/share --with-perltools
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking which template to use... linux
configure: using CFLAGS=
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for perl... /usr/bin/perl
checking for tar... /bin/tar
checking for flex... flex
checking for bison... bison -y
checking for sed... sed
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking for cc_r... gcc
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking stddef.h usability... yes
checking stddef.h presence... yes
checking for stddef.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking for inttypes.h... (cached) yes
checking for gettimeofday... yes
checking for dup2... yes
checking for alarm... yes
checking for memset... yes
checking for select... yes
checking for strdup... yes
checking for strerror... yes
checking for strtol... yes
checking for strtoul... yes
checking for int32_t... yes
checking for uint32_t... yes
checking for u_int32_t... yes
checking for int64_t... yes
checking for uint64_t... yes
checking for u_int64_t... yes
checking for ssize_t... yes
checking for POSIX signal interface... yes
checking if you have requested slony1-engine building... yes
overriding pgbindir with /usr/local/postgresql8.2.5/bin
overriding pglibdir with /usr/local/postgresql8.2.5/lib
overriding pgincludedir with /usr/local/postgresql8.2.5/include
overriding pgpkglibdir with /usr/local/postgresql8.2.5/lib
overriding pgincludeserverdir with /usr/local/postgresql8.2.5/include/server
overriding pgsharedir with /usr/local/postgresql8.2.5/share
checking for pg_config... /usr/local/postgresql8.2.5/bis/bin//pg_config
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
pg_config: could not find own executable
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
pg_config: could not find own executable
checking for correct version of PostgreSQL... checking for PQunescapeBytea in -lpq... yes
checking libpq-fe.h usability... yes
checking libpq-fe.h presence... yes
checking for libpq-fe.h... yes
checking postgres.h usability... yes
checking postgres.h presence... yes
checking for postgres.h... yes
checking for utils/typcache.h... yes
checking for plpgsql.so... skipped due to override
checking for postgresql.conf.sample... skipped due to override
checking for PQputCopyData in -lpq... yes
checking for PQsetNoticeReceiver in -lpq... yes
checking for PQfreemem in -lpq... yes
checking for typenameTypeId... yes, and it takes 2 arguments
checking for standard_conforming_strings... yes
checking whether GetTopTransactionId is declared... yes
checking for DBI::Pg... checking if you have requested documentation building... no
configure: creating ./config.status
config.status: creating Makefile.global
config.status: WARNING: Makefile.global.in seems to ignore the --datarootdir setting
config.status: creating GNUmakefile
config.status: creating postgresql-slony1.spec
config.status: creating Makefile.port
config.status: creating config.h
config.status: config.h is unchanged

est qu'il faut aussi installer ces trucs ?? ou c'est pas necessaire ?

checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no

merci d'avance

problème de pg_config !

lola/ = 21 Novembre, 2007 - 14:43

bonjour,
je pense que ca vient de l'utilitaire pg_config:
la commande : ./pg_config --version, donne la meme erreure !!!

pg02:/usr/local/postgresql8.2.5/bis/bin# ./pg_config --version

invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
invalid binary "/usr/local/postgresql8.2.5/bis/bin/pg_config"
pg_config: could not find own executable

qu'est ce que ca peut etre ?
merci

merci j'ai trouvé la solution

lola/ = 21 Novembre, 2007 - 14:58

bonjour,
merci à tous ceux qui m'ont aidé, j'ai reussi à installé slony,
en fait l'utilitaire pg_config n'est bien installé, il falait aller dans
les sources et faire make et make install pour que ca marche bien.

merci encore pour vos remarques

Avec plaisir

SAS/ = 22 Novembre, 2007 - 10:49

Bon courage pour la suite.

Librement,
Stéphane Schildknecht
dalibo
PostgreSQLFr