pgsql-admin since 2018-10-15 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)

Browse Archives

Prev | Next

Oct. 15, 2018

Thread Author Time
Re: Null value returned by function pg_last_wal_receive_lsn() inLogical Replication Mark Kirkwood 02:22
Re: Hick ups in Postgresql Logical Replication Mark Kirkwood 02:28
Commit not required for update statement prasanna rk 02:30
Re: Commit not required for update statement Evan Bauer 02:44
Re: Commit not required for update statement Mark Kirkwood 03:49
Re: Commit not required for update statement prasanna rk 05:06
Re: Null value returned by function pg_last_wal_receive_lsn() inLogical Replication soumitra bhandary 05:48
Re: Commit not required for update statement David G. Johnston 05:58
WAL Master error arvind chikne 07:10
RE: WAL Master error Ahmed, Nawaz 07:15
pgpool versus which tool? Pierre Ochsenbein 07:38
Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Laurenz Albe 07:43
Re: How should the correct value of shmmax be calculated for DWH (OLAP) server 📎 Gunnar "Nick" Bluth 07:49
Re: Commit not required for update statement Mark Kirkwood 08:16
Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Laurenz Albe 08:21
Re: pgpool versus which tool? Thomas Kellerer 08:21
Re: pgpool versus which tool? Prince Pathria 10:00
Re: Hick ups in Postgresql Logical Replication pavan95 10:11
Re: pgpool versus which tool? Achilleas Mantzios 10:34
I need a support Celeste Mavoula 10:51
effective_cache_size cfg Ghiurea, Isabella 18:04
Re: effective_cache_size cfg Scott Ribe 20:03

Oct. 16, 2018

Thread Author Time
Re: Hick ups in Postgresql Logical Replication Mark Kirkwood 01:35
Re: Hick ups in Postgresql Logical Replication pavan95 05:26
Re: Hick ups in Postgresql Logical Replication Mark Kirkwood 06:07
Re: effective_cache_size cfg Laurenz Albe 08:02

Oct. 17, 2018

Thread Author Time
Slow client connection to postgresql server samuel.cc 05:55
Pgpool error arvind chikne 06:18
Re: Pgpool error Shreeyansh Dba 11:20

Oct. 18, 2018

Thread Author Time
Re: pgpool versus which tool? Pierre Ochsenbein 06:46
"constructor" does not work as alias for me Marcus Strube 15:44
Re: "constructor" does not work as alias for me Andres Freund 16:02
Re: "constructor" does not work as alias for me Marcus Strube 16:07
Re: "constructor" does not work as alias for me Andres Freund 16:13

Oct. 19, 2018

Thread Author Time
Re: "constructor" does not work as alias for me Thomas Kellerer 06:04
minimal network speed for replication prasanna rk 10:22
Restore/Backup menu items missing Mark Williams 11:19
Re: Restore/Backup menu items missing Evan Bauer 11:24
Re: minimal network speed for replication Fabio Pardi 11:34
Re: minimal network speed for replication prasanna rk 13:11
Auto create partition with declarative partitioning Jorge Torralba 20:52
Re: Auto create partition with declarative partitioning Scott Ribe 20:57
Re: Auto create partition with declarative partitioning Jorge Torralba 21:01
Re: Auto create partition with declarative partitioning Keith Fiske 21:09

Oct. 21, 2018

Thread Author Time
Re: minimal network speed for replication prasanna rk 01:01

Oct. 22, 2018

Thread Author Time
Cannot start PostgreSQL 10 server after directory permision change Ertan Küçükoğlu 07:22
Re: minimal network speed for replication Fabio Pardi 09:51
Re: minimal network speed for replication prasanna rk 14:12
Re: Auto create partition with declarative partitioning Alvaro Herrera 14:49

Oct. 23, 2018

Thread Author Time
Re: Point in time Recovery in Postgres? pavan95 04:43
Re: Point in time Recovery in Postgres? Shreeyansh Dba 05:46
Re: Point in time Recovery in Postgres? Pavan Teja 05:50
Re: Point in time Recovery in Postgres? Evan Bauer 05:56
Re: Point in time Recovery in Postgres? Vikas Gupta 05:57
No Known Snapshots error w/pg_recvlogical and wal2json plugin... Jerry Sievers 19:29

Oct. 24, 2018

