Re: database lagging
yes, I'm running replication database. Parameters below are on both master and slave's postgresql.conf
wal_level = replica
synchronous_commit = on
synchronous_standby_names ='*'
server storage is fine. Plenty of spaces on pg_wal (local), only 5% used from 80G. Look like only all write have problems and read is ok.
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Friday, July 23, 2021, 03:11:58 PM EDT, Avinash Kumar <avinash.vallarapu@gmail.com> wrote:
Hi,
On Fri, Jul 23, 2021 at 2:52 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
I am doing CIS Benchmart on Postgreql 12. After alter parameters and when I tried to create a new role. It's lagging and didn't prompt out the result, until I hit the ctl C key. Even alter role. All I needed to hit ctl C key if not, it hung there for ever. Is there a way to fix it?postgres=# create role appuser;^CCancel request sentCREATE ROLE
I would only expect such a behaviour when there is Synchronous Replication enabled but the Standby is not reachable.
Check the parameters : synchronous_mode combined with synchronous_standby_names.
Check the parameters : synchronous_mode combined with synchronous_standby_names.
postgres=# ALTER ROLE appuser NOSUPERUSER;^CCancel request sentALTER ROLEpostgres=# ALTER ROLE appuser NOREPLICATION;^CCancel request sentALTER ROLEpostgres=# ALTER ROLE appuser NOCREATEROLE;^CCancel request sentALTER ROLEpostgres=# ALTER ROLE appuser NOHERIT;^CCancel request sentALTER ROLE
В списке pgsql-admin по дате отправления:
Предыдущее
От: Stephen FrostДата:
Сообщение: Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?