pgsql-general since 2019-09-19 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)

Browse Archives

Prev | Next

Sept. 19, 2019

Thread Author Time
Re: PostgreSQL License Ron 00:55
Re: pgbackrest - question about restoring cluster to a new cluster on same server Jerry Sievers 01:15
Re: PostgreSQL License Ken Tanzer 01:26
Re: PostgreSQL License Rob Sargent 01:27
Re: pgbackrest - question about restoring cluster to a new cluster on same server David Steele 01:31
Re: PostgreSQL License Ron 01:35
Re: pgbackrest - question about restoring cluster to a new cluster on same server Ron 01:40
Re: pgbackrest - question about restoring cluster to a new cluster on same server David Steele 01:58
Re: pgbackrest - question about restoring cluster to a new cluster on same server Ron 02:06
Re: pgbackrest - question about restoring cluster to a new cluster on same server Jerry Sievers 02:18
Re: pgbackrest - question about restoring cluster to a new cluster on same server David Steele 02:30
Re: PostgreSQL License Ken Tanzer 04:43
Automatically parsing in-line composite types Mitar 04:51
Re: PostgreSQL License Ron 05:04
Re: Backup PostgreSQL from RDS straight to S3 Steven Lembark 06:03
PGPASSWORD in crypted form, for example BlowFish or SHA-256 Matthias Apitz 10:30
How to safely remove a corrupted cluster? Marco Ippolito 11:02
n_live_tup count increase after vacuum Jason Ralph 12:04
Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256 rob stone 12:31
Re: PostgreSQL License Steve Litt 12:48
Re: How to safely remove a corrupted cluster? Marco Ippolito 13:17
Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256 Matthias Apitz 13:23
Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256 Tom Lane 14:09
Re: n_live_tup count increase after vacuum Tom Lane 14:14
Re: pgbackrest - question about restoring cluster to a new cluster on same server Stephen Frost 14:17
Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256 Adrian Klaver 14:19
Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256 domenico febbo 14:27
Re: pgbackrest - question about restoring cluster to a new cluster on same server Ron 15:02
Re: pgbackrest - question about restoring cluster to a new cluster on same server Stephen Frost 15:05
Re: PostgreSQL License Steve Atkins 17:32
is it safe to drop 25 tb schema with cascade option? Julie Nishimura 19:06
Re: is it safe to drop 25 tb schema with cascade option? Adrian Klaver 19:38
Re: is it safe to drop 25 tb schema with cascade option? Julie Nishimura 21:24
Re: is it safe to drop 25 tb schema with cascade option? Adrian Klaver 21:31
Re: is it safe to drop 25 tb schema with cascade option? Adrian Klaver 21:34
Re: is it safe to drop 25 tb schema with cascade option? Tom Lane 21:42
Re: is it safe to drop 25 tb schema with cascade option? Adrian Klaver 21:49
Re: FW: Re: FW: Re: Shouldn;t this trigger be called? Michael Lewis 21:54
Re: is it safe to drop 25 tb schema with cascade option? Tom Lane 21:55
Re: is it safe to drop 25 tb schema with cascade option? Ron 22:37

Sept. 20, 2019

Thread Author Time
Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256 rob stone 01:45
Re: problems importing from csv Michael Lewis 04:01
Re: FW: Re: FW: Re: Shouldn;t this trigger be called? stan 10:30
Re: FW: Re: FW: Re: Shouldn;t this trigger be called? Morris de Oryx 10:52
Re: FW: Re: FW: Re: Shouldn;t this trigger be called? stan 11:02
Re: FW: Re: FW: Re: Shouldn;t this trigger be called? stan 11:08
Web users as database users? David Gallagher 11:50
Re: Web users as database users? Tim Clarke 12:15
Re: Web users as database users? Achilleas Mantzios 12:27
Re: FW: Re: FW: Re: Shouldn;t this trigger be called? Morris de Oryx 12:46
Re: Web users as database users? Rob Sargent 13:01
Re: Web users as database users? Tom Lane 14:18
pg_auto_failover Bhardwaj, SONAM- SONAM R 16:09
Fwd: FW: pg_auto_failover Sonam Sharma 16:11
citext, actually probably using extensions stan 18:13
pgwatch2 monitoring dashboards Bikram MAJUMDAR 18:39
Re: citext, actually probably using extensions Tom Lane 19:12

Sept. 21, 2019

Thread Author Time
Re: citext, actually probably using extensions Rob Sargent 04:59
Re: citext, actually probably using extensions Morris de Oryx 06:01
Use of ?get diagnostics'? Thiemo Kellner 07:57
Re: Use of ?get diagnostics'? Andrew Gierth 08:21

Sept. 22, 2019