Thread Author Time
Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin... Julien Riou 02:48
Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin... Jerry Sievers 03:03
Encryption / Decryption via PGCrypto Anjul Tyagi 08:27
Re: Encryption / Decryption via PGCrypto Stéphane KANSCHINE 09:00
Can I add a column in catalog table as a superuser ZongtianHou 09:35
Re: Can I add a column in catalog table as a superuser Tom Lane 09:43
Re: Can I add a column in catalog table as a superuser ZongtianHou 09:54
Is there a work around for partition key needed for constraint Jorge Torralba 18:56
Re: Is there a work around for partition key needed for constraint legrand legrand 19:04
Re: Is there a work around for partition key needed for constraint Jorge Torralba 22:11
Re: Is there a work around for partition key needed for constraint Keith Fiske 22:33

Oct. 25, 2018

Thread Author Time
Re: Encryption / Decryption via PGCrypto Evan Bauer 03:47
Using pg_basebackup via pgpool fail Mihalidesová Jana 09:31
Re: Is there a work around for partition key needed for constraint Alvaro Herrera 13:59
upgrade slave in streaming replication from PG 10.4 to 10.5.1 Ghiurea, Isabella 14:53
Re: upgrade slave in streaming replication from PG 10.4 to 10.5.1 Johannes Truschnigg 18:07
Re: Is there a work around for partition key needed for constraint legrand legrand 21:02
Re: Is there a work around for partition key needed for constraint Jehan-Guillaume (ioguix) de Rorthais 21:16
Re: Is there a work around for partition key needed for constraint legrand legrand 21:36
Re: Is there a work around for partition key needed for constraint Jorge Torralba 22:54

Oct. 26, 2018

Thread Author Time
Re: Is there a work around for partition key needed for constraint legrand legrand 05:33

Oct. 29, 2018

Thread Author Time
hot standby cascading replication 📎 Mark Steben 16:24
pgpool arvind chikne 19:17
Re: pgpool Alex Balashov 19:21
Re: pgpool arvind chikne 19:31
Re: pgpool Alex Balashov 19:37
Re: pgpool arvind chikne 19:42
Re: pgpool Jehan-Guillaume (ioguix) de Rorthais 19:58
Getting fancy errors when accessing information_schema on 10.5 Axel Rau 22:05

Oct. 30, 2018

Thread Author Time
Re: Getting fancy errors when accessing information_schema on 10.5 Laurenz Albe 07:42
Re: Getting fancy errors when accessing information_schema on 10.5 Axel Rau 11:32
creating table without columns Subodh Kumar 11:52
Re: Getting fancy errors when accessing information_schema on 10.5 Tom Lane 12:17
Re: Getting fancy errors when accessing information_schema on 10.5 Axel Rau 12:31
Re: creating table without columns Greg Spiegelberg 12:53
Re: Getting fancy errors when accessing information_schema on 10.5 Tom Lane 12:58
Re: creating table without columns Christoph Berg 13:00
Re: Getting fancy errors when accessing information_schema on 10.5 Axel Rau 13:02
Re: creating table without columns Tom Lane 13:12
Re: creating table without columns Subodh Kumar 13:15
Re: Getting fancy errors when accessing information_schema on 10.5 Laurenz Albe 13:18
Re: Getting fancy errors when accessing information_schema on 10.5 Tom Lane 13:45
Re: Getting fancy errors when accessing information_schema on 10.5 Axel Rau 14:35
Re: Getting fancy errors when accessing information_schema on 10.5 Laurenz Albe 14:40
Re: Getting fancy errors when accessing information_schema on 10.5 Tom Lane 15:04
Re: Getting fancy errors when accessing information_schema on 10.5 Axel Rau 15:12
Re: Getting fancy errors when accessing information_schema on 10.5 Tom Lane 15:29
Re: Getting fancy errors when accessing information_schema on 10.5 Axel Rau 15:51

Oct. 31, 2018

Thread Author Time
ALTER PUBLICATION Lalith Tenneti 00:28
Re: ALTER PUBLICATION David G. Johnston 00:35
Error code for "no partition or relation found for row" nunks 01:03
Re: Error code for "no partition or relation found for row" nunks 01:26
Poverty Partitioning, include indexes Simon Liesenfeld 05:25
Re: Poverty Partitioning, include indexes Laurenz Albe 06:47
Permission denied Pierre Ochsenbein 09:03
Re: Permission denied Fabio Pardi 09:13
Re: minimal network speed for replication Fabio Pardi 11:09
Fwd: ALTER PUBLICATION Lalith Tenneti 22:00

Nov. 1, 2018

Thread Author Time
change bigint column to int Mariel Cherkassky 10:20
Re: change bigint column to int Shreeyansh Dba 11:07
Re: change bigint column to int Mariel Cherkassky 11:12
Re: change bigint column to int Evan Bauer 11:54
Re: change bigint column to int Mariel Cherkassky 12:54
Re: change bigint column to int Evan Bauer 13:52
Re: change bigint column to int Mariel Cherkassky 14:31

