RE: PostgreSQL-12 replication. Check replication lag

Hi, You could achieve that with a combination of those functions and querying the pg_stat_replication on either side of your setup. Regards, [Fuji Xerox Australia] Nawaz Ahmed Database Administrator Fuji Xerox Australia Pty. Limited 8 Khartoum Rd, Macquarie Park NSW 2113 Australia | P: 02 9856

RE: Q: Comparing PostgreSQL and Oracle

Hi, With massive development within OSS PosgreSQL over the years, there is plenty of things it can do when compared to Oracle. The below URLs give you a comprehensive comparison table, I am sure you or your colleagues may have already stumbled upon these URLs. In addition to that, there is some

RE: How to restore database to previous state

Hi, Have you looked at the recovery parameter as below ? recovery_target_time Using this, you could achieve a PITR of the current database. If the recovery requires WAL that does not exist on disk then you may have to restore it from previous night's backup. Please have a look at the docs for

RE: POLL: Adding transaction status to default psql prompt

+1 -Original Message- From: Vik Fearing Sent: Thursday, 6 February 2020 1:55 PM To: pgsql-general@lists.postgresql.org Subject: POLL: Adding transaction status to default psql prompt Hello, I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql. The effect of this is:

RE: Max_connections limit

Hi, If you reckon the application initiates such a large number of concurrent connections, I'd suggest you configure a connection pooler to avoid the connection overhead by PostgreSQL. max_connections will be the parameter you are looking at to configure but ensure it is configured in conjuncti

RE: how to upgrade production PostgreSQL from 9.4 to 11.3

Your best bet is to use Slony, can be time consuming and a lot of hassle for the initial setup but worth all that effort when the downtime is reduced (between seconds to a couple of minutes) for such a large system. [Fuji Xerox Australia] Nawaz Ahmed Database Administrator [http://xww.aus.xerox.

RE: Barman disaster recovery solution

Sent: Thursday, 28 February 2019 7:41 PM To: Achilleas Mantzios ; Ahmed, Nawaz ; pgsql-general@lists.postgresql.org Subject: Re: Barman disaster recovery solution On 2/28/19 9:21 AM, Achilleas Mantzios wrote: > On 28/2/19 1:08 π.μ., Ahmed, Nawaz wrote: >> >> Hi, >> >&g

RE: connection error

Hi, Are you sure it is /23 and not /32 for the CIDR notation ? hostall all 127.0.0.1/32 trust hostall all 127.0.0.1/23 trust hostall all 172.29.1

RE: Service pgpool

And also the contents of the unit file itself and some more details whether is it the first time you are trying to get it work or it used to work but suddenly stopped working etc. The contents of the unit file could give a clue whether it was some typo or the sequence at which the different dire

RE: Postgresql database encryption

Hi Folks, I would like to add to the list FUJITSU Software Enterprise Postgres as well, a commercial version of FSEP offers both TDE (AES 128 / 256) and Data Masking features PremierSQL TDE MariaDB 10.1.3+ MySQL 5.7.11+ Microsoft uses TDE Oracle AdvSec uses TDE DB2 v7.2 UDB MangoDB uses AES-256

RE: Barman 2.3 errors

Hi Nicolas, I would like to take stab at this one, as i had recently worked on a demo of barman. But like Michael Paquier said, it is better to check the information i provide and the situation you are facing with the maintainers of the project. Here is what i found. The first thing is to che

RE: Moving from pgFouine to pgBadger Issue with Total query duration metric

Hi, It could be a case of pgFouine not picking up/reporting all the queries when it calculates those stats. I see all the metrics matching closely in either reports except for the total query duration and query peak times. pgFouine thinks that there has been a peak of 6 queries/second at 2018-0

RE: Replica on low-bandwitdh network

You might as well try Slony. Best Regards, Nawaz Ahmed -Original Message- From: Job [mailto:j...@colliniconsulting.it] Sent: Tuesday, 5 December 2017 8:12 PM To: pgsql-gene...@postgresql.org Subject: Replica on low-bandwitdh network Hi guys, we have some postgreswl 9.6.1 servers in