pgsql-admin - January 2021

PostgreSQL administration (excludes pgAdmin application support, which can be found on the pgadmin-support list)

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 13 14 15 16 18 19 20 22 23 25 26 27 28 29 30 31

Jan. 2, 2021

Thread Author Time
recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751) 📎 Li EF Zhang 04:11
Re: recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751) Magnus Hagander 11:50

Jan. 4, 2021

Thread Author Time
Postgres 12.4 inner join with where statement = 'string' returning error VAE Ventures 01:33
Re: Postgres 12.4 inner join with where statement = 'string' returning error Ron 02:45
Re: Postgres 12.4 inner join with where statement = 'string' returning error David G. Johnston 03:13
RE: recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751) 📎 Li EF Zhang 10:17
pg_rewind restore_command issue in PG12 Amine Tengilimoglu 10:19
question about database recover proceduers jian xu 17:54
Re: question about database recover proceduers jian xu 19:10

Jan. 5, 2021

Thread Author Time
Looking for tool help dbatoCloud Solution 06:01
Re: Looking for tool help hubert depesz lubaczewski 10:43

Jan. 6, 2021

Thread Author Time
master and slave at same time Yambu 13:17
Re: master and slave at same time Atul Kumar 13:27
Re: master and slave at same time Yambu 13:31
Logical replication use cases Yambu 13:33
Re: master and slave at same time Michael Banck 13:36
Re: Logical replication use cases Sushant Pawar 15:03
quick q re migration, index, stats Scott Ribe 16:41
autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor Henry Francisco Garcia Cortez 17:05

Jan. 7, 2021

Thread Author Time
Re: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor Laurenz Albe 01:53
Re: quick q re migration, index, stats Laurenz Albe 01:56
Re: quick q re migration, index, stats Scott Ribe 03:24
Showing materialized views John Scalia 13:41
Re: Showing materialized views John Scalia 14:06
Re: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor Henry Francisco Garcia Cortez 16:56
HA through Azure snapshots? Ron Watkins 21:35

Jan. 8, 2021

Thread Author Time
PostgreSQL Upgrade 11 to 12 pgdba pgdba 08:20
Re: PostgreSQL Upgrade 11 to 12 Laurenz Albe 09:01
Re: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor Laurenz Albe 09:04
Permission to create a table in postgresql database dbatoCloud Solution 13:58
Re: Permission to create a table in postgresql database Paul Förster 14:11
Re: Permission to create a table in postgresql database Laurenz Albe 14:40

Jan. 9, 2021

Thread Author Time
I need to complex Query - need big support dbatoCloud Solution 09:15
Re: I need to complex Query - need big support dbatoCloud Solution 18:00
Re: I need to complex Query - need big support Bruce Momjian 18:06

Jan. 13, 2021

Thread Author Time
PostgreSQL replication failover Jan Peters 08:27
Re: PostgreSQL replication failover Laurenz Albe 11:25
Re: PostgreSQL replication failover Pepe TD Vo 13:24
Re: PostgreSQL replication failover Laurenz Albe 16:57
Re: PostgreSQL replication failover Ganesh Korde 18:46

Jan. 14, 2021

Thread Author Time
Aw: Re: PostgreSQL replication failover Jan Peters 08:16
Removing second slave server Yambu 12:18
Re: PostgreSQL replication failover John Wiencek 15:03
Re: Removing second slave server Jerry Sievers 15:51

Jan. 15, 2021

Thread Author Time
pgbadger issue S Bob 01:42
Odd config issue, cannot set log_min_duration_statement S Bob 02:12
Re: Odd config issue, cannot set log_min_duration_statement Tom Lane 02:31
Re: Odd config issue, cannot set log_min_duration_statement Scott Ribe 02:37
Re: Odd config issue, cannot set log_min_duration_statement S Bob 02:47
Re: Odd config issue, cannot set log_min_duration_statement S Bob 02:49
Re: Odd config issue, cannot set log_min_duration_statement Tom Lane 02:53
Re: Odd config issue, cannot set log_min_duration_statement S Bob 03:01
Re: Odd config issue, cannot set log_min_duration_statement Tom Lane 03:09
Re: Removing second slave server Yambu 07:46
Re: pgbadger issue Guillaume Lelarge 08:57
PG admin is using too much memory Sachin Kumar 12:51
streaming replication between postgres and enterprisedb Atul Kumar 13:08
Re: streaming replication between postgres and enterprisedb Ian Lawrence Barwick 13:24
Uninstalling postgres dangers Yambu 13:33
Re: Uninstalling postgres dangers Alvaro Aguayo 13:39
Re: PG admin is using too much memory Sachin Kumar 13:45
Data migration from postgres 9.5 to enterprisedb 10 Atul Kumar 15:23
Re: Data migration from postgres 9.5 to enterprisedb 10 David G. Johnston 15:28
Re: streaming replication between postgres and enterprisedb Laurenz Albe 16:16

