Mailing lists [pgsql-admin]

1 May 2015

• 06:36   Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? Andre_Mikulec
• 08:07   How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? David G. Johnston
• 17:14   How to exclude blobs (large objects) from being loaded by pg_restore? Alanoly Andrews
• 18:16   pg_dump and pg_restore with multiple streams does Not seem to improve overall times Susan K. McClure
• 18:22   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Scott Ribe
• 18:29   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Scott Whitney
• 18:49   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Scott Marlowe
• 23:48   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Keith

2 May 2015

• 01:40   migrating to 9.2 created blank dbs Marc Fromm
• 04:21   Re: migrating to 9.2 created blank dbs Keith Fiske
• 10:11   Re: migrating to 9.2 created blank dbs Raghavendra
• 13:42   Re: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? Albe Laurenz
• 16:39   Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore? Vincent Veyron
• 17:27   Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore? Alanoly Andrews
• 18:03   Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore? Melvin Davidson
• 20:57   Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore? Daniel Verite

4 May 2015

• 15:14   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Jan Lentfer
• 15:17   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Jan Lentfer
• 17:59   Re: migrating to 9.2 created blank dbs Marc Fromm
• 18:06   Re: migrating to 9.2 created blank dbs Gilberto Castillo
• 18:19   Re: migrating to 9.2 created blank dbs Keith
• 19:07   Re: migrating to 9.2 created blank dbs Tom Lane
• 19:19   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Mel Llaguno
• 19:24   Re: migrating to 9.2 created blank dbs Marc Fromm
• 19:40   Re: migrating to 9.2 created blank dbs Jeff Frost
• 19:41   Re: migrating to 9.2 created blank dbs Marc Fromm
• 19:42   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Jan Lentfer
• 20:12   Re: migrating to 9.2 created blank dbs Jeff Frost
• 20:14   Re: migrating to 9.2 created blank dbs Marc Fromm
• 20:22   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Igor Neyman
• 20:28   Re: migrating to 9.2 created blank dbs Jeff Frost
• 20:59   Re: migrating to 9.2 created blank dbs Marc Fromm
• 21:03   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Jan Lentfer
• 21:26   Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times Igor Neyman

5 May 2015

• 08:46   Re: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? Harshad Adalkonda
• 12:59   display to_timestamp in quotas or convert to char ? czezz
• 14:26   display to_timestamp in quotas or convert to char czezz
• 14:46   Re: display to_timestamp in quotas or convert to char ? Albe Laurenz
• 16:21   Re: display to_timestamp in quotas or convert to char ? Scott Ribe
• 16:24   RE: display to_timestamp in quotas or convert to char ? czezz
• 16:36   Re: display to_timestamp in quotas or convert to char ? Igor Neyman
• 16:56   Re: display to_timestamp in quotas or convert to char ? Scott Ribe
• 17:21   Re: display to_timestamp in quotas or convert to char ? czezz
• 17:47   Re: display to_timestamp in quotas or convert to char ? Scott Ribe
• 18:09   Re: display to_timestamp in quotas or convert to char ? czezz
• 22:03   Re: display to_timestamp in quotas or convert to char ? Scott Ribe

6 May 2015

• 17:53   Import csv file error with double newline phuongnh2
• 18:15   Re: Import csv file error with double newline Payal Singh
• 22:47   pg_dump: preserving oids in system tables? Natalie Wenz
• 23:03   Re: pg_dump: preserving oids in system tables? David G. Johnston

7 May 2015

• 16:33   instalação do postgresql93-contrib.x86_64 Mauricio Tavares
• 16:36   Best setting for wal_sync_method Ravi Krishna
• 17:03   Re: instalação dopostgresql93-contrib.x86_64 Devrim Gündüz
• 17:11   Re: [ADMIN] instalação do postgresql93-contrib.x86_64 Matheus de Oliveira
• 17:53   where table privileges are stored Markova, Nina
• 18:07   Re: where table privileges are stored Stephen Frost
• 18:11   Re: where table privileges are stored Markova, Nina
• 18:53   Re: where table privileges are stored Matheus de Oliveira
• 19:19   Re: Best setting for wal_sync_method Ravi Krishna
• 19:27   connect postgresql to a different cluster Zoltan Szecsei
• 19:39   Re: connect postgresql to a different cluster David G. Johnston
• 20:03   Re: connect postgresql to a different cluster Gilberto Castillo
• 20:33   Re: connect postgresql to a different cluster Zoltan Szecsei

8 May 2015

