Mailing lists [pgsql-admin]

1 November 2018

• 01:00   Fwd: ALTER PUBLICATION Lalith Tenneti
• 13:20   change bigint column to int Mariel Cherkassky
• 14:07   Re: change bigint column to int Shreeyansh Dba
• 14:12   Re: change bigint column to int Mariel Cherkassky
• 14:54   Re: change bigint column to int Evan Bauer
• 15:54   Re: change bigint column to int Mariel Cherkassky
• 16:52   Re: change bigint column to int Evan Bauer
• 17:31   Re: change bigint column to int Mariel Cherkassky

2 November 2018

• 07:27   maintenance_work_mem is it per instance or per database?? pavan95
• 07:43   Re: maintenance_work_mem is it per instance or per database?? Keith
• 08:00   Re: maintenance_work_mem is it per instance or per database?? pavan95
• 09:39   Relation between parameters in postgresql.conf file!! pavan95
• 10:05   Re: maintenance_work_mem is it per instance or per database?? Shreeyansh Dba
• 12:13   Re: Relation between parameters in postgresql.conf file!! Shreeyansh Dba
• 17:56   Re: Relation between parameters in postgresql.conf file!! Rui DeSousa
• 18:56    Pierre Ochsenbein
• 19:05   Re: Fabio Pardi
• 19:23   new postgresql.org community account Pepe TD Vo
• 23:31   Re:  Rui DeSousa
• 23:57   postgresql95 package dependencies? Ron

3 November 2018

• 10:25   Re: Shreeyansh Dba
• 12:00   Re: Can I add a column in catalog table as a superuser Peter Eisentraut
• 19:45   Re:  Rui DeSousa
• 22:06   Re: postgresql95 package dependencies? Florian Weimer
• 22:58   Re: postgresql95 package dependencies? Ron

4 November 2018

• 13:14   size of table + toasted tables + indexes != pg_total_relation_size Mariel Cherkassky
• 15:12   Re: size of table + toasted tables + indexes != pg_total_relation_size Andrew Gierth
• 18:09   Re: size of table + toasted tables + indexes != pg_total_relation_size Mariel Cherkassky
• 19:47   Re: size of table + toasted tables + indexes != pg_total_relation_size Andrew Gierth
• 22:49   Re: size of table + toasted tables + indexes !=pg_total_relation_size Rui DeSousa

5 November 2018

• 14:24   PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdowncheckpoint Achilleas Mantzios
• 15:12   Re: How to revoke "Create Privilege" from a readonly user inpostgres? pavan95
• 15:32   Re: How to revoke "Create Privilege" from a readonly user inpostgres? Achilleas Mantzios
• 16:02   Re: How to revoke "Create Privilege" from a readonly user in postgres? Shreeyansh Dba
• 19:14   Re: How to revoke "Create Privilege" from a readonly user inpostgres? Rui DeSousa
• 19:25   Re: Pierre Ochsenbein
• 19:48   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint Rui DeSousa
• 19:59   Re:  Rui DeSousa

6 November 2018

• 07:41   Re: hot standby cascading replication Nikhil Shetty
• 10:28   Re: hot standby cascading replication Shreeyansh Dba
• 11:37   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint Achilleas Mantzios
• 15:41   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint Laurenz Albe
• 17:53   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint Achilleas Mantzios
• 17:58   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Tom Lane
• 20:13   Another streaming replication question Mark Steben

7 November 2018

• 00:08   Re: Another streaming replication question Johannes Truschnigg
• 00:09   Re: Another streaming replication question Rui DeSousa
• 08:12   Re: How to revoke "Create Privilege" from a readonly user inpostgres? pavan95
• 08:12   Recovery data base!! Elson Vaz
• 08:52   Re: How to revoke "Create Privilege" from a readonly user inpostgres? pavan95
• 08:53   Re: Recovery data base!! Alex Balashov
• 08:55   Re: Recovery data base!! Ron
• 09:14   Re: How to revoke "Create Privilege" from a readonly user inpostgres? Rui DeSousa
• 10:08   Re: How to revoke "Create Privilege" from a readonly user inpostgres? pavan95
• 13:33   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint Achilleas Mantzios
• 15:08   Re: How to revoke "Create Privilege" from a readonly user inpostgres? Rui DeSousa
• 17:08   Re: Another streaming replication question Mark Steben
• 17:11   Re: Another streaming replication question Mark Steben
• 17:12   execute a procedure from another procudure? Pepe TD Vo
• 17:48   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Tom Lane
• 18:10   query can't merge into table of the other schema Pepe TD Vo
• 21:34   for loop Pepe TD Vo
• 21:46   RE: for loop Igor Neyman
• 22:31   RE: for loop Igor Neyman