Nov. 2, 2018

Thread Author Time
maintenance_work_mem is it per instance or per database?? pavan95 04:27
Re: maintenance_work_mem is it per instance or per database?? Keith 04:43
Re: maintenance_work_mem is it per instance or per database?? pavan95 05:00
Relation between parameters in postgresql.conf file!! pavan95 06:39
Re: maintenance_work_mem is it per instance or per database?? Shreeyansh Dba 07:05
Re: Relation between parameters in postgresql.conf file!! Shreeyansh Dba 09:13
Re: Relation between parameters in postgresql.conf file!! Rui DeSousa 14:56
[No subject] Pierre Ochsenbein 15:56
Re: Fabio Pardi 16:05
new postgresql.org community account Pepe TD Vo 16:23
Re: Rui DeSousa 20:31
postgresql95 package dependencies? Ron 20:57

Nov. 3, 2018

Thread Author Time
Re: Shreeyansh Dba 07:25
Re: Can I add a column in catalog table as a superuser Peter Eisentraut 09:00
Re: Rui DeSousa 16:45
Re: postgresql95 package dependencies? Florian Weimer 19:06
Re: postgresql95 package dependencies? Ron 19:58

Nov. 4, 2018

Thread Author Time
size of table + toasted tables + indexes != pg_total_relation_size Mariel Cherkassky 10:14
Re: size of table + toasted tables + indexes != pg_total_relation_size Andrew Gierth 12:12
Re: size of table + toasted tables + indexes != pg_total_relation_size Mariel Cherkassky 15:09
Re: size of table + toasted tables + indexes != pg_total_relation_size Andrew Gierth 16:47
Re: size of table + toasted tables + indexes != pg_total_relation_size Rui DeSousa 19:49

Nov. 5, 2018

Thread Author Time
PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Achilleas Mantzios 11:24
Re: How to revoke "Create Privilege" from a readonly user in postgres? pavan95 12:12
Re: How to revoke "Create Privilege" from a readonly user in postgres? Achilleas Mantzios 12:32
Re: How to revoke "Create Privilege" from a readonly user in postgres? Shreeyansh Dba 13:02
Re: How to revoke "Create Privilege" from a readonly user in postgres? Rui DeSousa 16:14
Re: Pierre Ochsenbein 16:25
Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Rui DeSousa 16:48
Re: Rui DeSousa 16:59

Nov. 6, 2018

Thread Author Time
Re: hot standby cascading replication Nikhil Shetty 04:41
Re: hot standby cascading replication Shreeyansh Dba 07:28
Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Achilleas Mantzios 08:37
Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Laurenz Albe 12:41
Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Achilleas Mantzios 14:53
Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Tom Lane 14:58
Another streaming replication question 📎 Mark Steben 17:13
Re: Another streaming replication question Johannes Truschnigg 21:08
Re: Another streaming replication question Rui DeSousa 21:09

Nov. 7, 2018

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

Nov. 8, 2018

Thread Author Time
Re: execute a procedure from another procudure? Peter Eisentraut 08:59
Re: query can't merge into table of the other schema Guillaume Lelarge 09:16
Re: execute a procedure from another procudure? Pepe TD Vo 20:13

Nov. 9, 2018

Thread Author Time
%rowtype Pepe TD Vo 02:54
Re: %rowtype Laurenz Albe 07:26
Re: %rowtype Pepe TD Vo 13:12
Re: %rowtype Laurenz Albe 16:40

Nov. 10, 2018

Thread Author Time
Modules but not extensions Ron 10:08
How to downgrade a cluster from 9.5 to 9.3 Michael Lupo 15:25

Nov. 11, 2018

Thread Author Time
Re: Modules but not extensions Peter Eisentraut 20:09
Re: How to downgrade a cluster from 9.5 to 9.3 Peter Eisentraut 20:12

Nov. 12, 2018

Thread Author Time
PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device" Achilleas Mantzios 10:41
Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint Achilleas Mantzios 14:00
Re: query can't merge into table of the other schema Pepe TD Vo 15:48
Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device" Rui DeSousa 16:30
Re: query can't merge into table of the other schema David G. Johnston 16:31
Re: query can't merge into table of the other schema Pepe TD Vo 18:42

Nov. 13, 2018

Thread Author Time
hot_standby_feedback parameter doesn't work Andrey Zhidenkov 03:28
Re: How to downgrade a cluster from 9.5 to 9.3 Nikhil Shetty 04:19
Re: hot_standby_feedback parameter doesn't work Rui DeSousa 04:47
Re: hot_standby_feedback parameter doesn't work Andres Freund 05:07

Browse Archives

Prev | Next