• 09:38   Schema Consolidation in PostgreSQL Wei Shan
• 10:50   Re: Schema Consolidation in PostgreSQL Albe Laurenz
• 11:08   Re: Best setting for wal_sync_method Albe Laurenz
• 16:43   Re: Import csv file error with double newline phuongnh2
• 16:43   Issue import (COPY) data by between miss lines phuongnh2
• 16:43   Re: Issue import (COPY) data by between miss lines phuongnh2
• 16:44   Re: Issue import (COPY) data by between miss lines phuongnh2
• 18:31   Re: [HACKERS] INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 Geoff Winkless
• 18:34   Re: [HACKERS] INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 Geoff Winkless
• 18:38   Re: [HACKERS] INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 John Scalia
• 19:16   Re: Schema Consolidation in PostgreSQL David G. Johnston

10 May 2015

• 12:32   Re: Schema Consolidation in PostgreSQL Wei Shan
• 13:01   Re: Schema Consolidation in PostgreSQL Albe Laurenz
• 18:23   Re: Schema Consolidation in PostgreSQL Jorge Torralba

11 May 2015

• 10:14   Re: Schema Consolidation in PostgreSQL Albe Laurenz
• 17:39   Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? Andre_Mikulec
• 21:58   How to VACUUM_FULL / clean / truncate of pg_largeobject without (much) downtime? Muthusamy, Sivaraman

12 May 2015

• 00:11   Re: Issue import (COPY) data by between miss lines Guillaume Lelarge
• 04:02   SSL and MD5 passwords Nathan Aherne
• 10:55   Re: SSL and MD5 passwords Albe Laurenz
• 20:34   Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) Robert Burgholzer
• 20:44   Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) David G. Johnston
• 20:53   Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) Scott Ribe
• 21:08   Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) Robert Burgholzer
• 21:31   Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) Scott Ribe

13 May 2015

• 02:50   Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) Robert Burgholzer
• 02:58   Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) Scott Ribe
• 11:01   Re: Timestamp Shifts when calling to_timestamp(extract (epoch from timestamp)) Albe Laurenz
• 19:21   Fwd: Two questions I would like insight on Mark Steben

14 May 2015

• 18:03   WAL and O_DIRECT Ravi Krishna
• 18:11   Re: WAL and O_DIRECT Tom Lane
• 18:32   Re: WAL and O_DIRECT Ravi Krishna
• 18:53   Re: WAL and O_DIRECT Bruce Momjian
• 18:55   Re: WAL and O_DIRECT Tom Lane
• 19:07   Re: WAL and O_DIRECT Ravi Krishna
• 19:25   Re: WAL and O_DIRECT Tom Lane
• 19:26   Re: WAL and O_DIRECT Bruce Momjian
• 19:29   Re: WAL and O_DIRECT Ravi Krishna

15 May 2015

• 05:35   Re: Missing timeline history file after execution of pg_upgrade Bruce Momjian

16 May 2015

• 07:41   Re: Missing timeline history file after execution of pg_upgrade Bruce Momjian

18 May 2015

• 12:17   PostgreSQL pg_dump output reading from named pipe on Windows is giving duplicate dump content girish R G peetle
• 16:07   Performances issues with SSD volume ? Thomas SIMON
• 16:08   Performances issues with SSD volume ? Thomas SIMON
• 16:13   Re: Performances issues with SSD volume ? Matheus de Oliveira
• 16:36   Re: Performances issues with SSD volume ? Thomas SIMON
• 16:51   Re: Performances issues with SSD volume ? Koray Eyidoğan
• 16:52   Re: Performances issues with SSD volume ? Wei Shan
• 17:17   Re: Performances issues with SSD volume ? Thomas SIMON
• 17:21   Re: Performances issues with SSD volume ? Thomas SIMON
• 17:29   Re: Performances issues with SSD volume ? Glyn Astill
• 23:16   Insert con salto de linea Juan J Rosales Rodriguez
• 23:54   Re: Insert con salto de linea Juan J Rosales Rodriguez

19 May 2015

• 00:01   Re: Insert con salto de linea Kevin Grittner
• 13:30   Create Index CONCURRENTLY Hangs Indefinitely. Wei Shan
• 13:42   Re: Create Index CONCURRENTLY Hangs Indefinitely. Adarsh Sharma
• 13:46   Re: Create Index CONCURRENTLY Hangs Indefinitely. Jan Lentfer
• 14:43   Deleting old WAL-files Gustav Karlsson
• 14:51   Re: Deleting old WAL-files Magnus Hagander
• 14:52   Re: Deleting old WAL-files Jan Lentfer
• 15:09   Re: Deleting old WAL-files Albe Laurenz
• 15:30   Re: Deleting old WAL-files Gilberto Castillo
• 15:55   Re: Create Index CONCURRENTLY Hangs Indefinitely. Matheus de Oliveira
• 17:26   Performances issues with SSD volume ? Graeme B. Bell

