pgsql-admin since 2020-03-27 00:00

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

March 27, 2020

Thread Author Time
Re: Vacuum Issues Jerry Sievers 00:04
Re: Vacuum Issues Keith 01:35
Re: PG12 autovac issues Michael Paquier 05:12
Re: Vacuum Issues Rui DeSousa 06:11
Re: PG12 autovac issues Julien Rouhaud 19:23
Re: PG12 autovac issues Justin King 22:10

March 28, 2020

Thread Author Time
Re: PG12 autovac issues Michael Paquier 08:47
Re: PG12 autovac issues Michael Paquier 08:53
Re: PG12 autovac issues Andres Freund 18:29

March 29, 2020

Thread Author Time
Re: PG12 autovac issues Michael Paquier 07:19

March 30, 2020

Thread Author Time
Re: Migration Help. srijith s 16:35
Re: PG12 autovac issues Michael Paquier 23:52

March 31, 2020

Thread Author Time
migrate off oracle data to postgres Pepe TD Vo 14:15
Re: migrate off oracle data to postgres John Wiencek 14:20
Re: migrate off oracle data to postgres Jan Birk 14:35
Re: migrate off oracle data to postgres Thomas Kellerer 14:58
Re: migrate off oracle data to postgres JC JC 15:46
Re: migrate off oracle data to postgres Pepe TD Vo 15:51
Re: migrate off oracle data to postgres Adrian Klaver 15:54
Re: migrate off oracle data to postgres Virendra Kumar 16:08
Re: migrate off oracle data to postgres JC JC 16:09
Re: migrate off oracle data to postgres Pepe TD Vo 16:45
Re: migrate off oracle data to postgres JC JC 17:00

April 1, 2020

Thread Author Time
Can not make further subscriptions Tim Johnson 00:57
Re: Can not make further subscriptions Ramakrishna Chava 02:29
LDAP Configuration Anjul Tyagi 10:29
Re: LDAP Configuration Laurenz Albe 11:33
Re: LDAP Configuration Anjul Tyagi 11:49
Re: LDAP Configuration Stephen Frost 13:19
Re: Can not make further subscriptions Tim Johnson 15:20
Re: Can not make further subscriptions Tim Johnson 15:42
Use of "limit" to return a subset of query results Alanoly Andrews 18:09
FW: Use of "limit" to return a subset of query results Alanoly Andrews 19:03

April 2, 2020

Thread Author Time
Re: Can not make further subscriptions Ramakrishna Chava 02:31
PG query to count all objects Prashant Kulkarni 08:48
Re: PG query to count all objects Ashutosh Sharma 10:55
Could someone please help us share the procedure to troubleshoot the locks on proc issues. 📎 postgann2020 s 19:37
Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables postgann2020 s 19:51
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables David G. Johnston 20:59
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. Adrian Klaver 23:00

April 3, 2020

Thread Author Time
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. postgann2020 s 05:11
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables postgann2020 s 05:15
Can we extract CPU usage by table/query level Ishan joshi 06:19
Re: Can we extract CPU usage by table/query level Julien Rouhaud 07:03
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables David G. Johnston 07:25
How to get off the email list? Richard Bernstein 16:35
RE: How to get off the email list? Ken Benson 16:36
postgres performance on azure Mark Steben 17:41
Re: postgres performance on azure 📎 Samed YILDIRIM 18:01

April 4, 2020

Thread Author Time
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables postgann2020 s 03:02
NEEDING HELP: dropping none-existing extension Axel Rau 15:48
Re: NEEDING HELP: dropping none-existing extension Tom Lane 16:09
Re: NEEDING HELP: dropping none-existing extension Ron 16:24
Re: NEEDING HELP: dropping none-existing extension Axel Rau 16:47

April 5, 2020

Thread Author Time
Problem with pgadmin4 : displaying data in the query editor Saad SENOUCI 15:21

April 6, 2020

Thread Author Time
Re: Problem with pgadmin4 : displaying data in the query editor Cibeles Redondo Veloso 14:25
Significance of backend_xmin in pg_stat_activity view postgann2020 s 17:41

April 7, 2020

Thread Author Time
pg_rewind interesting issue. Any feedback appreciated J T 00:30
Re: Significance of backend_xmin in pg_stat_activity view Laurenz Albe 06:27
Vault or AWS/IAM Toomas Kristin 06:43
Re: Vault or AWS/IAM Prince Pathria 21:33
Re: Vault or AWS/IAM Gurvinder Singh 23:19

April 8, 2020

