postgres encoding

[Sergei Karasiov]

Hi,

I have error in my log file:
"08-May 21:02 versus-server-dir JobId 126: Warning: Encoding error for database "bareos". Wanted SQL_ASCII, got UTF8"

and get empty file list when I try to restore this job:

"To select the JobIds, you have the following choices:
1: List last 20 Jobs run
2: List Jobs where a given File is saved
3: Enter list of comma separated JobIds to select
<skip>
Select item: (1-13): 3
Enter JobId(s), comma separated, to restore: 126
You have selected the following JobId: 126

Building directory tree for JobId(s) 126 ...

For one or more of the JobIds selected, no files were found,
so file selection is not possible.
Most likely your retention policy pruned the files."

I have some cyrillic filenames in this job.
But this job have T status when done but empty file list.

*list files jobid=126
+-------+---------------------+---------------------+------+-------+----------+-------------+-----------+
| jobid | name | starttime | type | level | jobfiles | jobbytes | jobstatus |
+-------+---------------------+---------------------+------+-------+----------+-------------+-----------+
| 126 | PsySite_second_pass | 2017-05-08 21:02:00 | B | F | 9,431 | 613,562,914 | T |
+-------+---------------------+---------------------+------+-------+----------+-------------+-----------+

How to resolve this?

SK

[Jörg Steffens]

On 08.05.2017 at 21:39 wrote Sergei Karasiov:
> Hi,
>
> I have error in my log file:
> "08-May 21:02 versus-server-dir JobId 126: Warning: Encoding error for database "bareos". Wanted SQL_ASCII, got UTF8"

[...]

How did you setup your database? The setup routine delivered with Bareos
(and Bacula) do setup the database with
ENCODING 'SQL_ASCII'


--
Jörg Steffens joerg.s...@bareos.com
Bareos GmbH & Co. KG Phone: +49 221 630693-91
http://www.bareos.com Fax: +49 221 630693-10

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Komplementär: Bareos Verwaltungs-GmbH
Geschäftsführer:
S. Dühr, M. Außendorf, Jörg Steffens, P. Storz

[Sergei Karasiov]

On Tuesday, 9 May 2017 11:59:52 UTC+3, Jörg Steffens wrote:
> On 08.05.2017 at 21:39 wrote Sergei Karasiov:
> > Hi,
> >
> > I have error in my log file:
> > "08-May 21:02 versus-server-dir JobId 126: Warning: Encoding error for database "bareos". Wanted SQL_ASCII, got UTF8"
> [...]
>
> How did you setup your database? The setup routine delivered with Bareos
> (and Bacula) do setup the database with
> ENCODING 'SQL_ASCII'

Hi,

it was my fault. I created DB by myself and missed point about ASCII_SQL.

There was an explanation in this list: https://groups.google.com/d/msg/bareos-users/JwdJB_ODkKc/KOsBAw5LaAgJ

I recreated database a hour ago and now have no errors and got full file list and have no problem to restore files.

SK