20 May 2015

• 05:48   Re: Create Index CONCURRENTLY Hangs Indefinitely. Wei Shan
• 08:29   Re: Deleting old WAL-files Gustav Karlsson
• 18:41   Re: Performances issues with SSD volume ? Thomas SIMON
• 19:51   Re: Performances issues with SSD volume ? Glyn Astill
• 20:03   Re: Performances issues with SSD volume ? Glyn Astill

21 May 2015

• 10:04   File removed while backup is running Mario Aguado
• 10:16   Re: File removed while backup is running Jan Lentfer
• 10:58   Re: File removed while backup is running Mario Aguado
• 14:21   raid writethrough mode (WT), ssds and your DB. (was Performances issues with SSD volume ?) Graeme B. Bell
• 15:12   Re: Performances issues with SSD volume ? Thomas SIMON
• 15:28   Re: Performances issues with SSD volume ? Thomas SIMON
• 15:46   Re: Performances issues with SSD volume ? Glyn Astill
• 15:57   Re: Performances issues with SSD volume ? Glyn Astill
• 16:52   Re: Performances issues with SSD volume ? Thomas SIMON
• 17:32   Re: Performances issues with SSD volume ? Glyn Astill
• 17:47   Re: Performances issues with SSD volume ? Thomas SIMON
• 17:54   Read performance on Large Table Kido Kouassi
• 18:02   Re: Read performance on Large Table Gilberto Castillo
• 18:02   Re: Read performance on Large Table Ravi Krishna
• 18:07   Re: Read performance on Large Table Scott Marlowe
• 18:09   Re: Read performance on Large Table Scott Ribe
• 18:18   Re: Read performance on Large Table Scott Ribe
• 18:22   Re: Read performance on Large Table Scott Marlowe
• 18:41   Re: Read performance on Large Table Scott Ribe
• 18:46   Re: Read performance on Large Table Keith
• 19:01   Re: Read performance on Large Table Scott Ribe
• 19:26   Re: Read performance on Large Table Keith
• 19:35   Re: Read performance on Large Table Scott Ribe
• 19:56   Re: Performances issues with SSD volume ? Thomas SIMON
• 22:57   Postgres Synchronous replication Ravi Krishna
• 23:02   Re: Postgres Synchronous replication Payal Singh
• 23:10   Re: Postgres Synchronous replication Ravi Krishna
• 23:12   Re: Postgres Synchronous replication John Scalia
• 23:14   Re: Postgres Synchronous replication Keith
• 23:20   Re: Postgres Synchronous replication Gilberto Castillo
• 23:30   Re: Postgres Synchronous replication Scott Ribe
• 23:41   Re: Postgres Synchronous replication Keith
• 23:45   Re: Postgres Synchronous replication Keith

22 May 2015

• 00:00   Re: Postgres Synchronous replication Ravi Krishna
• 00:03   Re: Postgres Synchronous replication Scott Ribe
• 09:50   Dropped database still shows in the database list. girish R G peetle
• 11:05   Re: Dropped database still shows in the database list. Albe Laurenz
• 11:06   Re: Dropped database still shows in the database list. David G. Johnston
• 12:38   Re: Performances issues with SSD volume ? Glyn Astill
• 13:35   Re: Dropped database still shows in the database list. girish R G peetle
• 15:01   Re: Performances issues with SSD volume ? Graeme B. Bell
• 15:29   Major filesystem corruption bug in stable linux kernel... Graeme B. Bell
• 15:32   Re: Performances issues with SSD volume ? Graeme B. Bell
• 17:27   Re: Postgres Synchronous replication Felipe Santos
• 17:38   Re: Postgres Synchronous replication Ravi Krishna
• 17:51   Re: Performances issues with SSD volume ? Glyn Astill
• 18:13   Re: Performances issues with SSD volume ? Thomas SIMON
• 18:29   Re: Performances issues with SSD volume ? Thomas SIMON
• 18:54   Resync postgres database after master slave replication shailesh
• 18:55   PSQL danny
• 19:21   Re: Performances issues with SSD volume ? Glyn Astill
• 19:48   Re: PSQL Jan Lentfer
• 19:53   Re: Resync postgres database after master slave replication Jan Lentfer
• 20:00   Re: PSQL David G. Johnston

25 May 2015

• 13:50   postgresql-9.4-BDR replication issue Mikhail Levandovskiy
• 14:38   Re: postgresql-9.4-BDR replication issue Mikhail Levandovskiy
• 15:16   Re: postgresql-9.4-BDR replication issue Shreeyansh Dba
• 15:43   Minor upgrades of postgre in aws rds? Rafał Radecki
• 16:05   Re: postgresql-9.4-BDR replication issue Mikhail Levandovskiy
• 16:09   Re: Minor upgrades of postgre in aws rds? Bruce Momjian

