pgsql-admin since 2017-10-23 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

Oct. 23, 2017

Thread Author Time
Re: Processing very large TEXT columns (300MB+) using C/libpq Geoff Winkless 09:36
Re: Processing very large TEXT columns (300MB+) using C/libpq Geoff Winkless 10:17
Re: multiple sql results to shell Randy Strauss 22:14

Oct. 24, 2017

Thread Author Time
Re: multiple sql results to shell Geoff Winkless 09:58
Re: Processing very large TEXT columns (300MB+) using C/libpq Bear Giles 16:39

Oct. 25, 2017

Thread Author Time
Database Error Ferrell, Denise D CTR NSWCDD, H11 12:30
Migrate from Oracle 12g to PostgreSQL 9.3 Gust, Thorsten 13:19
Re: Database Error Don Seiler 14:42
Re: [Non-DoD Source] Re: Database Error Don Seiler 16:03
Re: Migrate from Oracle 12g to PostgreSQL 9.3 📎 bend 16:05
Bad recovery: no pg_xlog/RECOVERYXLOG Marcin Koziej 16:50
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Marcin Koziej 17:25
Re: Bad recovery: no pg_xlog/RECOVERYXLOG 📎 Samed YILDIRIM 17:30
Re: Bad recovery: no pg_xlog/RECOVERYXLOG 📎 Marcin Koziej 18:20
Re: Migrate from Oracle 12g to PostgreSQL 9.3 Julien Rouhaud 18:40

Oct. 26, 2017

Thread Author Time
Re: Migrate from Oracle 12g to PostgreSQL 9.3 Ian Barwick 02:18
Re: Migrate from Oracle 12g to PostgreSQL 9.3 Gust, Thorsten 07:36
Re: Migrate from Oracle 12g to PostgreSQL 9.3 Gust, Thorsten 08:21
Re: Migrate from Oracle 12g to PostgreSQL 9.3 Julien Rouhaud 09:34

Oct. 27, 2017

Thread Author Time
SQL history. Syed Asim Shah 10:08
Re: [Non-DoD Source] Re: Database Error Ferrell, Denise D CTR NSWCDD, H11 13:35
Re: SQL history. David G. Johnston 13:58
Re: SQL history. Vianello, Daniel A 14:59

Oct. 30, 2017

Thread Author Time
Re: SQL history. Syed Asim Shah 07:33
Re: [Non-DoD Source] Re: Database Error Ferrell, Denise D CTR NSWCDD, H11 12:16
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Stephen Frost 15:47
Postgresql Upgrade from 9.3 to 9.4 failing rammohan ganapavarapu 18:16
Re: [Non-DoD Source] Re: Database Error Ferrell, Denise D CTR NSWCDD, H11 18:38
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Mark Kirkwood 20:30

Oct. 31, 2017

Thread Author Time
Re: Postgresql Upgrade from 9.3 to 9.4 failing Bruce Momjian 02:32
Re: Postgresql Upgrade from 9.3 to 9.4 failing rammohan ganapavarapu 03:35
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Stephen Frost 11:47
permission denied for schema public -need help Kumar, Ram Murti 14:52
Re: Postgresql Upgrade from 9.3 to 9.4 failing rammohan ganapavarapu 18:10
Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 19:37
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Tom Lane 19:59
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 21:27
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Tom Lane 21:56
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 22:08
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Tom Lane 22:12

Nov. 1, 2017

Thread Author Time
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 02:37
ream and processor required Ashok Kumar Tiwari 05:29
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Mark Kirkwood 08:37
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Stephen Frost 12:28
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Mark Kirkwood 21:20
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Stephen Frost 22:18

Nov. 2, 2017

Thread Author Time
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 01:49
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 01:56
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Tom Lane 02:23
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Mark Kirkwood 03:35
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Mark Kirkwood 04:23
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Stephen Frost 11:11
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Stephen Frost 11:40
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 14:44
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 14:52
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Tom Lane 14:57
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Stephen Frost 15:06
Fwd: postgresql9.4 aws - no pg_upgrade bala jayaram 21:03
Re: Missing Chunk Error when doing a VACUUM FULL operation - DB Corruption? Arjun Ranade 21:17
Re: postgresql9.4 aws - no pg_upgrade Vasilis Ventirozos 21:27

Nov. 3, 2017

Thread Author Time
Re: postgresql9.4 aws - no pg_upgrade bala jayaram 02:41
Re: postgresql9.4 aws - no pg_upgrade Shreeyansh Dba 03:55
Re: postgresql9.4 aws - no pg_upgrade Keith 04:42
Re: postgresql9.4 aws - no pg_upgrade Shreeyansh Dba 05:56
Re: postgresql9.4 aws - no pg_upgrade Vasilis Ventirozos 08:35
Help install powa Neto pr 11:52
Re: Help install powa Julien Rouhaud 12:05
Re: postgresql9.4 aws - no pg_upgrade Payal Singh 15:01
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Mark Kirkwood 22:00

Nov. 6, 2017

