On Saturday 13 January 2007 17:02, Dan Langille wrote:
> 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?
You probably did not miss anything, but keep in mind that the database backup
scripts were implemented to be a sort of template or prototype that users can
modify to suit their particular needs.
>
> --
> 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
>
-------------------------------------------------------------------------
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