26 May 2015

• 05:01   PostgreSQL 9.1 "database system was interrupted; last known up at" Boylan, Ross
• 05:15   Re: PostgreSQL 9.1 "database system was interrupted; last known up at" Tom Lane
• 07:42   Re: PostgreSQL 9.1 "database system was interrupted; last known up at" Boylan, Ross
• 12:12   Re: PostgreSQL 9.1 "database system was interrupted; last known up at" Albe Laurenz
• 17:44   Re: Performances issues with SSD volume ? Thomas SIMON
• 18:28   Re: Performances issues with SSD volume ? Glyn Astill
• 18:42   Re: Performances issues with SSD volume ? Glyn Astill
• 21:52   How to expand existing table-space Ravi Krishna
• 22:03   Re: How to expand existing table-space Igor Neyman
• 22:16   Re: How to expand existing table-space Ravi Krishna
• 22:19   Re: How to expand existing table-space Tom Lane
• 22:54   Re: How to expand existing table-space Ravi Krishna
• 22:59   Re: PSQL danny
• 23:12   Re: How to expand existing table-space Scott Ribe
• 23:33   Re: How to expand existing table-space Ravi Krishna
• 23:54   Re: How to expand existing table-space Scott Ribe

27 May 2015

• 00:10   refreshing a database with pg_dump and psql Rossi, Maria
• 00:28   Re: refreshing a database with pg_dump and psql Jan Lentfer
• 00:28   Re: refreshing a database with pg_dump and psql Rossi, Maria
• 00:37   Re: refreshing a database with pg_dump and psql David G. Johnston
• 00:41   Re: refreshing a database with pg_dump and psql Jan Lentfer
• 02:35   Re: refreshing a database with pg_dump and psql David G. Johnston
• 03:44   Re: refreshing a database with pg_dump and psql Wei Shan
• 03:44   Re: refreshing a database with pg_dump and psql Rossi, Maria
• 08:02   autovacuum was not vacuuming Charles Sprickman
• 11:31   monitoring TPS and IOPS Pascal Laporte (plaporte)
• 11:43   Re: monitoring TPS and IOPS Albe Laurenz
• 12:02   Re: monitoring TPS and IOPS Pascal Laporte (plaporte)
• 12:06   Re: monitoring TPS and IOPS Guillaume Lelarge
• 12:07   Re: monitoring TPS and IOPS Kieren Scott
• 12:15   Re: monitoring TPS and IOPS Albe Laurenz
• 14:19   PostgreSQL Dump based backup using pipe girish R G peetle
• 14:32   Re: PostgreSQL Dump based backup using pipe Jan Lentfer
• 17:24   Re: PostgreSQL Dump based backup using pipe Tom Lane
• 19:25   Re: PostgreSQL Dump based backup using pipe girish R G peetle
• 19:50   Re: PostgreSQL Dump based backup using pipe Tom Lane
• 20:05   monitoring TPS and IOPS Pascal Laporte (plaporte)
• 20:54   Re: autovacuum was not vacuuming Charles Sprickman
• 21:00   Re: autovacuum was not vacuuming Alvaro Herrera

28 May 2015

• 02:30   Re: raid writethrough mode (WT), ssds and your DB. (was Performances issues with SSD volume ?) Bruce Momjian
• 12:11   Re: PostgreSQL Dump based backup using pipe girish R G peetle
• 16:38   Re: raid writethrough mode (WT), ssds and your DB. (was Performances issues with SSD volume ?) Graeme B. Bell
• 17:32   Re: raid writethrough mode (WT), ssds and your DB. (was Performances issues with SSD volume ?) Bruce Momjian
• 18:27   Re: PostgreSQL Dump based backup using pipe Tom Lane
• 20:21   pg_dump not dumping some schemas Guo, Yun
• 20:58   Re: PostgreSQL Dump based backup using pipe girish R G peetle
• 21:06   Re: PostgreSQL Dump based backup using pipe Scott Ribe

29 May 2015

• 11:07   Re: pg_dump not dumping some schemas Albe Laurenz
• 16:23   Re: pg_dump not dumping some schemas Guo, Yun

30 May 2015

• 07:44   Warning when connecting from PSQL Command danny
• 07:52   Re: autovacuum was not vacuuming Charles Sprickman
• 11:21   Re: Warning when connecting from PSQL Command Guillaume Lelarge
• 21:35   Re: Warning when connecting from PSQL Command Harshad Adalkonda

31 May 2015

• 00:14   Re: PostgreSQL 9.1 "database system was interrupted; last known up at" Boylan, Ross