8 November 2018

• 01:22   Re: query can't merge into table of the other schema Ron
• 01:36   Re: query can't merge into table of the other schema Tom Lane
• 01:52   Re: query can't merge into table of the other schema Pepe TD Vo
• 11:59   Re: execute a procedure from another procudure? Peter Eisentraut
• 12:16   Re: query can't merge into table of the other schema Guillaume Lelarge
• 23:13   Re: execute a procedure from another procudure? Pepe TD Vo

9 November 2018

• 05:54   %rowtype Pepe TD Vo
• 10:26   Re: %rowtype Laurenz Albe
• 16:12   Re: %rowtype Pepe TD Vo
• 19:40   Re: %rowtype Laurenz Albe

10 November 2018

• 13:08   Modules but not extensions Ron
• 18:25   How to downgrade a cluster from 9.5 to 9.3 Michael Lupo

11 November 2018

• 23:09   Re: Modules but not extensions Peter Eisentraut
• 23:12   Re: How to downgrade a cluster from 9.5 to 9.3 Peter Eisentraut

12 November 2018

• 13:41   PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 17:00   Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint Achilleas Mantzios
• 18:48   Re: query can't merge into table of the other schema Pepe TD Vo
• 19:30   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa
• 19:31   Re: query can't merge into table of the other schema David G. Johnston
• 21:42   Re: query can't merge into table of the other schema Pepe TD Vo

13 November 2018

• 06:28   hot_standby_feedback parameter doesn't work Andrey Zhidenkov
• 07:19   Re: How to downgrade a cluster from 9.5 to 9.3 Nikhil Shetty
• 07:47   Re: hot_standby_feedback parameter doesn't work Rui DeSousa
• 08:07   Re: hot_standby_feedback parameter doesn't work Andres Freund
• 10:03   Re: hot_standby_feedback parameter doesn't work Andrey Zhidenkov
• 10:52   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 12:18   Re: hot_standby_feedback parameter doesn't work Andrey Zhidenkov
• 13:04   Re: hot_standby_feedback parameter doesn't work Andrew Gierth
• 13:10   Ora2pg Not Getting Installed- Please Provide Inputs 
• 13:19   Ora2pg Not Getting Installed- Please Provide Inputs 
• 13:28   Re: hot_standby_feedback parameter doesn't work Andrey Zhidenkov
• 13:31   Re: Ora2pg Not Getting Installed- Please Provide Inputs Stéphane KANSCHINE
• 13:40   RE: Ora2pg Not Getting Installed- Please Provide Inputs 
• 15:00   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 16:20   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 18:35   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa
• 18:41   Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo
• 18:53   Re: hot_standby_feedback parameter doesn't work Rui DeSousa
• 19:06   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 19:27   Re: Ora2pg Not Getting Installed- Please Provide Inputs SAS
• 19:39   RE: Ora2pg Not Getting Installed- Please Provide Inputs 
• 19:50   Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo
• 19:58   Re: Ora2pg Not Getting Installed- Please Provide Inputs Pepe TD Vo
• 20:08   RE: Ora2pg Not Getting Installed- Please Provide Inputs 

14 November 2018

• 03:48   Db restore Error literal carriage return found hint use \r Om Prakash Jaiswal
• 03:56   Db restore Error literal carriage return found hint use \r David G. Johnston
• 04:52   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa
• 11:31   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 19:24   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa
• 22:49   Automating pg_Dump on Windows 2016 Server Simon White

15 November 2018

