pgsql-general since 2019-05-25 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

May 25, 2019

Thread Author Time
pg_basebackup from 9.4-bdr to 9.4 results in corrupt index Jānis Pūris 16:49
Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index Ron 17:15
Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index Adrian Klaver 17:27
Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index Jānis Pūris 18:42
Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index Jānis Pūris 18:46
Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index Adrian Klaver 21:26
Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index Jānis Pūris 22:31

May 26, 2019

Thread Author Time
Re: Centos : Load Average :OS Process Name : migration/1, migration/2 , migration/n Perumal Raj 20:28

May 27, 2019

Thread Author Time
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Andres Freund 13:49
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Julie Nishimura 17:58

May 28, 2019

Thread Author Time
psql: FATAL: the database system is starting up Tom K 04:59
Re: psql: FATAL: the database system is starting up Adrian Klaver 13:53
Alternate methods for multiple rows input/output to a function. RAJIN RAJ K 14:36
Re: Alternate methods for multiple rows input/output to a function. Adrian Klaver 14:59
Re: Alternate methods for multiple rows input/output to a function. Adrian Klaver 17:26
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Julie Nishimura 18:11
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Julie Nishimura 18:20
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Andreas Kretschmer 18:47
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Adrian Klaver 19:43
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Julie Nishimura 21:03
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Alvaro Herrera 21:15

May 29, 2019

Thread Author Time
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Adrian Klaver 00:16
Re: psql: FATAL: the database system is starting up Tom K 01:59
[No subject] Pawan Sharma 08:03
with and trigger PegoraroF10 11:52
Re: with and trigger Geoff Winkless 12:23
Re: with and trigger Fabrízio de Royes Mello 12:28
Re: with and trigger PegoraroF10 13:10
Re: with and trigger Tom Lane 13:26
Re: Adrian Klaver 14:20
Re: Query reg. postgresql 9.6 migration from ubuntu 16.04 to 18.04 a venkatesh 14:23
Re: psql: FATAL: the database system is starting up Adrian Klaver 14:28
Re: with and trigger Ron 15:05
Re: with and trigger Andreas Kretschmer 15:12
Re: with and trigger Tom Lane 15:21
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Julie Nishimura 16:41
Re: Questions about btree_gin vs btree_gist for low cardinality columns Jeremy Finzel 17:59
Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used: 79569 of 80000 (99%) Adrian Klaver 18:32

May 30, 2019

Thread Author Time
Localization Yonatan Misgan 05:59
Re: terminating walsender process due to replication timeout AYahorau 09:07
Migrating a Patroni cluster from Ubuntu 16.04 to Ubuntu 18.04 Peter J. Holzer 10:38
compiling PL/pgSQL plugin with C++ 📎 Тарасов Георгий Витальевич 15:14
Re: compiling PL/pgSQL plugin with C++ Tom Lane 15:54
Re: Questions about btree_gin vs btree_gist for low cardinality columns Will Hartung 17:11
Re: Localization Alvaro Herrera 18:49
Re: Questions about btree_gin vs btree_gist for low cardinality columns Peter J. Holzer 19:00
Postgresql backup via LVM snapshot? Lu, Dan 19:38
Re: compiling PL/pgSQL plugin with C++ Tom Lane 21:46

May 31, 2019

Thread Author Time
Re: Questions about btree_gin vs btree_gist for low cardinality columns Peter J. Holzer 08:11
Re: Questions about btree_gin vs btree_gist for low cardinality columns Thomas Kellerer 09:10
table is hanging Sonam Sharma 10:58
Re: table is hanging Sonam Sharma 11:03
Re: table is hanging Nicklas Avén 11:08
Re: table is hanging Sonam Sharma 11:15
Re: table is hanging Saurabh Agrawal 12:06
Re: table is hanging Andreas Kretschmer 12:44
json on child table or not PegoraroF10 13:20
Feature request (or at least discussion): enable autovaccum on temp tables Ivan Voras 15:25
Re: Feature request (or at least discussion): enable autovaccum on temp tables Pavel Stehule 15:34
Re: Feature request (or at least discussion): enable autovaccum on temp tables Ivan Voras 15:39
Re: Feature request (or at least discussion): enable autovaccum on temp tables Adam Brusselback 15:40
Re: Feature request (or at least discussion): enable autovaccum on temp tables Ivan Voras 15:42
Re: Feature request (or at least discussion): enable autovaccum on temp tables Andrew Gierth 15:43
Re: Feature request (or at least discussion): enable autovaccum on temp tables Christopher Browne 15:54
Inherit Database - Table Permissions Sathish Kumar 16:17
Re: Feature request (or at least discussion): enable autovaccum on temp tables Ivan Voras 16:20
Re: Feature request (or at least discussion): enable autovaccum on temp tables Ivan Voras 16:25
Re: Inherit Database - Table Permissions Ron 16:26
Re: Feature request (or at least discussion): enable autovaccum on temp tables Christopher Browne 16:33
Re: Feature request (or at least discussion): enable autovaccum on temp tables Michael Lewis 17:00
Re: json on child table or not Michael Lewis 17:08
Re: json on child table or not PegoraroF10 18:21
Re: compiling PL/pgSQL plugin with C++ Tom Lane 21:39