Thread Author Time
Partitions Günce Kaya 07:19
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Stephen Frost 13:37
Standby wal issue chris kim 19:34
Re: Standby wal issue Joshua D. Drake 21:22
Re: Standby wal issue chris kim 22:39

Nov. 7, 2017

Thread Author Time
ERROR: invalid byte sequence for encoding "UTF8": 0x00 PropAAS DBA 01:10
Re: Bad recovery: no pg_xlog/RECOVERYXLOG Mark Kirkwood 02:49
Re: Standby wal issue Laurenz Albe 07:30
Re: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Laurenz Albe 07:41
Running Windows binaries from non-English folder Yuri Martsinovsky 19:30

Nov. 8, 2017

Thread Author Time
How to measure replication lag in logical replication setup. rammohan ganapavarapu 02:52
Re: Running Windows binaries from non-English folder Thomas Kellerer 06:56
Problems rebuilding slave using pg_basebackup Douglas Reed 10:09
Re: Problems rebuilding slave using pg_basebackup Payal Singh 11:57
Re: Problems rebuilding slave using pg_basebackup Laurenz Albe 12:28
Re: Problems rebuilding slave using pg_basebackup Douglas Reed 13:00
High replication lag - Stream Replication Marcelo Kruger 13:38
Problems rebuilding slave using pg_basebackup Douglas Reed 14:06
Re: High replication lag - Stream Replication Shreeyansh Dba 14:09
Re: How to measure replication lag in logical replication setup. Igor Neyman 15:39
Re: High replication lag - Stream Replication Marcelo Kruger 16:04
Re: How to measure replication lag in logical replication setup. rammohan ganapavarapu 16:14
Re: Can master and slave on different PG versions? rammohan ganapavarapu 16:17
Error accessing catalog table pg_proc Cory Nemelka 18:07
Re: Running Windows binaries from non-English folder George Neuner 18:09
Re: Running Windows binaries from non-English folder Yuri Martsinovsky 19:02
Re: Error accessing catalog table pg_proc Tom Lane 20:27

Nov. 9, 2017

Thread Author Time
Re: High replication lag - Stream Replication Shreeyansh Dba 04:43
pg_basebackup permission denied error Günce Kaya 06:16
Re: pg_basebackup permission denied error Shreeyansh Dba 06:27
Re: pg_basebackup permission denied error Günce Kaya 06:48
Re: pg_basebackup permission denied error Shreeyansh Dba 06:49
Re: Can master and slave on different PG versions? Shreeyansh Dba 07:45
Re: pg_basebackup permission denied error Günce Kaya 08:07
PostgreSQL WAL file issue Gokhan Demir 08:40
Re: pg_basebackup permission denied error Gokhan Demir 08:55
Re: pg_basebackup permission denied error Shreeyansh Dba 09:04
Re: pg_basebackup permission denied error Günce Kaya 11:59
Re: High replication lag - Stream Replication Marcelo Kruger 12:06
Re: PostgreSQL WAL file issue Tom Lane 14:59
Re: Can master and slave on different PG versions? rammohan ganapavarapu 16:22
Partitions rammohan ganapavarapu 23:28
Re: Partitions John Scalia 23:41

Nov. 10, 2017

Thread Author Time
Re: Partitions Stephen Frost 00:18
Re: Partitions rammohan ganapavarapu 01:37
Re: Partitions Stephen Frost 01:50
Re: Partitions rammohan ganapavarapu 01:59
Re: Partitions Scott Mead 02:03
Re: PostgreSQL WAL file issue Gokhan Demir 15:01
pgaudit/Password Redaction Dale,Bob 20:02

Nov. 11, 2017

Thread Author Time
Upgrading postgres to 10 from 9.5 using pg_upgradecluster Debraj Manna 02:32
Re: Upgrading postgres to 10 from 9.5 using pg_upgradecluster Johannes Truschnigg 11:26
How to get detailed query execution statistics for each algebra operator or primitive Tiago Kepe 13:49
Re: How to get detailed query execution statistics for each algebra operator or primitive Keith 15:22
Postgres 10 installation failing on Ubuntu 14 📎 Debraj Manna 17:19
Re: Postgres 10 installation failing on Ubuntu 14 Christoph Berg 19:54

Nov. 13, 2017

Thread Author Time
Re: FQDN for replication connection in pg_hba.conf Shreeyansh Dba 10:58
Re: High replication lag - Stream Replication Shreeyansh Dba 12:59
yum repo URL and pgdg rpm point at testing Aleksander Kamenik 18:41

Nov. 14, 2017

