Re: [Bacula-users] PostgreSQL: WAL and log management

On 11/19/2018 04:12 PM, George Anchev via Bacula-users wrote: > 1. Am I doing everything correctly? https://www.postgresql.org/docs/10/routine-vacuuming.html > 2. How to manage WAL and logs so that old unnecessary > data doesn't fill up disk (and backup tape) space? Logs: https://www.postgresql

[Bacula-users] PostgreSQL: WAL and log management

Hi, So... I tested the whole process of migrating MariaDB database to PostgreSQL. But psql seems a different beast. What is confusing for me: After several runs of {drop|make|grant}_bacula_tables scripts for the sake of cleaning up and starting from scratch while testing the process, I notice tha

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

Great. Thanks again Martin. -- George ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

On Mon, 19 Nov 2018 17:29:21 GMT Martin Simmons wrote: > rpm -qf ...path..to..libpq.so... # rpm -qf /usr/lib64/libpq.so postgresql10-devel-10.5-lp150.3.3.1.x86_64 How do I use this info? -- George ___ Bacula-users mailing list Bacula-users@lists.sou

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

> On Mon, 19 Nov 2018 19:04:06 +0200, George Anchev via Bacula-users said: > > Thanks for clarifying. My only concern is to be able > to backup and restore correctly files with non-ASCII > names (e.g. UTF-8 or anything that the file systems > support). Yes, that's exactly what using SQL_ASCII

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

> On Mon, 19 Nov 2018 19:00:55 +0200, George Anchev via Bacula-users said: > > Same empty output. The libpq files must be in some other package then. If you have found the .so file then you can check what owns it by rpm -qf ...path..to..libpq.so... __Martin __

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

On Mon, 19 Nov 2018 11:32:24 GMT Martin Simmons wrote: > SQL_ASCII [...] Thanks for clarifying. My only concern is to be able to backup and restore correctly files with non-ASCII names (e.g. UTF-8 or anything that the file systems support). -- George ___

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

On Mon, 19 Nov 2018 10:40:42 GMT Martin Simmons wrote: > Sorry, I meant -ql rather than -qi. Same empty output. -- George ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

> On Mon, 19 Nov 2018 01:24:18 +0200, George Anchev via Bacula-users said: > > On Fri, 16 Nov 2018 12:50:12 +0200 George Anchev wrote: > > > https://www.bacula.org/9.2.x-manuals/en/main/Installing_Configuring_Post.html > > Can anyone please explain why SQL_ASCII is strongly > recommended? Wo

Re: [Bacula-users] Migrating from MariaDB to PostgreSQL

> On Sat, 17 Nov 2018 00:25:17 +0200, George Anchev via Bacula-users said: > > On Fri, 16 Nov 2018 18:15:43 GMT Martin Simmons wrote: > > > rpm -qi postgresql | grep libpq > > That shows empty output. Sorry, I meant -ql rather than -qi. __Martin __