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

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
Re: auditing in rds or triggers that write to pg_log Mike Broers 17:51
Re: cfg pg_stat_statements in PG 9.5 error Tom Lane 18:08
Re: cfg pg_stat_statements in PG 9.5 error ghiureai 18:12
Re: auditing in rds or triggers that write to pg_log Cachique 18:16

March 10, 2017

Thread Author Time
Re: cfg pg_stat_statements in PG 9.5 error Stéphane KANSCHINE 04:36
Oracle to Postgres conversion suggestions? Mark Kirkwood 08:42
Re: Oracle to Postgres conversion suggestions? Stéphane KANSCHINE 08:54
Re: Oracle to Postgres conversion suggestions? [email protected] 12:41
Too many WAL file created Gabriel Fernández Martínez 13:35
The same role for multiple databases Poul Kristensen 14:16
Re: Too many WAL file created Albe Laurenz 14:32
Re: The same role for multiple databases John Scalia 15:17

March 13, 2017

Thread Author Time
Re: The same role for multiple databases Poul Kristensen 09:30
Re: The same role for multiple databases John Scalia 11:59
Re: Too many WAL file created Gabriel Fernández Martínez 17:37
Re: pg_backrest no longer backing up David Steele 20:34

March 14, 2017

Thread Author Time
Re: Oracle to Postgres conversion suggestions? Mark Kirkwood 02:35
Re: WAL archive space planning? Steven Chang 03:53
Re: WAL archive space planning? Scott Whitney 04:17
Re: WAL archive space planning? Steven Chang 05:24
Re: WAL archive space planning? Ray Stell 13:09
Re: WAL archive space planning? Ray Stell 17:16

March 15, 2017

Thread Author Time
Postgres - Replication jasoninmel 04:59
Re: Too many WAL file created Albe Laurenz 09:44
Re: Postgres - Replication 📎 Samed YILDIRIM 11:21
Convert existing syslog logs to csvlog Mario De Frutos 20:51
How to Identify and Fail Transaction When Slave Node Down Anushka Weerakkodyge 23:51

March 16, 2017

Thread Author Time
Re: How to Identify and Fail Transaction When Slave Node Down Anushka Weerakkodyge 09:06
Re: How to Identify and Fail Transaction When Slave Node Down vinny 09:51
Re: How to Identify and Fail Transaction When Slave Node Down Anushka Weerakkodyge 11:49
Re: How to Identify and Fail Transaction When Slave Node Down vinny 12:48
Re: How to Identify and Fail Transaction When Slave Node Down Lazaro Garcia 13:08

March 17, 2017

Thread Author Time
Re: Postgres - Replication jasoninmel 03:30
Re: Postgres - Replication jasoninmel 03:34
Re: Postgres - Replication Rosser Schwarz 03:51
QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions Osahon Oduware 14:50
Re: WAL archive space planning? Jerry Sievers 21:39

March 18, 2017

Thread Author Time
Re: Postgres - Replication bricklen 16:41
Re: Postgres - Replication Alvaro Aguayo Garcia-Rada 16:54

March 20, 2017

Thread Author Time
Re: QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions Albe Laurenz 12:55

March 21, 2017

Thread Author Time
Re: Postgres - Replication jasoninmel 03:36
Re: Postgres - Replication Om Prakash Jaiswal 08:07
Re: Postgres - Replication [email protected] 11:07
Re: Postgres - Replication Poul Kristensen 13:44
Re: upgrade path from PG 8.3 to PG 9.5 Thorsten Schöning 16:25
Re: upgrade path from PG 8.3 to PG 9.5 Stephen Frost 16:40
Re: upgrade path from PG 8.3 to PG 9.5 David G. Johnston 16:47
Re: upgrade path from PG 8.3 to PG 9.5 Stephen Frost 16:54
Re: upgrade path from PG 8.3 to PG 9.5 Scott Marlowe 19:00

Browse Archives

Prev | Next