• 00:59   Re: Automating pg_Dump on Windows 2016 Server Thomas Kellerer
• 06:22   Re: hot_standby_feedback parameter doesn't work Andrey Zhidenkov
• 10:20   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 17:48   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa
• 21:18   The current shape of PG master-slave replication pgsql-admin@kolttonen.fi
• 21:28   Can't find a relation in pg_class Ron
• 21:41   Re: The current shape of PG master-slave replication Payal Singh
• 21:53   checkpoint occurs very often when vacuum full running Mariel Cherkassky
• 21:53   checkpoint occurs very often when vacuum full running Mariel Cherkassky
• 21:56   Re: Can't find a relation in pg_class Tom Lane
• 22:10   Re: checkpoint occurs very often when vacuum full running Sergei Kornilov
• 22:10   Re: checkpoint occurs very often when vacuum full running Sergei Kornilov
• 22:29   Re: checkpoint occurs very often when vacuum full running Mariel Cherkassky
• 22:29   Re: checkpoint occurs very often when vacuum full running Mariel Cherkassky
• 22:57   Re: Can't find a relation in pg_class Ron
• 23:02   Re: Can't find a relation in pg_class Alvaro Herrera
• 23:09   Re: Can't find a relation in pg_class Ron
• 23:28   Re: Can't find a relation in pg_class Alvaro Herrera
• 23:28   Re: checkpoint occurs very often when vacuum full running Sergei Kornilov
• 23:28   Re: checkpoint occurs very often when vacuum full running Sergei Kornilov
• 23:32   Re: checkpoint occurs very often when vacuum full running Laurenz Albe
• 23:36   Re: The current shape of PG master-slave replication Laurenz Albe

16 November 2018

• 08:01   Re: The current shape of PG master-slave replication pgsql-admin@kolttonen.fi
• 08:03   Re: The current shape of PG master-slave replication pgsql-admin@kolttonen.fi
• 11:18   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 13:56   why optimizer not choosing correct index (btree vs btree_gin) srinivas oguri
• 18:29   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa
• 18:36   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa

17 November 2018

• 13:51   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 14:07   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 14:36   Re: checkpoint occurs very often when vacuum full running Mariel Cherkassky
• 22:28   Re: checkpoint occurs very often when vacuum full running Laurenz Albe
• 23:47   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa

18 November 2018

• 00:18   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa
• 10:03   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 12:29   postgresql history and timelines Mariel Cherkassky
• 16:38   Re: postgresql history and timelines Achilleas Mantzios
• 20:13   unclear behavior xmax/xmin Mariel Cherkassky
• 22:04   Re: unclear behavior xmax/xmin Laurenz Albe
• 23:23   Re: unclear behavior xmax/xmin Andres Freund
• 23:28   Re: unclear behavior xmax/xmin Mariel Cherkassky
• 23:34   Re: unclear behavior xmax/xmin Andres Freund

19 November 2018

• 12:36   logging aql queries only one table or tables of one scheme Häfliger Guido
• 18:20   RE: Ora2pg Not Getting Installed- Please Provide Inputs 
• 19:13   Re: logging aql queries only one table or tables of one scheme David G. Johnston
• 20:31   autovacuum is running but pg_stat_all_tables empty Mariel Cherkassky
• 20:31   autovacuum is running but pg_stat_all_tables empty Mariel Cherkassky
• 21:52   Re: autovacuum is running but pg_stat_all_tables empty Laurenz Albe
• 21:52   Re: autovacuum is running but pg_stat_all_tables empty Laurenz Albe
• 22:03   Re: logging aql queries only one table or tables of one scheme Achilleas Mantzios
• 23:25   pgadmin4 - session timeout problem in browser Bogdan Yakovenko

20 November 2018