June 1, 2019

Thread Author Time
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 02:52
Re: psql: FATAL: the database system is starting up Tom K 02:53
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 07:44
Re: Questions about btree_gin vs btree_gist for low cardinality columns Gavin Flower 08:24
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 09:02
Re: Questions about btree_gin vs btree_gist for low cardinality columns Peter J. Holzer 13:53
Re: psql: FATAL: the database system is starting up Adrian Klaver 13:55
Re: psql: FATAL: the database system is starting up Tom K 19:32
Re: psql: FATAL: the database system is starting up Tom K 19:42
Re: psql: FATAL: the database system is starting up Adrian Klaver 20:11
Re: psql: FATAL: the database system is starting up Adrian Klaver 20:52
Re: psql: FATAL: the database system is starting up Tom K 21:08
Re: psql: FATAL: the database system is starting up Adrian Klaver 21:24
Re: psql: FATAL: the database system is starting up Tom K 21:30
Re: psql: FATAL: the database system is starting up Tom K 21:31
Re: psql: FATAL: the database system is starting up Adrian Klaver 21:46
Re: psql: FATAL: the database system is starting up Adrian Klaver 21:51
Re: psql: FATAL: the database system is starting up Tom K 22:05
Re: psql: FATAL: the database system is starting up Tom K 22:14
Re: psql: FATAL: the database system is starting up Adrian Klaver 22:36
Re: psql: FATAL: the database system is starting up Adrian Klaver 22:39
Re: psql: FATAL: the database system is starting up Tom K 22:48
Re: psql: FATAL: the database system is starting up Tom K 22:56
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 23:10
Re: psql: FATAL: the database system is starting up Adrian Klaver 23:12
Re: psql: FATAL: the database system is starting up Tom K 23:22
Re: psql: FATAL: the database system is starting up Adrian Klaver 23:30
Re: psql: FATAL: the database system is starting up Adrian Klaver 23:33
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 23:47

June 2, 2019

Thread Author Time
Re: psql: FATAL: the database system is starting up Tom K 00:21
Re: psql: FATAL: the database system is starting up Tom K 00:25
Re: psql: FATAL: the database system is starting up Tom K 00:32
Re: psql: FATAL: the database system is starting up Adrian Klaver 00:36
Re: psql: FATAL: the database system is starting up Tom K 00:50
Re: psql: FATAL: the database system is starting up Adrian Klaver 00:53
Re: psql: FATAL: the database system is starting up Tom K 03:07
Re: Questions about btree_gin vs btree_gist for low cardinality columns Peter J. Holzer 07:37
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 08:03
Re: psql: FATAL: the database system is starting up Adrian Klaver 15:46
Re: Questions about btree_gin vs btree_gist for low cardinality columns Jeff Janes 16:25
Re: psql: FATAL: the database system is starting up Tom K 18:14
Re: psql: FATAL: the database system is starting up Adrian Klaver 20:47
Re: Questions about btree_gin vs btree_gist for low cardinality columns Tom Lane 23:07
PG10 upgrade issue Zahir Lalani 23:10
Re: PG10 upgrade issue Tom Lane 23:18
Re: PG10 upgrade issue Zahir Lalani 23:52

June 3, 2019

Thread Author Time
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 00:24
Re: psql: FATAL: the database system is starting up Tom K 04:48
RE: Questions about btree_gin vs btree_gist for low cardinality columns Steven Winfield 09:28
Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device Daulat Ram 09:55
CREATE DATABASE ... TEMPLATE ... vs checksums Karsten Hilbert 10:03
Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx 10:11
RE: Questions about btree_gin vs btree_gist for low cardinality columns Steven Winfield 10:33
Re: Postgresql backup via LVM snapshot? Bruno Lavoie 14:10
Re: Postgresql backup via LVM snapshot? Fabio Ugo Venchiarutti 15:23
One way replication in PostgreSQL PALAYRET Jacques 16:00
Re: One way replication in PostgreSQL Stephen Frost 16:13
Re: One way replication in PostgreSQL Fabio Pardi 16:18
Re: Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device Thomas Munro 17:06
Requirement PA-DSS 1.1.4 Jan Bilek 22:56
Re: Questions about btree_gin vs btree_gist for low cardinality columns Peter Geoghegan 23:17
Re: One way replication in PostgreSQL Frank Alberto Rodriguez 23:39

June 4, 2019