Thread Author Time
Extend inner join to fetch not yet connected rows also Arup Rakshit 11:21
Re: Extend inner join to fetch not yet connected rows also Jan Kohnert 12:08
Re: Extend inner join to fetch not yet connected rows also Arup Rakshit 12:12
Re: Extend inner join to fetch not yet connected rows also Arup Rakshit 12:48
Re: Extend inner join to fetch not yet connected rows also Jan Kohnert 13:25
Re: Extend inner join to fetch not yet connected rows also Arup Rakshit 13:30
How to represent a bi-directional list in db? Pankaj Jangid 14:25
Re: How to represent a bi-directional list in db? Francisco Olarte 15:39
Re: Extend inner join to fetch not yet connected rows also Adrian Klaver 16:18
Re: Extend inner join to fetch not yet connected rows also John W Higgins 17:09
Re: Extend inner join to fetch not yet connected rows also Jan Kohnert 17:45
Re: Use of ?get diagnostics'? Thiemo Kellner 18:33
Re: When does Postgres use binary I/O? Tom Lane 18:53
Help: Postgres Replication issues with pacemaker Shital A 19:16
Re: Use of ?get diagnostics'? Adrian Klaver 19:24
Re: Extend inner join to fetch not yet connected rows also Michael Lewis 20:11
Re: When does Postgres use binary I/O? Paul A Jungwirth 21:34
Re: When does Postgres use binary I/O? Tom Lane 21:55

Sept. 23, 2019

Thread Author Time
Re: How to represent a bi-directional list in db? Pankaj Jangid 02:07
Re: Help: Postgres Replication issues with pacemaker Shital A 06:04
Re: pgbouncer with ldap Achilleas Mantzios 06:24
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Corey Taylor 07:07
pg_receivexlog or archive_command Vikas Sharma 08:25
How to get timezone offset in timestamp with time zone AT TIME ZONE output. Paul McGarry 08:32
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. Andrew Gierth 08:44
Re: How to represent a bi-directional list in db? Francisco Olarte 08:54
Re: pg_receivexlog or archive_command Andreas Kretschmer 08:55
unable to drop index because it does not exists Luca Ferrari 11:39
Re: pg_receivexlog or archive_command Luca Ferrari 11:44
Re: pg_receivexlog or archive_command Andreas Kretschmer 11:56
Re: unable to drop index because it does not exists Ron 12:23
Re: unable to drop index because it does not exists Luca Ferrari 13:25
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Tom Lane 13:57
Re: How to represent a bi-directional list in db? Pankaj Jangid 14:07
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Adrian Klaver 14:22
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. Adrian Klaver 14:36
Autovacuum lock conflict Christophe Escobar 15:09
Re: Autovacuum lock conflict Adrian Klaver 17:21
Re: Pg_auto_failover Sonam Sharma 17:38
Re: Pg_auto_failover Adrian Klaver 17:41
Re: unable to drop index because it does not exists Michael Lewis 17:49
Re: Autovacuum lock conflict Laurenz Albe 18:16
Re: pg_receivexlog or archive_command Peter Eisentraut 18:31
Error during analyze after upgrade from 10.10 -> 11.4 Ben Snaidero 18:40
can't install pg 12 beta on centos 6 Kevin Brannen 19:04
Re: Error during analyze after upgrade from 10.10 -> 11.4 Tom Lane 19:06
RE: citext, actually probably using extensions Kevin Brannen 19:11
Re: can't install pg 12 beta on centos 6 Adrian Klaver 19:37
Re: Autovacuum lock conflict Michael Lewis 19:53
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Corey Taylor 20:58
RE: can't install pg 12 beta on centos 6 Kevin Brannen 21:00
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Corey Taylor 21:16
Re: can't install pg 12 beta on centos 6 Adrian Klaver 21:17
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Adrian Klaver 21:31
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Corey Taylor 21:34
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Adrian Klaver 21:50
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Corey Taylor 22:43
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Adrian Klaver 22:51
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Corey Taylor 22:56

Sept. 24, 2019

