pgsql-admin - July 2013

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

July 1, 2013

Thread Author Time
How was I able to drop a role even though objects depend on it? Wojciechowski, Robert (GE Transportation) 14:20
Re: pg_upgrade / postgis issue Marcos Cano 16:15
Re: How was I able to drop a role even though objects depend on it? Alvaro Herrera 16:20
Re: pg_upgrade / postgis issue Marcos Cano 16:20
Re: How was I able to drop a role even though objects depend on it? David Johnston 16:46
one client with multiple ssl cert connections to different databases Megan 17:03
Re: one client with multiple ssl cert connections to different databases Magnus Hagander 17:08
Re: How was I able to drop a role even though objects depend on it? Alvaro Herrera 17:38
Re: How was I able to drop a role even though objects depend on it? David Johnston 19:38

July 3, 2013

Thread Author Time
Re: Migration from Sybase to Postgresql etharani 06:39
pg_dump, pg_restore from 9.2 on 8.4 server Jiří Hlinka 08:33
Re: pg_dump, pg_restore from 9.2 on 8.4 server Ian Lawrence Barwick 11:53
Re: Migration from Sybase to Postgresql Dev Kumkar 15:38
Re: pg_dump, pg_restore from 9.2 on 8.4 server Guillaume Lelarge 20:50

July 4, 2013

Thread Author Time
Re: pg_upgrade / postgis issue Sergey Konoplev 01:12
Re: pg_upgrade / postgis issue Marcos Cano 14:12

July 5, 2013

Thread Author Time
creating a circular replication in postgres Jayesh Nambiar 06:59
Re: creating a circular replication in postgres bricklen 16:29

July 6, 2013

Thread Author Time
Re: creating a circular replication in postgres Jayesh Nambiar 05:34

July 7, 2013

Thread Author Time
Starting psql without connection Thorsten Kampe 08:11
Re: Starting psql without connection Peter Eisentraut 12:26
Re: pg_upgrade / postgis issue Sergey Konoplev 19:38
PG wiki updated with query to show unindexed foreign keys bricklen 23:29

July 8, 2013

Thread Author Time
search_path update weirdness Colin S 12:40
Re: search_path update weirdness Szymon Guz 12:46
Re: search_path update weirdness Colin S 12:57
Dump/Reload pg_statistic to cut time from pg_upgrade? Jerry Sievers 19:20

July 10, 2013

Thread Author Time
Re: PG wiki updated with query to show unindexed foreign keys Scott Ribe 00:02
Re: PG wiki updated with query to show unindexed foreign keys bricklen 00:29
Re: PG wiki updated with query to show unindexed foreign keys Scott Ribe 00:34
Re: PG wiki updated with query to show unindexed foreign keys bricklen 00:36
Re: Dump/Reload pg_statistic to cut time from pg_upgrade? Kevin Grittner 14:09
Re: Dump/Reload pg_statistic to cut time from pg_upgrade? Jerry Sievers 15:47
Re: Dump/Reload pg_statistic to cut time from pg_upgrade? Tom Lane 16:46
Upgrading from 9.1 to 9.2 in place, same machine Wells Oliver 17:53
Re: Upgrading from 9.1 to 9.2 in place, same machine Jonathan Nalley 18:08
Re: Upgrading from 9.1 to 9.2 in place, same machine Chris Ernst 18:10
Re: Upgrading from 9.1 to 9.2 in place, same machine [email protected] 18:16
Re: Upgrading from 9.1 to 9.2 in place, same machine Wells Oliver 18:52
Re: Upgrading from 9.1 to 9.2 in place, same machine Vincent Lau 18:59
Re: Upgrading from 9.1 to 9.2 in place, same machine Wells Oliver 19:02
Re: Upgrading from 9.1 to 9.2 in place, same machine [email protected] 19:03
Re: Upgrading from 9.1 to 9.2 in place, same machine Vincent Lau 19:12
Re: Upgrading from 9.1 to 9.2 in place, same machine [email protected] 19:13
Re: Upgrading from 9.1 to 9.2 in place, same machine Wells Oliver 19:19
Re: Upgrading from 9.1 to 9.2 in place, same machine Vincent Lau 19:24
Re: Upgrading from 9.1 to 9.2 in place, same machine lxnf98mm 20:46
Re: Upgrading from 9.1 to 9.2 in place, same machine [email protected] 21:02
Re: Upgrading from 9.1 to 9.2 in place, same machine Vincent Lau 21:11
Upgrading from 9.1 to 9.2 - master AND slave Wells Oliver 21:14
Connecting to a remote db server Struckhoff, Kevin 21:58
Re: Connecting to a remote db server Alvaro Herrera 22:22
Re: Connecting to a remote db server Kevin Grittner 22:24
Re: Connecting to a remote db server Struckhoff, Kevin 22:27
Re: Connecting to a remote db server Struckhoff, Kevin 22:33
Re: Connecting to a remote db server Alvaro Herrera 22:41
Re: Connecting to a remote db server Alvaro Herrera 23:06
Re: Connecting to a remote db server javmendez1 23:19
Re: Connecting to a remote db server Struckhoff, Kevin 23:45
Re: Connecting to a remote db server javmendez1 23:50