Thread Author Time
csvlog Behavior when log file missing Lesley Kimmel 02:00
Re: Questions about btree_gin vs btree_gist for low cardinality columns Jeff Janes 02:05
Fwd: SSL Error: Certificate verify fail Richard Webb 02:42
Re: csvlog Behavior when log file missing Laurenz Albe 06:54
Re: One way replication in PostgreSQL PALAYRET Jacques 07:02
Re: One way replication in PostgreSQL Guillaume Lelarge 07:33
Re: One way replication in PostgreSQL Achilleas Mantzios 08:04
psql \copy paul.malm 08:50
Re: psql \copy Pavel Stehule 08:59
Research on ?? operators Matteo Beccati 09:00
Two small questions re/ COPY CSV data into table Matthias Apitz 10:02
Re: Two small questions re/ COPY CSV data into table Andrew Gierth 10:32
Re: Research on ?? operators Andrew Gierth 10:38
Re: Research on ?? operators Steve Atkins 10:49
Re: Research on ?? operators Matteo Beccati 10:55
Re: Research on ?? operators Matteo Beccati 11:01
Re: Research on ?? operators Michael Lewis 12:35
Re: Research on ?? operators Matteo Beccati 12:40
Re: Research on ?? operators Steve Atkins 12:44
Re: Questions about btree_gin vs btree_gist for low cardinality columns Jeremy Finzel 13:37
Re: Two small questions re/ COPY CSV data into table Matthias Apitz 15:03
Re: Two small questions re/ COPY CSV data into table Andrew Gierth 15:41
Long running query - connection and keepalives enabled but query not canceled Tomasz Ostrowski 15:54
Re: Long running query - connection and keepalives enabled but query not canceled Laurenz Albe 16:24
Re: Two small questions re/ COPY CSV data into table Matthias Apitz 16:26
Re: One way replication in PostgreSQL Frank Alberto Rodriguez 16:29
Query very different speeds on seemingly similar data 📎 Rob Northcott 16:54
Re: Two small questions re/ COPY CSV data into table Andrew Gierth 16:56
Re: psql \copy paul.malm 17:18
Re: Two small questions re/ COPY CSV data into table Matthias Apitz 17:20
Re: Two small questions re/ COPY CSV data into table Andrew Gierth 17:51
Re: Two small questions re/ COPY CSV data into table Francisco Olarte 19:12
dump and restore ordered by schema or table name PegoraroF10 20:15
Re: dump and restore ordered by schema or table name Fabrízio de Royes Mello 20:28
postgresql11-devel RPM is missing from "Direct RPM downloads" Dmitry O Litvintsev 21:49
Converting yes or no to one letter strings. Lou 22:29
Re: Converting yes or no to one letter strings. Rich Shepard 23:01
Re: Converting yes or no to one letter strings. Ray O'Donnell 23:03
Re: Converting yes or no to one letter strings. David G. Johnston 23:23
Re: Converting yes or no to one letter strings. David G. Johnston 23:29
Re: Converting yes or no to one letter strings. Rich Shepard 23:44

June 5, 2019

Thread Author Time
Re: Converting yes or no to one letter strings. Adrian Klaver 00:19
Re: Query very different speeds on seemingly similar data David Rowley 00:47
Re: Converting yes or no to one letter strings. Ron 02:27
granting right to create and delete just one database Chris Withers 06:11
Re: postgresql11-devel RPM is missing from "Direct RPM downloads" Jakub Olczyk 07:04
RE: Query very different speeds on seemingly similar data Rob Northcott 08:05
Re: granting right to create and delete just one database Laurenz Albe 08:52
Re: granting right to create and delete just one database Chris Withers 08:56
Re: Long running query - connection and keepalives enabled but query not canceled Tomasz Ostrowski 10:39
pg_repack issue Prakash Ramakrishnan 10:48
Re: Long running query - connection and keepalives enabled but query not canceled Dmitry Vasiliev 11:14
Re: pg_repack issue Peter Eisentraut 11:53
Re: pg_repack issue Prakash Ramakrishnan 11:55
Re: Two small questions re/ COPY CSV data into table Matthias Apitz 12:07
Re: pg_repack issue Sathish Kumar 12:46
Postgresql-11 confusing situtation Domen Šetar 12:46
Re: pg_repack issue Prakash Ramakrishnan 12:48
Re: pg_repack issue Sathish Kumar 13:24
Re: Long running query - connection and keepalives enabled but query not canceled Dmitry Vasiliev 14:07
Re: Postgresql-11 confusing situtation Adrian Klaver 14:14
Re: pg_repack issue Prakash Ramakrishnan 14:16
Re: Converting yes or no to one letter strings. Adrian Klaver 14:20
Re: Postgresql-11 confusing situtation Achilleas Mantzios 14:38
verify checksums / CREATE DATABASE Karsten Hilbert 14:47

Browse Archives

Prev | Next