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
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 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.
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
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
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
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
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
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
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
-
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 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
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
13 matches
Mail list logo