• 06:58   Can long-running VACUUM be interrupted? Andrey Zhidenkov
• 10:05   AW: logging aql queries only one table or tables of one scheme Häfliger Guido
• 11:05   Re: Can long-running VACUUM be interrupted? Adrien NAYRAT
• 12:37   Re: pgadmin4 - session timeout problem in browser Stéphane KANSCHINE
• 18:55   inserts take longer and longer David Modica
• 19:41   Re: inserts take longer and longer Stéphane KANSCHINE
• 19:52   Re: inserts take longer and longer Ravi Krishna
• 21:10   Oracle to Postgres-Licensed GUI tool 
• 21:15   Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci
• 21:18   RE: Oracle to Postgres-Licensed GUI tool 
• 21:21   Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci
• 21:33   RE: Oracle to Postgres-Licensed GUI tool 
• 22:17   Re: Oracle to Postgres-Licensed GUI tool Thomas Kellerer
• 22:42   Re: Oracle to Postgres-Licensed GUI tool abbas alizadeh
• 23:14   Re: Oracle to Postgres-Licensed GUI tool Pepe TD Vo
• 23:34   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 23:48   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Rui DeSousa

21 November 2018

• 00:06   RE: Oracle to Postgres-Licensed GUI tool Erwin Fritz
• 06:41   Trigger to create automated range partition table bhanu prabhakar
• 07:59   Error while upgrading from 9.5 to 10 Srinivas Reddy
• 09:03   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 09:40   Re: Trigger to create automated range partition table Keith
• 11:09   Re: Trigger to create automated range partition table legrand legrand
• 12:04   Re: Oracle to Postgres-Licensed GUI tool Shreeyansh Dba
• 12:10   RE: Oracle to Postgres-Licensed GUI tool 
• 12:20   query performance after database rename Zwettler Markus (OIZ)
• 13:00   Re: Error while upgrading from 9.5 to 10 Achilleas Mantzios
• 13:23   Re: Error while upgrading from 9.5 to 10 Thomas Poty
• 14:24   Re: query performance after database rename srinivas oguri
• 15:00   AW: query performance after database rename Zwettler Markus (OIZ)
• 15:12   Re: query performance after database rename srinivas oguri
• 15:22   AW: query performance after database rename Zwettler Markus (OIZ)
• 17:03   RE: inserts take longer and longer David Modica
• 17:04   RE: inserts take longer and longer David Modica
• 17:53   Re: query performance after database rename Don Seiler
• 18:41   AW: query performance after database rename Zwettler Markus (OIZ)
• 19:06   Re: query performance after database rename Jonah H. Harris

22 November 2018

• 14:52   pgAdmin 4 v3.5 eternal loading Maycon Oleczinski
• 16:03   Re: pgAdmin 4 v3.5 eternal loading Shreeyansh Dba
• 18:15   backend proccess memory accumulates Sebastian Gabbert
• 19:26   Re: backend proccess memory accumulates Tom Lane
• 20:31   Re: backend proccess memory accumulates Sebastian Gabbert
• 21:48   Re: backend proccess memory accumulates Rui DeSousa

23 November 2018

• 01:15   Re: Oracle to Postgres-Licensed GUI tool Mark Kirkwood
• 03:13   Re: Oracle to Postgres-Licensed GUI tool Pepe TD Vo
• 03:21   Re: Oracle to Postgres-Licensed GUI tool Mark Kirkwood
• 08:20   Logical wal receiver (background worker) not detecting when publishernode has died Achilleas Mantzios
• 13:14   pgpool2 HA + split brain Zwettler Markus (OIZ)
• 14:10   Re: PostgreSQL 10.5 : Logical replication timeout results in PANICin pg_wal "No space left on device" Alvaro Herrera
• 15:13   Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device" Achilleas Mantzios
• 17:31   Re: Logical replication monitoring AYahorau@ibagroup.eu
• 17:36   User Authentication: LDAP and "local" accounts concurrently ? Lentes, Bernd
• 17:47   Re: User Authentication: LDAP and "local" accounts concurrently ? Tom Lane
• 17:56   Re: Logical replication monitoring Achilleas Mantzios
• 18:17   Re: User Authentication: LDAP and "local" accounts concurrently ? Stephen Frost
• 21:57   Re: User Authentication: LDAP and "local" accounts concurrently ? Lentes, Bernd
• 22:14   Re: User Authentication: LDAP and "local" accounts concurrently ? Stephen Frost

24 November 2018