July 11, 2013

Thread Author Time
Re: Connecting to a remote db server Struckhoff, Kevin 00:00
Re: Connecting to a remote db server Kevin Grittner 03:37
Building an extension for a different version of Postgres Wells Oliver 17:44
Re: Building an extension for a different version of Postgres Raghavendra 17:52
Re: Building an extension for a different version of Postgres Wells Oliver 17:56
Re: Building an extension for a different version of Postgres Devrim GÜNDÜZ 18:34
Creating new cluster by copying directory? Wells Oliver 20:31
Re: Creating new cluster by copying directory? 📎 Gilberto Castillo 20:41
Re: Creating new cluster by copying directory? Wells Oliver 20:42
Re: Creating new cluster by copying directory? Kevin Grittner 20:48
Re: Creating new cluster by copying directory? 📎 Gilberto Castillo 20:50
Re: Creating new cluster by copying directory? Jerry Sievers 20:54
Re: Creating new cluster by copying directory? Wells Oliver 21:36

July 12, 2013

Thread Author Time
Couldn't start postgres, got no logging, ran postgres manually for info-- help? Wells Oliver 02:07
pg_upgrade (9.1 to 9.2) bombing on casts Wells Oliver 04:55
Re: pg_upgrade (9.1 to 9.2) bombing on casts Alvaro Herrera 05:09
Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help? Giuseppe Broccolo 09:23
logging or debugging to report time to establish a database connection Mike Broers 15:00
Re: logging or debugging to report time to establish a database connection Scott Ribe 15:21
Re: logging or debugging to report time to establish a database connection Scott Ribe 15:53
Re: logging or debugging to report time to establish a database connection Scott Ribe 16:03
Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help? Wells Oliver 17:29
Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help? Jerry Sievers 18:14

July 13, 2013

Thread Author Time
0-byte 2PC File Vincent Lau 23:41

July 14, 2013

Thread Author Time
Re: 0-byte 2PC File Tom Lane 16:19
Re: 0-byte 2PC File Vincent Lau 21:04

July 15, 2013

Thread Author Time
Re: Upgrading from 9.1 to 9.2 - master AND slave Sergey Konoplev 04:31
Re: Creating new cluster by copying directory? Sergey Konoplev 05:35
Re: pg_upgrade (9.1 to 9.2) bombing on casts Sergey Konoplev 05:42
Re: pg_upgrade (9.1 to 9.2) bombing on casts Bruce Momjian 08:47
restoring a table after an online backup Bert 13:02
9.2.2 - semop hanging Rafael Domiciano 13:16
Re: restoring a table after an online backup 📎 Gilberto Castillo 13:19
Re: restoring a table after an online backup Prashanth Ranjalkar 13:35
Re: 9.2.2 - semop hanging Eduardo Morras 13:44
Re: 9.2.2 - semop hanging Prashanth Ranjalkar 14:27
Re: 9.2.2 - semop hanging Prashanth Ranjalkar 14:31
iconv -c ? 📎 Jan-Peter Seifert 14:55
9.2 Observer node for streaming replication Jorge Torralba 15:55
Re: 9.2 Observer node for streaming replication Joshua D. Drake 16:15
Re: 9.2 Observer node for streaming replication Jorge Torralba 16:38
Re: pg_upgrade (9.1 to 9.2) bombing on casts Sergey Konoplev 16:52
Postgres upgrade from version 9.04 to 9.1.3 Mónica Gamarra 17:54
Re: Postgres upgrade from version 9.04 to 9.1.3 Prashanth Ranjalkar 18:15
Re: 9.2.2 - semop hanging Kevin Grittner 19:12
Help with PITR in PostgreSQL 8.4 Nestor A. Diaz 22:06

July 16, 2013

Thread Author Time
777 permissions on basebackup directory prakhar jauhari 04:42
Re: 777 permissions on basebackup directory Magnus Hagander 08:39
Re: Upgrading from 9.1 to 9.2 - master AND slave Bruce Momjian 09:58
HOW TO TAKE POSTGRESQL GEONETWORK BACKUP WHEN SERVICE DOESNOT START Emmanuel Massawe 12:37
Re: 9.2.2 - semop hanging Rafael Domiciano 13:08
Re: 9.2.2 - semop hanging Kevin Grittner 15:32
Clarification when using Continous Archiving in 8.4 Nestor A. Diaz 16:30
Re: 9.2.2 - semop hanging Eduardo 17:58
Re: Postgres upgrade from version 9.04 to 9.1.3 Bruce Momjian 22:45

