Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain

2019-02-28 Thread Andre Piwoni
I think setting up PAM authentication with AD on Linux server joined to domain via realm SSSD was much easier and transparent. Something like this worked for me to create SPN mapping and keytab in one command without need to use UPPERCASE for POSTGRES: ktpass -out postgres.keytab -princ POSTGRES/u

Re: Promoted slave tries to archive previously archived WAL file

2019-02-19 Thread Andre Piwoni
nsion. On Sun, Feb 17, 2019 at 5:27 PM Michael Paquier wrote: > On Fri, Feb 15, 2019 at 12:03:39PM -0800, Andre Piwoni wrote: > > My slave nodes were created using pg_basebackup with --wal-method=stream. > > If I understand right this option streams WAL files generated during >

Re: Promoted slave tries to archive previously archived WAL file

2019-02-15 Thread Andre Piwoni
file based on diff. On Fri, Feb 15, 2019 at 10:23 AM Andre Piwoni wrote: > I have master and slave running with the following contents of their > pg_wal directories and archivedir: > > ls -l /mnt/pgsql/archive/ > -rw-rw-rw-. 1 root root 16777216 Feb 15 09:39 0001

Promoted slave tries to archive previously archived WAL file

2019-02-15 Thread Andre Piwoni
the new primary? -- *Andre Piwoni*

Correct setup for 3+ node cluster with streaming replication and WAL archiving

2019-02-14 Thread Andre Piwoni
19-02-14 11:13:25.149 PST [5839] DEBUG: switched WAL source from stream to archive after failure cp: cannot stat ‘/mnt/pgsql/archive/00010007’: No such file or directory 2019-02-14 11:13:25.154 PST [5839] DEBUG: could not restore file "00010007" from archive: child process exited with exit code 1 2019-02-14 11:13:25.154 PST [5839] DEBUG: invalid resource manager ID 64 at 0/798 *Andre Piwoni*