[GENERAL] database size changed after restoring using pg_restore

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

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

michael.paqu...@gmail.com] Sent: Tuesday, 22 August 2017 10:37 AM To: Dylan Luong <dylan.lu...@unisa.edu.au> 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 <dylan.lu...@unisa.edu.

[GENERAL] enable PostgreSQL SSL from RPM package installation

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

[GENERAL] pg_rewind - enable wal_log_hints or data-checksums

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

Re: [GENERAL] issue performing a switchover with repmgr

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 <dylan.lu...@unisa.edu.au>; pgsql-general@postgresql.org S

[GENERAL] issue performing a switchover with repmgr

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

[GENERAL] controlled switchover with repmgr

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

[GENERAL] Postgres HA

is 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

[GENERAL] pgaudit_analyze process filling up audit log file

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

[GENERAL] pgAudit_Analyze - parse error in pgaudit_analyze.log

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

Re: [GENERAL] Install pgAudit extension

- From: Devrim Gündüz [mailto:dev...@gunduz.org] Sent: Tuesday, 6 December 2016 5:44 PM To: Dylan Luong <dylan.lu...@unisa.edu.au>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Install pgAudit extension Hi, On Tue, 2016-12-06 at 05:44 +, Dylan Luong wrote: > I need so

[GENERAL] Install pgAudit extension

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

[GENERAL] pgpool fail to load balance after database restart

no timeout. # Note that this value is not only used for health check, # but also for ordinary conection to backend. Thanks. Dylan Luong Information Strategy & Technology Services University of South Australi