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

2018-11-20 Thread George Anchev via Bacula-users
On Tue, 20 Nov 2018 17:47:49 -0600 Dimitri Maziuk via Bacula-users wrote: > Check that wal archive_mode is off in > postgresql.conf and also all replication-related > stuff. grep -iE "replic|archive_mode" postgresql.conf shows only commented lines. Need I change anything? > Try `psql -U postgre

[Bacula-users] PostgreSQL: WAL and log management

2018-11-20 Thread Dimitri Maziuk via Bacula-users
PS https://www.postgresql.org/docs/10/sql-checkpoint.html -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature ___ Bacula-users mailing list Bacula-users@l

Re: [Bacula-users] Looking for a LTO autoloader (NeoT24 works)

2018-11-20 Thread Stieneke, Dan via Bacula-users
Sorry it’s late – I don’t read the Bacula list every day. We successfully use a Neo T24, LTO-6, SAS interface, LSI SAS 9207-8e controller, on UB 18.04LTS in ESXi 6.0 (you have to use hardware passthrough on the SAS controller card to use a SAS tape drive in ESXi). We previously used a Tandberg

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

2018-11-20 Thread Dimitri Maziuk via Bacula-users
On 11/20/2018 04:56 PM, George Anchev via Bacula-users wrote: > On the link I read wal_keep_segments "Specifies the > *minimum* number of past log file segments kept in the > pg_wal directory". Isn't there a setting which > controls the *maximum* number/volume/retention of those > files? (like in

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

2018-11-20 Thread George Anchev via Bacula-users
On Tue, 20 Nov 2018 16:34:58 -0600 Dimitri Maziuk via Bacula-users wrote: > I've 320MB on a server that replicates a database of > a few million rows, and ~100MB on our bacula server > w/ a year's worth of backups. What do you call "too > big"? As shared in the first message: Right now, even afte

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

2018-11-20 Thread Dimitri Maziuk via Bacula-users
On 11/20/2018 03:49 PM, George Anchev via Bacula-users wrote: > On Mon, 19 Nov 2018 17:16:52 -0600 Dimitri Maziuk via > Bacula-users wrote: > >> https://www.postgresql.org/docs/10/routine-vacuuming.html > > Good info. Thanks. > >> WAL: don't worry about it unless you want to archive >> them or r

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

2018-11-20 Thread George Anchev via Bacula-users
On Mon, 19 Nov 2018 17:16:52 -0600 Dimitri Maziuk via Bacula-users wrote: > https://www.postgresql.org/docs/10/routine-vacuuming.html Good info. Thanks. > WAL: don't worry about it unless you want to archive > them or replicate your database. But the pg_wal directory is way too big and I have n