Thread Author Time
Missing libpq.so in postgresql v10 Long Nguyen 07:37
Re: Missing libpq.so in postgresql v10 Ian Barwick 08:29
Re: Missing libpq.so in postgresql v10 Shreeyansh Dba 10:07
Upgrade 9.5 cluster with non default data directory with checksum Debraj Manna 14:28
Re: Upgrade 9.5 cluster with non default data directory with checksum Keith 14:59
Re: Upgrade 9.5 cluster with non default data directory with checksum 📎 Debraj Manna 15:43
Re: Upgrade 9.5 cluster with non default data directory with checksum 📎 Debraj Manna 17:44
PG10 - Out of shared memory / invalid memory alloc request size Arjun Ranade 19:44
Re: PG10 - Out of shared memory / invalid memory alloc request size Alvaro Aguayo Garcia-Rada 19:53
recreating point-in-time recovery when tables are in non-default tablespace Mark Steben 19:54
Re: PG10 - Out of shared memory / invalid memory alloc request size Arjun Ranade 20:00
Re: PG10 - Out of shared memory / invalid memory alloc request size Alvaro Aguayo Garcia-Rada 20:05
Re: PG10 - Out of shared memory / invalid memory alloc request size Arjun Ranade 20:07
Re: PG10 - Out of shared memory / invalid memory alloc request size Tom Lane 20:15
Re: PG10 - Out of shared memory / invalid memory alloc request size Mark Kirkwood 23:24

Nov. 15, 2017

Thread Author Time
Re: PG10 - Out of shared memory / invalid memory alloc request size Mark Kirkwood 01:34
Vacuum not removing dead tuples Rui DeSousa 05:37
Re: Upgrade 9.5 cluster with non default data directory with checksum Debraj Manna 06:54
Re: recreating point-in-time recovery when tables are in non-default tablespace Laurenz Albe 09:27
Re: recreating point-in-time recovery when tables are in non-default tablespace Johannes Truschnigg 09:32
Re: Vacuum not removing dead tuples Laurenz Albe 10:06
Re: Upgrade 9.5 cluster with non default data directory with checksum Joan Luc Labòrda 11:50
Re: Upgrade 9.5 cluster with non default data directory with checksum Debraj Manna 11:56
Re: recreating point-in-time recovery when tables are in non-default tablespace Mark Steben 12:30
Issue with pg_ident after password change on v10.0 sighup 13:22
Re: Vacuum not removing dead tuples Rui DeSousa 16:44
Performance difference between servers kpi6288 17:06
Re: Performance difference between servers Scott Whitney 17:11
Re: Performance difference between servers kpi6288 17:17
Re: Upgrade 9.5 cluster with non default data directory with checksum Debraj Manna 17:18
Re: Performance difference between servers kpi6288 17:43
Re: Performance difference between servers Scott Whitney 17:59
Re: Performance difference between servers Evan Rempel 18:21
Re: Performance difference between servers Scott Whitney 18:25
Re: Performance difference between servers Klaus P. Pieper 19:21
foreign tables query performance using postgres_fdw armand pirvu 20:59
Re: Can master and slave on different PG versions? rammohan ganapavarapu 21:23
Re: Performance difference between servers Rui DeSousa 23:42

Nov. 16, 2017

Thread Author Time
Re: foreign tables query performance using postgres_fdw Laurenz Albe 07:13
Upgrading postgres to 10 running with patroni Debraj Manna 07:29
Re: Upgrading postgres to 10 running with patroni 📎 Debraj Manna 07:32
Re: Upgrading postgres to 10 running with patroni Magnus Hagander 07:40
Re: Upgrading postgres to 10 running with patroni Debraj Manna 08:34
[SOLVED] AW: Performance difference between servers kpi6288 10:59
Re: foreign tables query performance using postgres_fdw armand pirvu 13:26
Re: yum repo URL and pgdg rpm point at testing Devrim Gündüz 14:42
Re: yum repo URL and pgdg rpm point at testing Aleksander Kamenik 14:58
Re: Can master and slave on different PG versions? rammohan ganapavarapu 16:58
Re: Upgrading postgres to 10 running with patroni Debraj Manna 19:25

Nov. 17, 2017

Thread Author Time
Re: Upgrading postgres to 10 running with patroni Debraj Manna 07:46
Reaching out pgbouncer people, does [email protected] work Achilleas Mantzios 11:49
Reaching out pgbouncer people, does [email protected] work Achilleas Mantzios 12:45
Re: [ADMIN] Reaching out pgbouncer people, does [email protected] work Tom Lane 14:57
Re: [ADMIN] Reaching out pgbouncer people, does [email protected] work Magnus Hagander 15:01
FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 15:07
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Tom Lane 15:25
Re: [ADMIN] Reaching out pgbouncer people, does [email protected] work Jonathan S. Katz 15:29
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 15:29
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Tom Lane 15:36
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 15:43
Re: Can master and slave on different PG versions? rammohan ganapavarapu 15:43
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 15:46
Replication with a third-party plug-in Craig James 15:53
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Tom Lane 15:57
Re: Replication with a third-party plug-in bricklen 16:02
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 16:05
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 16:31
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 16:40
Re: [ADMIN] Reaching out pgbouncer people, does [email protected] work Joshua D. Drake 17:13
Re: FATAL: invalid value for parameter "TimeZone" after upgrade from 9.2 to 9.6 Don Seiler 17:35
Restart PostgreSQL service with SSL and private key pass phrase sri bhav 21:19

Nov. 18, 2017

Thread Author Time
POWA-tool doesn't show queries executed Neto pr 02:11

Browse Archives

Prev | Next