July 17, 2013

Thread Author Time
comparison schema/data Javier Urbano Contreras 15:00
Re: Help with PITR in PostgreSQL 8.4 Nestor A. Diaz 15:44
Re: Help with PITR in PostgreSQL 8.4 📎 Gilberto Castillo 15:54
Re: Help with PITR in PostgreSQL 8.4 Nestor A. Diaz 16:40
Re: Migration from Sybase to Postgresql etharani 17:15
Re: Help with PITR in PostgreSQL 8.4 📎 Gilberto Castillo 17:26
Re: comparison schema/data Ketana Patel 20:08

July 18, 2013

Thread Author Time
Re: comparison schema/data raghu ram 11:00
Re: comparison schema/data javmendez1 11:05
Re: Migration from Sybase to Postgresql raghu ram 11:07
Re: comparison schema/data raghu ram 11:13
Re: Help with PITR in PostgreSQL 8.4 CS DBA 13:20
Re: comparison schema/data Gezeala M. Bacuño II 16:19

July 21, 2013

Thread Author Time
Re: Mag Gam Mag Gam 06:23
Re: iconv -c ? Peter Eisentraut 14:03

July 22, 2013

Thread Author Time
Re: iconv -c ? Jan-Peter Seifert 09:06
Re: iconv -c ? Peter Eisentraut 11:53
Fw: Lucas Restrepo gil 15:45

July 23, 2013

Thread Author Time
unexpected EOF on client connection during pg_dumpall Arnold, Sandra L. 17:52
Re: unexpected EOF on client connection during pg_dumpall Tom Lane 23:29
Re: Dump/Reload pg_statistic to cut time from pg_upgrade? Bruce Momjian 23:47
Re: Dump/Reload pg_statistic to cut time from pg_upgrade? Bruce Momjian 23:47

July 24, 2013

Thread Author Time
Postgres schema having > 20,000 schemas Anand Muthukrishnan 11:11
Re: Postgres schema having > 20,000 schemas Bruce Momjian 14:21
Re: Postgres schema having > 20,000 schemas Elliot 17:58
Re: Postgres schema having > 20,000 schemas Anand Muthukrishnan 18:08
Re: Postgres schema having > 20,000 schemas Bruce Momjian 18:17

July 26, 2013

Thread Author Time
Question about DB stats resets Luis 15:31
Disk latency goes up during certaing pediods German Becker 19:21
Re: Disk latency goes up during certaing pediods Alvaro Herrera 20:27

July 27, 2013

Thread Author Time
Re: Question about DB stats resets raghu ram 06:35

July 29, 2013

Thread Author Time
vacuum full suddently took extremely long Bert 07:08
Shell Script for Vacuum Manish Kediyal 07:17
Re: Shell Script for Vacuum raghu ram 07:26
Re: Shell Script for Vacuum Manish Kediyal 07:37
Re: Shell Script for Vacuum raghu ram 08:04
Re: Shell Script for Vacuum Manish Kediyal 08:08
Restore after using pg_dumpall Asmus Reinhard 13:19
Re: Restore after using pg_dumpall raghu ram 13:33
Re: Disk latency goes up during certaing pediods German Becker 14:17
Re: Disk latency goes up during certaing pediods Brett Stauner 16:15
Re: Shell Script for Vacuum Thomas Kellerer 16:31
Re: Disk latency goes up during certaing pediods German Becker 17:58
Re: Disk latency goes up during certaing pediods Brett Stauner 18:01
Re: Disk latency goes up during certaing pediods Luis 18:01
Re: Disk latency goes up during certaing pediods German Becker 19:41
Re: Disk latency goes up during certaing pediods German Becker 19:44
Re: Disk latency goes up during certaing pediods bricklen 20:06
Re: Disk latency goes up during certaing pediods German Becker 20:28
Re: Disk latency goes up during certaing pediods bricklen 21:07

July 30, 2013

Thread Author Time
Re: Shell Script for Vacuum Manish Kediyal 04:41
Re: Disk latency goes up during certaing pediods German Becker 15:35
Re: Disk latency goes up during certaing pediods bricklen 16:02
db crash, streaming rep slave will not start CS DBA 23:19

July 31, 2013

Thread Author Time
Exit code -1073741819 Carlos Henrique Reimer 01:11
Re: Restore after using pg_dumpall Samrat Revagade 07:00
Restore after pg_dumpall Asmus Reinhard 07:14
Problem: pg_ctl does not not stop postgres properly even with immediate option Jürgen Fuchsberger 13:16
Re: Disk latency goes up during certaing pediods German Becker 16:25
Re: Disk latency goes up during certaing pediods bricklen 16:34
Re: Disk latency goes up during certaing pediods German Becker 18:10

Browse Archives

Prev | Next