Jan. 16, 2021

Thread Author Time
[No subject] maicon ferreira da silva 03:37

Jan. 18, 2021

Thread Author Time
Re: How to manage null value while copy data from csv Blairemaloneback 15:40

Jan. 19, 2021

Thread Author Time
hot standby in Postgresql 12 Ankush Chawla 03:20
Re: hot standby in Postgresql 12 David G. Johnston 03:31
Re: hot standby in Postgresql 12 Ankush Chawla 03:33
Re: hot standby in Postgresql 12 David G. Johnston 03:48
Re: hot standby in Postgresql 12 Ankush Chawla 04:14
Re: hot standby in Postgresql 12 David G. Johnston 04:24
Re: hot standby in Postgresql 12 Paul Förster 05:48
Re: hot standby in Postgresql 12 Ankush Chawla 06:17
Re: hot standby in Postgresql 12 David G. Johnston 06:26
Aw: Re: PostgreSQL replication failover Jan Peters 08:12
Re: hot standby in Postgresql 12 Dominik Lehnen 09:02
Re: Re: PostgreSQL replication failover Ganesh Korde 09:09
Re: hot standby in Postgresql 12 Ganesh Korde 09:19
Re: hot standby in Postgresql 12 Ankush Chawla 09:20
Re: hot standby in Postgresql 12 Ankush Chawla 09:32
Re: hot standby in Postgresql 12 Laurenz Albe 09:32
planned switch over master/slave Yambu 09:55
Re: planned switch over master/slave Amine Tengilimoglu 10:02
Clean Postgres shutdown Yambu 10:10
Table Partitioning Anjul Tyagi 10:21
Re: Clean Postgres shutdown Laurenz Albe 11:00
Re: Clean Postgres shutdown Magnus Hagander 11:02
Re: Table Partitioning hubert depesz lubaczewski 11:42
Re: Table Partitioning Anjul Tyagi 12:01
Re: Table Partitioning hubert depesz lubaczewski 12:12
Re: Table Partitioning Keith Fiske 13:32
Re: Table Partitioning Graham Everton 15:00
Re: hot standby in Postgresql 12 David G. Johnston 15:11
Re: Table Partitioning Amit jain 15:15
Re: Table Partitioning lazaro garcia 15:55
TIL: In pg_dump, beware the combo of "-Fd" and "-Z" Ron 18:48
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" David G. Johnston 19:55
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" Ron 21:11
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" David G. Johnston 21:25
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" Scott Ribe 21:27
Re: hot standby in Postgresql 12 Rajni Baliyan 21:55
Re: hot standby in Postgresql 12 David G. Johnston 22:03
Re: hot standby in Postgresql 12 Rajni Baliyan 23:15

Jan. 20, 2021

Thread Author Time
Re: hot standby in Postgresql 12 Ankush Chawla 03:10
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" Adrian Ho 04:54
Re: Table Partitioning Anjul Tyagi 04:58
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" Ron 05:37
3 Parameters in pg_settings in CamelCase William Sescu (Suva) 08:56
Data Type to store Leading Zero(0) soumik.bhattacharjee 11:13
Re: Data Type to store Leading Zero(0) Nidhi Gupta 11:20
RE: Data Type to store Leading Zero(0) Kanninen Anssi EXT 11:29
RE: Data Type to store Leading Zero(0) soumik.bhattacharjee 11:32
Re: 3 Parameters in pg_settings in CamelCase Ian Lawrence Barwick 11:36
Re: Data Type to store Leading Zero(0) Thomas Kellerer 12:39
Re: Data Type to store Leading Zero(0) David G. Johnston 14:49
standby compatibility matrix Ankush Chawla 15:56
Re: standby compatibility matrix Holger Jakobs 16:03
Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" Tom Lane 20:27

