pgsql-admin since 2017-01-09 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)

Browse Archives

Prev | Next

Jan. 9, 2017

Thread Author Time
Re: Using Views as Tables David L 08:22
Re: Using Views as Tables Simon Riggs 08:28
Re: Issue with pgAdmin4 UI Scott Mead 14:14
Re: Fwd: Can I bother you for some more assistance? David Steele 14:45
Re: Using Views as Tables Kevin Grittner 14:55
Re: Fwd: Can I bother you for some more assistance? David Steele 14:56
Recycle(Delete) Applicationlog(Pgadmin4.log) after hitting certain MB pmandumula 20:45

Jan. 10, 2017

Thread Author Time
Re: Issue with pgAdmin4 UI 📎 Franklyn Edwin 06:38
vacuum toast loop? gleeco 08:53
Re: vacuum toast loop? Tom Lane 13:04
Ora2PG configuration Sankaranarayanan, Srinivasan 13:20
Re: Ora2PG configuration Julien Rouhaud 16:36

Jan. 11, 2017

Thread Author Time
Lock Error ProPAAS DBA 00:17
Re: Lock Error Tom Lane 02:26
Re: Lock Error ProPAAS DBA 04:50
Re: vacuum toast loop? gleeco 19:30
Re: vacuum toast loop? Tom Lane 22:46

Jan. 16, 2017

Thread Author Time
Re: Lock Error Jan Harasym 08:04

Jan. 17, 2017

Thread Author Time
Queries are taking way longer in 9.6 than 9.5 Ravi Tammineni 19:31
Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5 Melvin Davidson 19:36
Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5 Adrian Klaver 19:42
Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5 Ravi Tammineni 20:10
Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5 Ravi Tammineni 20:12
Re: Queries are taking way longer in 9.6 than 9.5 Melvin Davidson 20:21
Re: Queries are taking way longer in 9.6 than 9.5 Chris Mair 20:38
Re: Queries are taking way longer in 9.6 than 9.5 Tomas Vondra 20:47
Re: Queries are taking way longer in 9.6 than 9.5 Ravi Tammineni 20:49
Re: Queries are taking way longer in 9.6 than 9.5 Tomas Vondra 22:21

Jan. 18, 2017

Thread Author Time
Re: Queries are taking way longer in 9.6 than 9.5 Chris Mair 00:22
postgresql : could not serialize access due to read/write dependencies among transactions Neslisah Demirci 04:54
Re: postgresql : could not serialize access due to read/write dependencies among transactions John R Pierce 05:10
Re: Ora2PG configuration Sankaranarayanan, Srinivasan 10:24
Pg_upgradecluster failed Matthieu Lejeune 15:23
Re: postgresql : could not serialize access due to read/write dependencies among transactions Kevin Grittner 17:10
Re: Queries are taking way longer in 9.6 than 9.5 Ravi Tammineni 19:04
Optimization inner join Clailson 19:56
PostgreSQL 9.3 ERROR Ferrell, Denise D CTR NSWCDD, H11 20:01
Re: Queries are taking way longer in 9.6 than 9.5 Merlin Moncure 20:06
Re: Queries are taking way longer in 9.6 than 9.5 Melvin Davidson 20:12
Re: PostgreSQL 9.3 ERROR Stephen Frost 20:16

Jan. 19, 2017

Thread Author Time
Re: Queries are taking way longer in 9.6 than 9.5 Merlin Moncure 04:58
Re: Queries are taking way longer in 9.6 than 9.5 Adrian Klaver 05:10
Re: Queries are taking way longer in 9.6 than 9.5 Merlin Moncure 05:21
Re: Queries are taking way longer in 9.6 than 9.5 Tomas Vondra 07:28
Moving from 9.5 to 9.6 PAWAN SHARMA 11:58
Re: Issue related to audit trigger after upgrade to Postgresql9.6 Vikash Pandey 13:24
Re: Pg_upgradecluster failed Christoph Berg 13:24
Re: Queries are taking way longer in 9.6 than 9.5 Merlin Moncure 14:23
Re: Moving from 9.5 to 9.6 Adrian Klaver 14:51

Jan. 20, 2017