Thread Author Time
Re: Vault or AWS/IAM Toomas Kristin 06:01
How to get more than 2^32 BLOBs Donato Marrazzo 09:15
Re: How to get more than 2^32 BLOBs Laurenz Albe 10:06
Re: How to get more than 2^32 BLOBs Donato Marrazzo 10:12
logical replication on 12.2: failed to increase restart lsn: Axel Rau 11:30
Re: How to get more than 2^32 BLOBs Christophe Courtois 11:41
Re: How to get more than 2^32 BLOBs Laurenz Albe 12:04
Re: How to get more than 2^32 BLOBs Donato Marrazzo 13:14
Re: Significance of backend_xmin in pg_stat_activity view postgann2020 s 17:50

April 10, 2020

Thread Author Time
Need help to resolve plprofiler error "Exception: No profiling data found" postgann2020 s 16:36

April 12, 2020

Thread Author Time
proc state as "Idle_in_transaction" in pg_stat_activity postgann2020 s 12:37
Re: proc state as "Idle_in_transaction" in pg_stat_activity David G. Johnston 16:15

April 13, 2020

Thread Author Time
Help needed on optimizing query 📎 Mark Steben 14:07
Re: Help needed on optimizing query Ron 14:24
Re: Help needed on optimizing query Mark Steben 14:48
Re: Help needed on optimizing query Ron 15:02
Re: Help needed on optimizing query Erik Serrano 15:06
Re: Help needed on optimizing query Mark Steben 15:23
Re: Help needed on optimizing query Tom Lane 15:33
Re: proc state as "Idle_in_transaction" in pg_stat_activity Jeff Janes 17:24

April 14, 2020

Thread Author Time
Re: proc state as "Idle_in_transaction" in pg_stat_activity postadmin2020 S 07:06

April 15, 2020

Thread Author Time
pgAdmin4 dependency package "python3-psycopg2" should be place in "pgdg-common" repo. Brandon Hsu 07:37
priviliges issues Ankush Chawla 18:04
user with autentication windows Erik Serrano 18:10
Materialized View Estimation in Postgres Sahul Hameed 18:13
Re: priviliges issues John Scalia 18:19
Re: priviliges issues Mohammed Afsar 18:20
Re: priviliges issues David G. Johnston 18:20
Re: priviliges issues David G. Johnston 18:23
Re: user with autentication windows David G. Johnston 18:46
Re: Materialized View Estimation in Postgres Thomas Kellerer 20:52

April 16, 2020

Thread Author Time
Re: pgAdmin4 dependency package "python3-psycopg2" should be place in "pgdg-common" repo. Devrim Gündüz 11:05
catalog views to check on grants Ankush Chawla 12:10
Re: catalog views to check on grants Juan José Santamaría Flecha 13:39

April 17, 2020

Thread Author Time
Re: pgAdmin4 dependency package "python3-psycopg2" should be place in "pgdg-common" repo. Brandon Hsu 02:09
pgAdmin4 connecting to Greenplum Community Edition v6.4 shows error Brandon Hsu 02:37
View pervious versions of row Arnav 12:27
Re: catalog views to check on grants Holger Jakobs 12:39
view the previous version of tables Ankush Chawla 12:43
Re: view the previous version of tables Ashutosh Sharma 12:56

April 18, 2020

Thread Author Time
VACUUM freeze Arnav 18:25
RE: VACUUM freeze Dave Bolt 22:35

April 19, 2020

Thread Author Time
Re: VACUUM freeze Ankush Chawla 07:15
Re: VACUUM freeze Scott Ribe 12:09
Re: VACUUM freeze Olivier Gautherot 13:24
checkpoint process use too much memory jian xu 13:56
Re: VACUUM freeze Keith 18:26

April 20, 2020

Thread Author Time
Re: VACUUM freeze Laurenz Albe 08:55
Re: checkpoint process use too much memory Laurenz Albe 09:06
Re: View pervious versions of row Wim Bertels 09:25
Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Prashant Kulkarni 11:53
RE: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL soumik.bhattacharjee 11:58
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Ron 12:58
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Thomas Kellerer 13:27
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Pepe TD Vo 14:02
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Laurenz Albe 14:39
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL manish yadav 14:56
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Avinash Kumar 14:59
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Laurenz Albe 15:11
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Avinash Kumar 15:26
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Scott Ribe 15:30
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Avinash Kumar 15:38
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Marlene Villanueva 15:45
Re: checkpoint process use too much memory jian xu 17:52
Re: checkpoint process use too much memory Scott Ribe 18:25
Re: checkpoint process use too much memory jian xu 19:13
Re: checkpoint process use too much memory Scott Ribe 19:23
Re: checkpoint process use too much memory MichaelDBA 19:37

April 21, 2020

