Novato con PostgreSQL

From: "Reynier Perez Mira" <rperezm(at)uci(dot)cu>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Novato con PostgreSQL
Date: 2008-01-22 15:32:26
Message-ID: EC5E9DCE5D152B468D2854F9B132D4DD010C5EA4@ucixw2.uci.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda


Compiling dvd.c
Compiling fd_cmds.c
Compiling job.c
Compiling label.c
Compiling lock.c
Compiling mac.c
Compiling match_bsr.c
Compiling mount.c
Compiling parse_bsr.c
Compiling pythonsd.c
Compiling read.c
Compiling read_record.c
Compiling record.c
Compiling reserve.c
Compiling scan.c
Compiling spool.c
Compiling status.c
Compiling stored_conf.c
Compiling wait.c
Linking bacula-sd ...
/usr/bin/g++ -O -L../lib -o bacula-sd stored.o ansi_label.o autochanger.o acquire.o append.o askdir.o authenticate.o block.o butil.o dev.o device.o dircmd.o dvd.o ebcdic.o fd_cmds.o job.o label.o lock.o mac.o match_bsr.o mount.o parse_bsr.o pythonsd.o read.o read_record.o record.o reserve.o scan.o spool.o status.o stored_conf.o wait.o -lz \
-lbac -lm -lpthread -ldl \
-lssl -lcrypto
Compiling bls.c
Compiling ../findlib/libfind.a
Compiling bextract.c
Compiling ../findlib/libfind.a
Compiling bscan.c
/usr/bin/g++ -O -L../lib -L../cats -L../findlib -o bscan bscan.o block.o device.o dev.o label.o ansi_label.o dvd.o ebcdic.o lock.o autochanger.o acquire.o mount.o record.o match_bsr.o parse_bsr.o butil.o read_record.o scan.o reserve.o stored_conf.o spool.o wait.o \
-lsql -L/usr/lib -lpq -lcrypt -lz -lfind -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling btape.c
/usr/bin/g++ -O -L../lib -L../cats -o btape btape.o block.o butil.o dev.o device.o label.o lock.o ansi_label.o dvd.o ebcdic.o autochanger.o acquire.o mount.o record.o read_record.o reserve.o stored_conf.o match_bsr.o parse_bsr.o scan.o spool.o wait.o \
-lsql -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling bcopy.c
/usr/bin/g++ -O -L../lib -L../findlib -o bcopy bcopy.o block.o device.o dev.o label.o ansi_label.o dvd.o ebcdic.o lock.o autochanger.o acquire.o mount.o record.o match_bsr.o parse_bsr.o butil.o read_record.o reserve.o scan.o stored_conf.o spool.o wait.o \
-L/usr/lib -lpq -lcrypt -lz -lfind -lbac -lm -lpthread -ldl -lssl -lcrypto
===== Make of stored is good ====

make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/stored'
==>Entering directory /data/Bacula/bacula-2.2.7/src/tools
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/tools'
Compiling bsmtp.c
/usr/bin/g++ -O -L../lib -o bsmtp bsmtp.o -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling dbcheck.c
/usr/bin/g++ -O -L../lib -L../cats -o dbcheck dbcheck.o ../dird/dird_conf.o ../dird/run_conf.o ../dird/inc_conf.o -lsql -lbac -lm -L/usr/lib -lpq -lcrypt -lpthread -ldl -lssl -lcrypto
Compiling drivetype.c
/usr/bin/g++ -O -L../lib -L../findlib -o drivetype drivetype.o -lfind -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling fstype.c
/usr/bin/g++ -O -L../lib -L../findlib -o fstype fstype.o -lfind -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling testfind.c
/usr/bin/g++ -g -O -L. -L../lib -L../findlib -o testfind testfind.o ../dird/dird_conf.o ../dird/inc_conf.o ../dird/run_conf.o \
-lfind -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling testls.c
/usr/bin/g++ -g -O -L. -L../lib -L../findlib -o testls testls.o \
-lfind -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling bregex.c
/usr/bin/g++ -g -O -L. -L../lib -o bregex bregex.o \
-lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling bwild.c
/usr/bin/g++ -g -O -L. -L../lib -o bwild bwild.o \
-lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling bbatch.c
/usr/bin/g++ -g -O -L../cats -L. -L../lib -o bbatch bbatch.o \
-lsql -lbac -lm -L/usr/lib -lpq -lcrypt -lpthread -ldl -lssl -lcrypto
Compiling bregtest.c
/usr/bin/g++ -O -L../lib -o bregtest bregtest.o -lbac -lm -lpthread -ldl -lssl -lcrypto
Compiling grow.c
/usr/bin/g++ -O -L../lib -o grow grow.o -lbac -lm -lpthread -ldl -lssl -lcrypto
==== Make of tools is good ====