Thread Author Time
behavior of \dt and schemas John Scalia 14:53
Re: behavior of \dt and schemas Stephen Frost 15:11
Re: behavior of \dt and schemas David G. Johnston 15:11
Re: behavior of \dt and schemas Tom Lane 15:37
Re: behavior of \dt and schemas John Scalia 16:09
Re: behavior of \dt and schemas John Scalia 16:18

Jan. 23, 2017

Thread Author Time
Req. for some help with temp tables Tharmarajah, Sam 16:19

Jan. 24, 2017

Thread Author Time
Strange times in WAL files in archive directory (9.3) Achilleas Mantzios 09:12
Re: Strange times in WAL files in archive directory (9.3) Achilleas Mantzios 11:10
Re: Strange times in WAL files in archive directory (9.3) Tom Lane 13:29
Re: Strange times in WAL files in archive directory (9.3) David Steele 13:42
Re: Strange times in WAL files in archive directory (9.3) Achilleas Mantzios 13:42
Re: Strange times in WAL files in archive directory (9.3) Tom Lane 14:14
Re: Strange times in WAL files in archive directory (9.3) Achilleas Mantzios 14:47
Re: Strange times in WAL files in archive directory (9.3) Stephen Frost 14:55
Re: Strange times in WAL files in archive directory (9.3) Achilleas Mantzios 15:32
Re: Strange times in WAL files in archive directory (9.3) Stephen Frost 15:55
Re: Strange times in WAL files in archive directory (9.3) Achilleas Mantzios 16:04

Jan. 25, 2017

Thread Author Time
Re: Strange times in WAL files in archive directory (9.3) Achilleas Mantzios 07:50
pg_hba.conf and hostssl all all 999.999.999.0/24 cert and use of letsencrypt.org software Poul Kristensen 13:45
Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Maris Jansons 14:53
Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Jorge Torralba 16:50
Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Maris Jansons 21:30
Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Jorge Torralba 21:52

Jan. 26, 2017

Thread Author Time
Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Maris Jansons 09:44
Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Tom Lane 16:03

Jan. 27, 2017

Thread Author Time
Re: Help: unfixable/undead error - missing chunk number 0 for toast value 413511 in pg_toast_25477 Maris Jansons 08:44
Failed to set up event for socket: error code 10038 Ertan Küçükoğlu 10:23
Re: Failed to set up event for socket: error code 10038 Thomas Kellerer 11:02
Re: Failed to set up event for socket: error code 10038 Ertan Küçükoğlu 12:51
Configuring LDAP in the pg_hba.conf file John Scalia 17:19
Re: Configuring LDAP in the pg_hba.conf file Scott Mead 17:33
Re: Configuring LDAP in the pg_hba.conf file John Scalia 17:47

Jan. 30, 2017

Thread Author Time
Re: pg_hba.conf and hostssl all all 999.999.999.0/24 cert and use of letsencrypt.org software Gunnar "Nick" Bluth 08:20
Re: pg_hba.conf and hostssl all all 999.999.999.0/24 cert and use of letsencrypt.org software Magnus Hagander 08:32
Tablespace symlinks Slavcho Trnkovski 14:24
Re: Tablespace symlinks Achilleas Mantzios 14:57

Jan. 31, 2017

Thread Author Time
Re: Tablespace symlinks Slavcho Trnkovski 08:54
Re: Tablespace symlinks Achilleas Mantzios 13:09
New message pg_dumpall role skiped ??? Jorge Torralba 17:20
Re: New message pg_dumpall role skiped ??? Stephen Frost 17:28
Re: New message pg_dumpall role skiped ??? Jorge Torralba 17:43
building 9.6.1 with a different value for krb-srvnam John Scalia 19:19
Re: building 9.6.1 with a different value for krb-srvnam Tom Lane 21:18
Re: building 9.6.1 with a different value for krb-srvnam John Scalia 22:06
Re: building 9.6.1 with a different value for krb-srvnam Tom Lane 22:15

Feb. 1, 2017

Thread Author Time
Big sized materialized views break replication Κοκμάδης Δημήτριος 10:39
Re: Big sized materialized views break replication Achilleas Mantzios 11:02
Re: Big sized materialized views break replication 📎 Samed YILDIRIM 11:08
Re: Big sized materialized views break replication Achilleas Mantzios 11:49
monitoring queries in pg_stat_activity daniel aristizabal franco 17:51
Re: monitoring queries in pg_stat_activity Keith 19:05
Re: monitoring queries in pg_stat_activity David G. Johnston 19:25

