On 13 Jan 2007 at 12:27, Eric Bollengier wrote:
> Le Samedi 13 Janvier 2007 12:10, Andreas Németh a écrit :
> > Item 1: Adjust database-scripts to be able to run remotely
> > Origin: Andreas Nemeth [EMAIL PROTECTED]
> > Date: 13 January 2007
> > Status:
> >
> > What: Adjust the database scripts (see Notes) to take the hostname of
> > the machine where the database is running as an argument and pass it to the
> > database-client calls.
> >
> > Why: The scripts, in contrary to the director itself, make the
> > assumption that the database is running on localhost. This clearly has not
> > to be true.
> >
> > Notes: The affected scripts would be create_bacula_database,
> > drop_bacula_database, drop_bacula_tables, grant_bacula_privileges,
> > make_bacula_tables, update_bacula_tables, the respective
> > {mysql,postgresql}-scripts and make_catalog_backup.
>
> Hi,
>
> {mysql,postgresql}-scripts are using psql or mysql binary. both are able use
> remote database.
>
> these scripts are using $* which means that if you are using :
> ./make_bacula_tables -H myhost -U bacula
>
> "-H myhost -U bacula" will be used by mysql/psql in command line.
>
> see man mysql or man psql to have informations about Usage.
AFAIK, one script that MAY require modification is the backup script
for PostgreSQL. I was doing work for a client yesterday and noticed
there was no clear/obvious way to specify the host. Did I miss
something?
--
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php
PGCon - The PostgreSQL Conference - http://www.pgcon.org/
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