make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/tools'
==>Entering directory /data/Bacula/bacula-2.2.7/manpages
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/manpages'
make[1]: No se hace nada para `all'.
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/manpages'
root(at)gsdserver:/data/Bacula/bacula-2.2.7# make install
./autoconf/mkinstalldirs /sbin
./autoconf/mkinstalldirs /etc/bacula
./autoconf/mkinstalldirs /etc/bacula
if test ! -d /var/bacula/working ; then \
./autoconf/mkinstalldirs /var/bacula/working; \
chmod 770 /var/bacula/working; \
fi
if test "x" != "x" ; then \
chown /var/bacula/working; \
fi
if test "x" != "x" ; then \
chgrp /var/bacula/working; \
fi
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src'
make[1]: No se hace nada para `install'.
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/scripts'
../autoconf/mkinstalldirs /etc/bacula
../autoconf/mkinstalldirs /sbin
../autoconf/mkinstalldirs /etc/bacula
../autoconf/mkinstalldirs /usr/share/man
/usr/bin/install -c -m 0754 startmysql /etc/bacula/startmysql
/usr/bin/install -c -m 0754 stopmysql /etc/bacula/stopmysql
/usr/bin/install -c -m 0754 bconsole /etc/bacula/bconsole
/usr/bin/install -c -m 0754 gconsole /etc/bacula/gconsole
/usr/bin/install -c -m 0754 bacula /etc/bacula/bacula
/usr/bin/install -c -m 0754 bacula-ctl-dir /etc/bacula/bacula-ctl-dir
/usr/bin/install -c -m 0754 bacula-ctl-fd /etc/bacula/bacula-ctl-fd
/usr/bin/install -c -m 0754 bacula-ctl-sd /etc/bacula/bacula-ctl-sd
/usr/bin/install -c -m 0754 mtx-changer /etc/bacula/mtx-changer
/usr/bin/install -c -m 0754 disk-changer /etc/bacula/disk-changer
/usr/bin/install -c -m 0754 dvd-handler /etc/bacula/dvd-handler
/usr/bin/install -c -m 644 btraceback.gdb /etc/bacula/btraceback.gdb
/usr/bin/install -c -m 644 btraceback.dbx /etc/bacula/btraceback.dbx
chmod 0644 /etc/bacula/btraceback.gdb \
/etc/bacula/btraceback.dbx
/usr/bin/install -c -m 0754 btraceback /sbin/btraceback
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/scripts'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/lib'
make[1]: No se hace nada para `install'.
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/lib'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/findlib'
make[1]: No se hace nada para `install'.
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/findlib'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/filed'
==== Make of filed is good ====

/usr/bin/install -c -m 0754 bacula-fd /sbin/bacula-fd
/usr/bin/install -c -m 640 bacula-fd.conf /etc/bacula/bacula-fd.conf
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/filed'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/console'
==== Make of console is good ====