Thread Author Time
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Peter M. Groen 08:27
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL pinker 10:43
checkpoint starting: time (insert statement hangs Yannick Collette 16:10
Re: checkpoint starting: time (insert statement hangs Laurenz Albe 19:39
Re: checkpoint process use too much memory jian xu 20:07
Newbie needs help with space issue Jesse Josserand 23:40
Re: Newbie needs help with space issue John Scalia 23:49

April 22, 2020

Thread Author Time
Application outage with XX000: could not receive data from client: Connection timed out Pavan Kumar 00:11
Re: Application outage with XX000: could not receive data from client: Connection timed out Jerry Sievers 02:05
Re: Newbie needs help with space issue raf 03:51
Re: Newbie needs help with space issue Priancka Chatz 04:25
Re: Newbie needs help with space issue androxkentaki . 07:23
Re: Newbie needs help with space issue Priancka Chatz 07:52
Composite primary key duplicate records - Issue In PostgreSQL But not in Oracle soumik.bhattacharjee 13:54
Re: Composite primary key duplicate records - Issue In PostgreSQL But not in Oracle David G. Johnston 14:09
Re: Composite primary key duplicate records - Issue In PostgreSQL But not in Oracle Rui DeSousa 14:16
Re: Composite primary key duplicate records - Issue In PostgreSQL But not in Oracle Holger Jakobs 14:18
RE: Composite primary key duplicate records - Issue In PostgreSQL But not in Oracle soumik.bhattacharjee 14:24
need help Ashok kumar Mani 14:44
Re: need help David G. Johnston 14:50
RE: need help Ashok kumar Mani 14:53
Re: checkpoint starting: time (insert statement hangs Yannick Collette 18:09
n00b question re: indexes and constraints Wells Oliver 18:25
Re: n00b question re: indexes and constraints David G. Johnston 18:30
Re: n00b question re: indexes and constraints Wells Oliver 18:39
Re: n00b question re: indexes and constraints David G. Johnston 18:48
Re: n00b question re: indexes and constraints Rui DeSousa 21:25

April 23, 2020

Thread Author Time
Help needed for replication issue Ashok kumar Mani 06:14
Re: Help needed for replication issue Prince Pathria 09:00
pgAdmin4 v4.20 "View/Edit Data --> First 100 rows" on table pop up "column gdp.attrnums does not exist" error when connecting to Greenplum Community v6.7.0 Brandon Hsu 09:14

April 24, 2020

Thread Author Time
RE: Help needed for replication issue Ashok kumar Mani 03:59
Re: Help needed for replication issue Keith 05:03
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Pepe TD Vo 13:28
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Laurenz Albe 13:31
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Avinash Kumar 13:35
Re: Help needed for replication issue soumitra bhandary 13:42
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Laurenz Albe 14:50
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Jonah H. Harris 16:57
Re: Help needed for replication issue Prince Pathria 17:44
Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL Pepe TD Vo 18:11

April 25, 2020

Thread Author Time
Wal keep segment Raj kumar 12:09
Re: Wal keep segment John Scalia 12:14
Startup process in slave 📎 Raj kumar 13:12
Re: Wal keep segment Raj kumar 13:13
Re: Wal keep segment Don Seiler 13:28
Configuring Replication in Windows 2016 using Postgresql 9.x Luis Marin 17:10
Re: Startup process in slave Scott Ribe 21:24
Re: Configuring Replication in Windows 2016 using Postgresql 9.x zurich 21:24

April 26, 2020

Thread Author Time
RE: Help needed for replication issue Ashok kumar Mani 06:22
RE: Help needed for replication issue Ashok kumar Mani 07:00
Re: Help needed for replication issue Olivier Gautherot 07:00
Re: Wal keep segment Raj kumar 12:21
Re: Startup process in slave Raj kumar 12:29
how to cross check the wal log count from primary and standby ? Ashok kumar Mani 14:10
Setting up a database with minimum access rights Bo Victor Thomsen 16:58
Bug #3787 ??? richard coleman 17:08
Re: Setting up a database with minimum access rights Jeff Janes 17:37
Re: Setting up a database with minimum access rights Bo Victor Thomsen 19:36
how do I turn off David Ellis Rogers 19:46

April 27, 2020

Thread Author Time
Re: how do I turn off Johannes Truschnigg 06:10
Req for some help in figuring out table create grants Tharmarajah, Sam 20:22
Partitions and planner J T 23:03

April 28, 2020

Thread Author Time
Re: Partitions and planner Laurenz Albe 05:19
PostgreSQL DB checkpoint error! Ashok kumar Mani 06:13
Re: PostgreSQL DB checkpoint error! David G. Johnston 06:26
RE: PostgreSQL DB checkpoint error! Ashok kumar Mani 06:31
pgbench data loading failure- tablepscace space or pg_wal mount space issue Raj kumar 06:38
Re: PostgreSQL DB checkpoint error! Rui DeSousa 06:41
RE: PostgreSQL DB checkpoint error! Ashok kumar Mani 06:49
Re: PostgreSQL DB checkpoint error! Rui DeSousa 06:50

Browse Archives

Prev | Next