Feb. 2, 2017

Thread Author Time
How to stop Streaming Replication in slave for backup Suresh Rajagopal 18:07
Re: How to stop Streaming Replication in slave for backup Scott Whitney 18:23
Re: How to stop Streaming Replication in slave for backup John Scalia 18:27
Re: How to stop Streaming Replication in slave for backup Suresh Rajagopal 18:58
Re: How to stop Streaming Replication in slave for backup Suresh Rajagopal 18:59
Re: How to stop Streaming Replication in slave for backup Scott Whitney 19:03

Feb. 8, 2017

Thread Author Time
Recovery from Transaction wraparound failure Ganesh Kannan 06:48
Re: Recovery from Transaction wraparound failure Ganesh Kannan 14:37
Re: Recovery from Transaction wraparound failure Ganesh Kannan 15:28
Re: Recovery from Transaction wraparound failure Tom Lane 16:13
Why pgpool TPS is lowest versus postgresql direct connections? Lazaro Garcia 16:27
Re: Recovery from Transaction wraparound failure Ganesh Kannan 20:56

Feb. 9, 2017

Thread Author Time
Change ownership of a database Kevin Duffy 02:33
Re: Change ownership of a database Steve Crawford 04:17
Why pgpool TPS is lowest versus postgresql direct connections? Lazaro Garcia 09:59
Very long index build time John Scalia 13:07
Re: Change ownership of a database Kevin Duffy 17:10
Re: Change ownership of a database Jorge Torralba 17:13
Re: Very long index build time Tom Lane 17:46

Feb. 10, 2017

Thread Author Time
Re: postgresql : could not serialize access due to read/write dependencies among transactions Gunnar "Nick" Bluth 10:23
Re: [pgpool-general: 5318] Why pgpool TPS is lowest versus postgresql direct connections? 📎 Lazaro Garcia 15:14
Re: [pgpool-general: 5318] Why pgpool TPS is lowest versus postgresql direct connections? David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco) 15:57

Feb. 11, 2017

Thread Author Time
wal error 'already been removed' on promotion gleeco 02:16
Re: Why pgpool TPS is lowest versus postgresql direct connections? Jehan-Guillaume de Rorthais 11:58

Feb. 12, 2017

Thread Author Time
Re: Change ownership of a database Kevin Duffy 04:57
PostgreSQL on Docker Dhandapani Shanmugam 06:06
Re: PostgreSQL on Docker Johannes Truschnigg 15:08

Feb. 13, 2017

Thread Author Time
repmgr error with automated failover Lazaro Garcia 14:32
Cannot drop role Steven Hirsch 18:43
Re: Cannot drop role Alvaro Herrera 18:48

Feb. 14, 2017

Thread Author Time
Re: repmgr error with automated failover Ian Barwick 01:55
(auto) vacuum mysterious walpino 10:15
Re: repmgr error with automated failover Lazaro Garcia 10:39
Re: PostgreSQL on Docker Feike Steenbergen 13:54
Re: Req. for some help with temp tables Feike Steenbergen 14:28
Re: (auto) vacuum mysterious Alvaro Herrera 14:52

Feb. 15, 2017

Thread Author Time
Questions regarding PL/Perl Thorsten Schöning 10:11

Feb. 16, 2017

Thread Author Time
pg_dump: [archiver (db)] query failed: ERROR: could not access file "$libdir/postgis-2.1": No such file or directory John Kelly 02:45
Re: pg_dump: [archiver (db)] query failed: ERROR: could not access file "$libdir/postgis-2.1": No such file or directory Lucas Possamai 02:53

Feb. 17, 2017

Thread Author Time
Re: PostgreSQL on Docker Dhandapani Shanmugam 07:54
Can I create multiple schema for one user Sunil Vasanta 10:15
Re: Can I create multiple schema for one user Albe Laurenz 10:48
Re: Can I create multiple schema for one user stevenchang1213 15:52
WAL archive space planning? Ray Stell 18:30

Feb. 19, 2017

Thread Author Time
Re: WAL archive space planning? Keith 07:34

Feb. 21, 2017