/usr/bin/install -c -m 0754 bconsole /sbin/bconsole
/usr/bin/install -c -m 640 bconsole.conf /etc/bacula/bconsole.conf
if test -f static-bconsole; then \
/usr/bin/install -c -m 0754 static-bconsole /sbin/static-bconsole; \
fi
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/console'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/cats'
/usr/bin/install -c -m 0754 create_postgresql_database /etc/bacula/create_postgresql_database
/usr/bin/install -c -m 0754 update_postgresql_tables /etc/bacula/update_postgresql_tables
/usr/bin/install -c -m 0754 make_postgresql_tables /etc/bacula/make_postgresql_tables
/usr/bin/install -c -m 0754 grant_postgresql_privileges /etc/bacula/grant_postgresql_privileges
/usr/bin/install -c -m 0754 drop_postgresql_tables /etc/bacula/drop_postgresql_tables
/usr/bin/install -c -m 0754 drop_postgresql_database /etc/bacula/drop_postgresql_database
/usr/bin/install -c -m 0754 create_bacula_database /etc/bacula/create_bacula_database
/usr/bin/install -c -m 0754 update_bacula_tables /etc/bacula/update_bacula_tables
/usr/bin/install -c -m 0754 make_bacula_tables /etc/bacula/make_bacula_tables
/usr/bin/install -c -m 0754 grant_bacula_privileges /etc/bacula/grant_bacula_privileges
/usr/bin/install -c -m 0754 drop_bacula_tables /etc/bacula/drop_bacula_tables
/usr/bin/install -c -m 0754 drop_bacula_database /etc/bacula/drop_bacula_database
/usr/bin/install -c -m 0754 make_catalog_backup /etc/bacula/make_catalog_backup
/usr/bin/install -c -m 0754 delete_catalog_backup /etc/bacula/delete_catalog_backup
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/cats'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/dird'
==== Make of dird is good ====

/usr/bin/install -c -m 0754 bacula-dir /sbin/bacula-dir
/usr/bin/install -c -m 640 bacula-dir.conf /etc/bacula/bacula-dir.conf
/usr/bin/install -c -m 644 query.sql /etc/bacula/query.sql
make[1]: se sale del directorio `/data/Bacula/bacula-2.2.7/src/dird'
make[1]: se ingresa al directorio `/data/Bacula/bacula-2.2.7/src/stored'
===== Make of stored is good ====

/usr/bin/install -c -m 0754 bacula-sd /sbin/bacula-sd
/usr/bin/install -c -m 0754 bls /sbin/bls
/usr/bin/install -c -m 0754 bextract /sbin/bextract
/usr/bin/install -c -m 0754 bcopy /sbin/bcopy
/usr/bin/install -c -m 0754 bscan /sbin/bscan
/usr/bin/install -c -m 0754 btape /sbin/btape
/usr/bin/install -c -m 640 bacula-sd.conf /etc/bacula/bacula-sd.conf
Hola listeros:
He instalado PostgreSQL 8.2 en Linux Ubuntu Server 7.10. Ahora estoy tratando de compilar Bacula (Software para Copias de Seguridad Automáticas) para que me trabaje con PostgreSQL pero cuando intento correr el siguiente script:

if test xsqlite = xpostgresql -o xsqlite3 = xpostgresql ; then
echo "Creating SQLite database"
/etc/bacula/create_postgresql_database
else
if test xmysql = xpostgresql ; then
echo "Creating MySQL database"
/etc/bacula/create_mysql_database $*
else
echo "Creating PostgreSQL database"
/etc/bacula/create_postgresql_database $*
fi
fi

Y el de PostgreSQL lo que contiene es esto otro:
bindir=/usr/lib/postgresql/8.2/bin
db_name=bacula
if $bindir/psql -f - -d template1 $* <<END-OF-DATA
CREATE DATABASE ${db_name} $ENCODING;
ALTER DATABASE ${db_name} SET datestyle TO 'ISO, YMD';
END-OF-DATA
then
echo "Creation of ${db_name} database succeeded."
else
echo "Creation of ${db_name} database failed."
fi

Pero sorpresa me da este error:
./create_bacula_database
Creating PostgreSQL database
psql: FATAL: no existe el rol «root»
Creation of bacula database failed.

¿Qué me falta por hacer antes de crear la BD?

Ing. Reynier Pérez Mira

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2008-01-22 15:36:43 Re: Postgres o Mysql
Previous Message Neil Peter Braggio 2008-01-22 15:31:44 Re: dtspackpage en postgres