i've found how to change the datestyle only for 1 DB.
What i've found says when we create the DB it takes options from the templates,
if we want to have a different datestyle we must:
1) relay on a template who meets our needs.
2) alter the DB after creating it. <-- ( i think it's the easy way )
may be the script how creates the bacula db for postgresql can be like this:
#!/bin/sh
#
# shell script to create Bacula database(s)
#
bindir=/usr/bin
if $bindir/psql -f - -d template1 $* <<END-OF-DATA
CREATE DATABASE bacula;
ALTER DATABASE "bacula" SET DATESTYLE='ISO, MDY';
END-OF-DATA
then
echo "Creation of bacula database succeeded."
else
echo "Creation of bacula database failed."
fi
exit 0
In this way we don't have to hope the default datestyle is set to what we need.
Bill Moran wrote:
On Wed, 22 Mar 2006 22:55:17 +0100
Kern Sibbald <[EMAIL PROTECTED]> wrote:
On Wednesday 22 March 2006 22:19, Carles Bou wrote:
Some one has send me a mail telling that bacula only supports datetime
encoding in US format i've changed this parameter in the postgresql.conf
and bacula is running right!!
Will this be solved in futures versions?
I hope there is some PostgreSQL solution for this, because it is *extremely*
unlikely that I will add any code to Bacula that tries to interpret foreign
language date formats.
The date format _can_ be set on a database-by-database basis. It's
not completely obvious how to do this, and I don't remember the
details, but I dealt with this a few months ago. The fix is to
connect to the database and change a setting.
The setting in postgresql.conf is what is used if the database format
is not explicitly set. Changing the setting in a particular database
will override it. Do some searches on the PostgreSQL mailing list
archives and you should find the solution.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