Thread Author Time
Re: WAL archive space planning? Steven Chang 05:09
Re: Big sized materialized views break replication Κοκμάδης Δημήτριος 07:22
Re: Big sized materialized views break replication Lazaro Garcia 09:06
Re: Best system for a data warehouse application Lazaro Garcia 13:02
PGSQL as database server container ghiureai 16:17
Re: WAL archive space planning? Ray Stell 17:22
Re: WAL archive space planning? Keith 17:26
Best system for a data warehouse application John Scalia 17:38
Re: Best system for a data warehouse application Yuri Paes Leme 17:46
Re: Best system for a data warehouse application John Scalia 17:58
Re: WAL archive space planning? Ray Stell 19:33
Re: WAL archive space planning? Keith 19:45

Feb. 22, 2017

Thread Author Time
Re: Best system for a data warehouse application Steven Chang 02:00
Re: Best system for a data warehouse application Fernando Hevia 02:15
Re: Best system for a data warehouse application Jaime Soler 14:23
Re: PGSQL as database server container Jaime Soler 14:33
Re: Issue related to audit trigger after upgrade to Postgresql9.6 Jaime Soler 16:45
Database vs Schema Separation Rob Emery 18:45
postgresql admin Gone, Sajan 19:45
Re: Question on installing pgadmin4 1.2 - htmlmin conflict with django. Williams, Alex 20:08
Re: Re: Question on installing pgadmin4 1.2 - htmlmin conflict with django. Devrim Gündüz 20:44
Re: Re: Question on installing pgadmin4 1.2 - htmlmin conflict with django. Williams, Alex 21:05

Feb. 23, 2017

Thread Author Time
Re: Database vs Schema Separation Achilleas Mantzios 08:09
Re: postgresql admin Stéphane KANSCHINE 09:04
Re: Re: Question on installing pgadmin4 1.2 - htmlmin conflict with django. Devrim Gündüz 09:22
upgrade path from PG 8.3 to PG 9.5 ghiureai 17:39
Re: upgrade path from PG 8.3 to PG 9.5 Gilberto Castillo 17:57
Re: upgrade path from PG 8.3 to PG 9.5 Keith 17:57
Re: postgresql admin Gone, Sajan 18:15
Failover but master is running Lazaro Garcia 21:08
Re: [pgpool-general: 5345] Failover but master is running Tatsuo Ishii 22:14

Feb. 24, 2017

Thread Author Time
Re: [pgpool-general: 5345] Failover but master is running Lazaro Garcia 14:12
Re: [pgpool-general: 5345] Failover but master is running Lazaro Garcia 17:15
Transaction log size debugging Ted Hahn 20:34

Feb. 27, 2017

Thread Author Time
cpu hight sy% usage [email protected] 15:13

Feb. 28, 2017

Thread Author Time
Re: [pgpool-general: 5345] Failover but master is running Tatsuo Ishii 02:36
Re: cpu hight sy% usage Tom Lane 04:37
replication error Anton Gorlov 14:54
Re: replication error Albe Laurenz 15:23

March 1, 2017

Thread Author Time
Dealing with a cursor in libpq c program John Scalia 15:32

March 3, 2017

Thread Author Time
Re: Dealing with a cursor in libpq c program Albe Laurenz 09:43

March 7, 2017

Thread Author Time
pg_basebackup recovery failure Ray Stell 20:31
Re: pg_basebackup recovery failure Magnus Hagander 20:36
Re: pg_basebackup recovery failure Jorge Torralba 22:11

March 8, 2017

Thread Author Time
Re: pg_basebackup recovery failure Ray Stell 17:43
pg_backrest no longer backing up Aldo Sarmiento 19:48
Re: pg_backrest no longer backing up David Steele 22:18
Re: pg_backrest no longer backing up Aldo Sarmiento 22:53

March 9, 2017

Thread Author Time
cfg pg_stat_statements in PG 9.5 error ghiureai 16:29
Re: cfg pg_stat_statements in PG 9.5 error Tom Lane 17:11
auditing in rds or triggers that write to pg_log Mike Broers 17:37
Re: cfg pg_stat_statements in PG 9.5 error ghiureai 17:49
Re: auditing in rds or triggers that write to pg_log Cachique 17:49

Browse Archives

Prev | Next