Thread Author Time
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Adrian Klaver 00:23
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Corey Taylor 00:28
Re: postgres 9.6: insert into select finishes only in pgadmin not psql Adrian Klaver 00:58
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. Andrew Gierth 02:40
Re: Autovacuum lock conflict Laurenz Albe 05:06
Re: How to represent a bi-directional list in db? Francisco Olarte 07:29
Monitor Postgres database status on Docker Daulat Ram 09:17
RE: Monitor Postgres database status on Docker Fan Liu 09:31
Re: How to represent a bi-directional list in db? Pankaj Jangid 09:37
RE: Monitor Postgres database status on Docker Daulat Ram 10:05
pg_terminate_backend not working bhargav kamineni 11:14
Operator is not unique PegoraroF10 13:35
Re: Operator is not unique Fabrízio de Royes Mello 13:49
Re: Operator is not unique PegoraroF10 13:51
Re: Operator is not unique Tom Lane 13:57
Re: Operator is not unique Fabrízio de Royes Mello 14:01
Re: Operator is not unique PegoraroF10 14:18
Re: Operator is not unique Adrian Klaver 14:36
updating sequence value for column 'serial' Matthias Apitz 14:47
Re: updating sequence value for column 'serial' Adrian Klaver 15:01
Pg_auto_failover Sonam Sharma 15:41
Fwd: Pg_auto_failover Sonam Sharma 16:22
Re: Pg_auto_failover Rob Sargent 16:40
Re: Pg_auto_failover Rob Sargent 16:41
Re: pg_terminate_backend not working bhargav kamineni 17:38
Re: Pg_auto_failover Sonam Sharma 17:38
Re: Pg_auto_failover Rob Sargent 17:45
Re: Pg_auto_failover Sonam Sharma 17:58
Re: pg_terminate_backend not working Jerry Sievers 18:35
Re: Pg_auto_failover bricklen 18:45
Re: pg_terminate_backend not working bhargav kamineni 19:28
RE: can't install pg 12 beta on centos 6 Kevin Brannen 19:42
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. Adrian Klaver 19:44

Sept. 25, 2019

Thread Author Time
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. Paul McGarry 00:12
Mapping view columns to their source columns Matt Andrews 00:39
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. Andrew Gierth 02:46
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. rob stone 02:56
Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output. Andrew Gierth 03:01
Re: Mapping view columns to their source columns Tom Lane 04:54
Re: Mapping view columns to their source columns Matt Andrews 05:26
Re: updating sequence value for column 'serial' Matthias Apitz 05:40
managing primary key conflicts while restoring data to table with existing data Krishnakant Mane 07:15
Receivgin error while altering the table column datatype Raghavendra Rao J S V 09:41
pgq is one of the most underrated pg related stuff Миша Тюрин 10:18
Re: managing primary key conflicts while restoring data to table with existing data Rob Sargent 11:02
Re: managing primary key conflicts while restoring data to table with existing data Krishnakant Mane 11:46
Re: Operator is not unique PegoraroF10 13:38
Re: managing primary key conflicts while restoring data to table with existing data Adrian Klaver 14:20
Upgrading old server Ekaterina Amez 14:21
Re: managing primary key conflicts while restoring data to table with existing data Krishnakant Mane 14:24
Re: Upgrading old server Christoph Berg 14:29
Re: Mapping view columns to their source columns Tom Lane 14:39
Re: updating sequence value for column 'serial' Adrian Klaver 14:42
Re: managing primary key conflicts while restoring data to table with existing data Rob Sargent 15:04
Re: Receivgin error while altering the table column datatype David G. Johnston 15:36
Re: Upgrading old server Ron 15:37
Re: Pg_auto_failover Sonam Sharma 15:55
Re: Upgrading old server Tom Lane 16:00
Re: managing primary key conflicts while restoring data to table with existing data Michael Lewis 17:44
Re: Pg_auto_failover Paul Jungwirth 18:09
Re: Upgrading old server Adrian Klaver 18:21
Re: managing primary key conflicts while restoring data to table with existing data Adrian Klaver 18:33
could not accept SSL connection: sslv3 alert bad certificate Marco Ippolito 19:34
Re: Operator is not unique Adrian Klaver 19:50
Re: Operator is not unique PegoraroF10 20:14
Arrays and ANY problem David Salisbury 20:25
Re: Arrays and ANY problem Michael Lewis 20:48
Re: Arrays and ANY problem Alban Hertroys 20:50
Re: Arrays and ANY problem Alban Hertroys 20:54
Re: Arrays and ANY problem David Salisbury 22:07
Re: Arrays and ANY problem David G. Johnston 22:27
Re: Arrays and ANY problem Tom Lane 22:38
lc_numeric and negative-prefix Andreas Joseph Krogh 22:49
Re: lc_numeric and negative-prefix Tom Lane 22:53
Re: lc_numeric and negative-prefix Andreas Joseph Krogh 23:00
Re: could not accept SSL connection: sslv3 alert bad certificate Adrian Klaver 23:56

Sept. 26, 2019

Thread Author Time
Re: could not accept SSL connection: sslv3 alert bad certificate Adrian Klaver 00:07
Re: updating sequence value for column 'serial' Matthias Apitz 05:12
Re: Use of ?get diagnostics'? Thiemo Kellner 05:44
Re: Upgrading old server Ekaterina Amez 05:51

Browse Archives

Prev | Next