ect_timeout = 1
# Timeout value in milliseconds before
giving up to connect to backend.
# Default is
1 ms (10 second). Flaky network user may want to increase
# the value.
0 m
Hi
I need some advice on installing the pgAudit extension as I am new to
PostgreSQL extenstions.
I currently have Postgres95 on Linux Redhat 6.8 running on the server and I
need to test out the pgAudt extension.
I downloaded the file pgaudit-REL9_5_STABLE.zip from
https://github.com/pgaudit/pg
-
From: Devrim Gündüz [mailto:dev...@gunduz.org]
Sent: Tuesday, 6 December 2016 5:44 PM
To: Dylan Luong ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Install pgAudit extension
Hi,
On Tue, 2016-12-06 at 05:44 +, Dylan Luong wrote:
> I need some advice on installing the pgAudit extens
Hi
I have configured pgAudit extension on my DEV PostgreSQL instance.
I am trying to configure the pgAudit_Analyze to read the audit logs and loads
them into a database table.
Following the steps in https://github.com/pgaudit/pgaudit_analyze I have perl
script pgaudit_analyze running as a daemon
Hi
I have installed and configured pgAudit extension and the pgAudit Analyzer
https://github.com/pgaudit/pgaudit/tree/REL9_5_STABLE
https://github.com/pgaudit/pgaudit_analyze
I have several databases in the PostgreSQL instance and created the extension
and setup the pgaudit analyzer for these dat
greatly appreciated.
Regards
Dylan
Dylan Luong
Information Strategy & Technology Services
University of South Australia
A Building, Room E2-07, Mawson Lakes Campus
MAWSON LAKES
South Australia 5095
Email:dylan.lu...@unisa.edu.au<mailto:dylan.lu...@unisa.edu.au>
Phone:+61 8 83
Hi
In a controlled switchover from master to slave with repmgr, what is the
downtime timeframe? Seconds?
What is the internal process involved in a switchover with repmgr? Is the
process all automated? Will there be data loss?
Regards
Dylan
Hi
I have setup a master/standby on PostgreSQL95 on two test servers and trialing
out repmgr. (https://github.com/2ndQuadrant/repmgr/)
I am testing a switchover using the following:
-bash-4.1$ repmgr -f /etc/repmgr/9.5/repmgr.conf -C /etc/repmgr/9.5/repmgr.conf
standby switchover -L DEBUG -v
Thanks for you answer. So is there a way to remove this -w from the repmgr
switchover process?
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, 22 May 2017 10:27 PM
To: Dylan Luong ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] issue
Hi
In the PostgreSQL documentation for pg_rewind:
pg_rewind requires that the target server either has the wal_log_hints option
enabled in postgresql.conf or data checksums enabled when the cluster was
initialized with initdb.
What is the difference between the two options?
What are the advan
Hi
I have installed PostgreSQL from the following RPMs onto the server. And I
would like to enable SSL.
postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64
postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64
postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
postgresql96-server-9.6.2-2PGDG.rhel7.x86_64
postgresql96-9.
ilto:michael.paqu...@gmail.com]
Sent: Tuesday, 22 August 2017 10:37 AM
To: Dylan Luong
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_rewind - restore new slave failed to startup during
recovery
On Tue, Aug 22, 2017 at 9:52 AM, Dylan Luong wrote:
> I have 1 master and 1 slave wal streami
Hi
I am upgrading some databases from a PostgreSQL 9.2 server to a new PostgreSQL
9.6 server.
I used pg_dump and pg_restore for the upgrade.
This is the command I used to dump the database. I ran the command from the 9.6
server.
pg_dump -h 9.2server -j 16 --format=directory -f
/pg_backup/backu
13 matches
Mail list logo