Jan. 22, 2021

Thread Author Time
RE: Data Type to store Leading Zero(0) Michel SALAIS 07:57
Regarding 500 Internal Server Error 📎 pavan srivathsav 08:04
Re: Regarding 500 Internal Server Error Stéphane KANSCHINE 08:40
Create Read only user Yambu 08:58
Re: Create Read only user Rohit Rajput 09:05
max_worker_processer configuration for DWH databases? dbatoCloud Solution 13:13
Re: max_worker_processer configuration for DWH databases? Bk B 14:15
Re: max_worker_processer configuration for DWH databases? dbatoCloud Solution 14:34
Re: Create Read only user Tim Cross 19:36
Re: Create Read only user Holger Jakobs 20:09

Jan. 23, 2021

Thread Author Time
Re: Create Read only user Wells Oliver 00:14
Re: Create Read only user Ron 00:26
Re: Create Read only user Tom Lane 00:38

Jan. 25, 2021

Thread Author Time
json_build_object, numeric types, and function limits on 100 arguments Wells Oliver 22:41
Unique constraint across all partitions? S Bob 22:44
Re: Unique constraint across all partitions? Ron 23:02

Jan. 26, 2021

Thread Author Time
Re: Unique constraint across all partitions? David G. Johnston 00:01
Re: Unique constraint across all partitions? Ron 00:09
Re: Unique constraint across all partitions? Laurenz Albe 08:33
Re: Unique constraint across all partitions? Thomas Kellerer 08:48
Re: Unique constraint across all partitions? Victor Yegorov 09:54
RE: Unique constraint across all partitions? Kanninen Anssi EXT 10:09
Re: Unique constraint across all partitions? Thomas Kellerer 11:08
RE: Unique constraint across all partitions? Michel SALAIS 11:13
productive usage of PostgreSQL with Windows Server Dirk Krautschick 11:20
Re: productive usage of PostgreSQL with Windows Server Michael Banck 11:58
Re: productive usage of PostgreSQL with Windows Server Holger Jakobs 12:23
Re: productive usage of PostgreSQL with Windows Server Bo Victor Thomsen 13:01
Re: productive usage of PostgreSQL with Windows Server Thomas Kellerer 13:30
Re: json_build_object, numeric types, and function limits on 100 arguments Alvaro Herrera 13:52
RE: productive usage of PostgreSQL with Windows Server Karsten Lenz (KLE) 14:05
Re: Unique constraint across all partitions? Ron 14:21
How to change mode for cluster log? Binghan 14:33
Re: How to change mode for cluster log? Paul Förster 14:43
Re: json_build_object, numeric types, and function limits on 100 arguments Wells Oliver 19:10
Re: json_build_object, numeric types, and function limits on 100 arguments Tom Lane 21:42

Jan. 27, 2021

Thread Author Time
Re: json_build_object, numeric types, and function limits on 100 arguments Wells Oliver 06:39
Re: json_build_object, numeric types, and function limits on 100 arguments Thomas Kellerer 07:04
Re: json_build_object, numeric types, and function limits on 100 arguments Wells Oliver 07:10
AW: productive usage of PostgreSQL with Windows Server Dischner, Anton 09:05

Jan. 28, 2021

Thread Author Time
Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution 12:35
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia 12:48
pglogical with bytea values Dirk Krautschick 14:37
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution 15:54
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia 16:14
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution 16:30
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia 17:07
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution 17:33
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL R.R. PRAVEEN RAJA 18:05
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia 18:25

Jan. 29, 2021

Thread Author Time
FK cascade delete permissions Q Wells Oliver 18:57
Re: FK cascade delete permissions Q David G. Johnston 19:12
Re: FK cascade delete permissions Q Wells Oliver 19:14

Jan. 30, 2021

Thread Author Time
Schema Restore Issue Omkar Dhorge 19:34
Re: Schema Restore Issue Tom Lane 22:03
Re: Schema Restore Issue Omkar Dhorge 22:12

Jan. 31, 2021

Thread Author Time
Little help with the server export function Ted Gulesserian 16:48
Re: Little help with the server export function Holger Jakobs 19:10

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 13 14 15 16 18 19 20 22 23 25 26 27 28 29 30 31