• 00:38   Re: User Authentication: LDAP and "local" accounts concurrently ? Lentes, Bernd
• 00:44   Re: User Authentication: LDAP and "local" accounts concurrently ? Stephen Frost
• 01:14   Re: User Authentication: LDAP and "local" accounts concurrently ? Scott Ribe
• 04:00   Re: Logical wal receiver (background worker) not detecting whenpublisher node has died Rui DeSousa
• 04:19   Re: Logical wal receiver (background worker) not detecting whenpublisher node has died Rui DeSousa
• 09:25   Re: could not connect to server, in order to operatepgAdmin/PostgreSQL Ron
• 13:59   canceling statement coming in slave instance Rohit Arora
• 14:04   Re: canceling statement coming in slave instance Rohit Arora
• 14:23   Re: canceling statement coming in slave instance Shreeyansh Dba
• 15:16   Re: could not connect to server, in order to operatepgAdmin/PostgreSQL Ricardo Martin Gomez
• 16:47   Re: could not connect to server, in order to operatepgAdmin/PostgreSQL Michael Banck
• 19:00   Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Malik Rumi
• 21:10   Re: could not connect to server, in order to operatepgAdmin/PostgreSQL Ron
• 22:05   Re: canceling statement coming in slave instance Laurenz Albe
• 22:54   Re: User Authentication: LDAP and "local" accounts concurrently ? Lentes, Bernd
• 23:08   Re: User Authentication: LDAP and "local" accounts concurrently ? Stephen Frost
• 23:38   Re: User Authentication: LDAP and "local" accounts concurrently ? Lentes, Bernd
• 23:52   Re: User Authentication: LDAP and "local" accounts concurrently ? Stephen Frost

25 November 2018

• 11:37   Re: could not connect to server, in order to operatepgAdmin/PostgreSQL Achilleas Mantzios
• 11:39   Re: could not connect to server, in order to operatepgAdmin/PostgreSQL Achilleas Mantzios

26 November 2018

• 13:46   Re: canceling statement coming in slave instance Shreeyansh Dba

27 November 2018

• 07:50   Re: canceling statement coming in slave instance Rohit Arora
• 08:12   Re: canceling statement coming in slave instance Laurenz Albe

28 November 2018

• 17:22   Manual Vacuum Analyze Take More Time Moin Akther
• 17:55   Re: Manual Vacuum Analyze Take More Time Ron
• 18:35   Re: Manual Vacuum Analyze Take More Time Shreeyansh Dba
• 18:47   Re: Manual Vacuum Analyze Take More Time Keith Fiske
• 19:42   Re: Manual Vacuum Analyze Take More Time Moin Akther
• 19:46   Re: Manual Vacuum Analyze Take More Time Ravi Krishna
• 20:12   Re: Manual Vacuum Analyze Take More Time Keith Fiske

29 November 2018

• 11:27   Keeping /data directory on dNFS share makes it extremely slow ad notusable Shukla, Sumeet
• 18:51   Fwd: pgAdmin 4 v3.5 eternal loading Maycon Oleczinski
• 19:32   Re: Keeping /data directory on dNFS share makes it extremely slowad not usable Laurenz Albe

30 November 2018

• 06:46   Disable copy function prasanna rk
• 08:04   Re: Disable copy function David G. Johnston
• 12:18   Re: Disable copy function Andrew Gierth
• 12:34   Re: Disable copy function Ron
• 13:17   Backup solution over unreliable network Achilleas Mantzios
• 14:38   Dropped User Session Vishal Kohli
• 14:38   Dropped User Session Vishal Kohli
• 14:50   Re: Dropped User Session Vishal Kohli
• 14:50   Re: Dropped User Session Vishal Kohli
• 15:06   Re: Backup solution over unreliable network Stephen Frost
• 16:46   Re: Backup solution over unreliable network Achilleas Mantzios
• 18:29   Re: Backup solution over unreliable network Stephen Frost
• 19:09   Re: Disable copy function David G. Johnston
• 19:24   Re: Backup solution over unreliable network Achilleas Mantzios
• 19:41   Re: Backup solution over unreliable network David Steele
• 19:50   Re: Backup solution over unreliable network David Steele
• 21:22   Re: Backup solution over unreliable network Evan Bauer
• 21:49   Re: Backup solution over unreliable network Achilleas Mantzios
• 21:59   Re: Backup solution over unreliable network Achilleas Mantzios