pgsql-admin - September 2012

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

Sept. 1, 2012

Thread Author Time
[Fwd: Re: symbol lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping] Devrim GÜNDÜZ 14:54

Sept. 3, 2012

Thread Author Time
Re: [pgsql-admin] JCR (Apache Jackrabbit) locking when using Postgres, not with MySQL Gary Webster 21:35
Re: [pgsql-admin] JCR (Apache Jackrabbit) locking when using Postgres, not with MySQL Gary Webster 21:47
PG 9.1 Looking for old WAL when promoting from recovery to master David Morton 22:01

Sept. 4, 2012

Thread Author Time
Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Mathias Breuninger 08:04
Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Sergey Konoplev 09:15
Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Albe Laurenz 09:27
Re: Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17) Kevin Grittner 15:15
Schema diagramming tool? Craig James 16:35
Re: Canot access PostgreSQL via psql -h (Vmware Fusion) Anderson Lunz 20:17
Re: Schema diagramming tool? Bob Lunney 20:57
Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Craig Ringer 21:44

Sept. 5, 2012

Thread Author Time
Re: Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17) Robert Haas 03:07
Re: What else could I've done? COPY to unlogged tbl "hung"/locked the table amacvar 04:01
Re: Schema diagramming tool? Sergey Konoplev 04:48
Re: Schema diagramming tool? Thomas Markus 05:47
Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Mathias Breuninger 09:21
Re: PG 9.1 Looking for old WAL when promoting from recovery to master Fujii Masao 14:08
Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Craig James 14:58
Re: Schema diagramming tool? Craig James 15:26

Sept. 6, 2012

Thread Author Time
Re: Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error Mathias Breuninger 07:00
Re: Schema diagramming tool? Sergey Konoplev 11:26
High Availability(Failover Clustering) for PostgreSQL on Windows 2008 R2 sradez 16:22
Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info) Robert Haas 18:45
Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info) Tom Lane 20:02
Re: High Availability(Failover Clustering) for PostgreSQL on Windows 2008 R2 Anibal David Acosta 20:39
Upgrading from 9.1.2 to 9.1.5 Antoine Guidi 22:55
Re: Upgrading from 9.1.2 to 9.1.5 Bruce Momjian 23:20

Sept. 7, 2012

Thread Author Time
Restore db with multi-tablespaces Rural Hunter 05:44
Re: Restore db with multi-tablespaces Sergey Konoplev 12:20

Sept. 8, 2012

Thread Author Time
Re: Upgrading from 9.1.2 to 9.1.5 Sergey Konoplev 20:26
Re: Upgrading from 9.1.2 to 9.1.5 Craig James 20:52

Sept. 10, 2012

Thread Author Time
Re: Restore db with multi-tablespaces Rural Hunter 07:00
Re: Upgrading from 9.1.2 to 9.1.5 Kevin Grittner 17:06
Re: Upgrading from 9.1.2 to 9.1.5 Antoine Guidi 17:16
Re: Upgrading from 9.1.2 to 9.1.5 Antoine Guidi 17:17
Re: Upgrading from 9.1.2 to 9.1.5 Craig James 17:30
Re: Upgrading from 9.1.2 to 9.1.5 Antoine Guidi 17:45
Re: Upgrading from 9.1.2 to 9.1.5 Bruce Momjian 19:56
Large historical tables and autovacuum David Morton 20:30

Sept. 11, 2012

Thread Author Time
Re: Large historical tables and autovacuum Rural Hunter 01:57
Re: Large historical tables and autovacuum Fernando Hevia 03:57
Re: Large historical tables and autovacuum David Morton 04:04
Re: Large historical tables and autovacuum Rosser Schwarz 04:29
Re: Large historical tables and autovacuum Albe Laurenz 08:55
pg_restore problem "Found unexpected Block id" ramana.pls 12:36
pg_upgrade with postgis Ronit Allen 13:15
Windows Services and Postgresql 9.1.3 Vincent Dautremont 20:48
Re: pg_upgrade with postgis Bruce Momjian 22:17

Sept. 12, 2012

Thread Author Time
[No subject] Wells Oliver 00:00
Massive insert created 975 WAL segments.. what? Wells Oliver 00:10
Re: Massive insert created 975 WAL segments.. what? Ray Stell 01:45
Re: Massive insert created 975 WAL segments.. what? Simon Riggs 06:14
Missing loadable libraries when running pg_upgrade 9.1 -> 9.2 Thomas Kellerer 09:09
Re: Missing loadable libraries when running pg_upgrade 9.1 -> 9.2 Thomas Kellerer 10:03
Re: pg_restore problem "Found unexpected Block id" Tom Lane 14:24
Re: pg_restore problem "Found unexpected Block id" Kevin Grittner 14:25
Re: Missing loadable libraries when running pg_upgrade 9.1 -> 9.2 Bruce Momjian 18:11
what is maximum allowed value of autovacuum_freeze_max_age Radovan Jablonovsky 22:44
Re: pg_upgrade with postgis Ronit Allen 23:12

Sept. 13, 2012

Thread Author Time
Re: what is maximum allowed value of autovacuum_freeze_max_age Kevin Grittner 03:13
Re: pg_upgrade with postgis Bruce Momjian 04:02
non-superuser login phpPgAdmin PostgreSQL 9.1 johnkn63 08:04
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 Albe Laurenz 08:15
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 johnkn63 08:30
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 Devrim GÜNDÜZ 08:35
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 johnkn63 08:45
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 Albe Laurenz 09:29
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 johnkn63 10:05
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 Albe Laurenz 10:27
Problem with pg_upgrade 9.2 on Windows Christian Ullrich 12:15
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 johnkn63 13:31
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 Albe Laurenz 14:11
Re: pg_restore problem "Found unexpected Block id" Kevin Grittner 14:13
Re: Problem with pg_upgrade 9.2 on Windows Bruce Momjian 14:37
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 johnkn63 14:46
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 johnkn63 15:08
Re: Problem with pg_upgrade 9.2 on Windows Christian Ullrich 21:36

Sept. 14, 2012

Thread Author Time
Re: what is maximum allowed value of autovacuum_freeze_max_age Bruce Momjian 00:56
Re: Problem with pg_upgrade 9.2 on Windows Bruce Momjian 00:59
pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 05:43
[No subject] Feridun türk 06:03
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 Albe Laurenz 07:59
Re: non-superuser login phpPgAdmin PostgreSQL 9.1 john knightley 13:02
Re: pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 14:26
Re: pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 15:53
Re: pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 18:39
I need lead all list Roberto Pardo 23:12

Sept. 15, 2012

Thread Author Time
Re: pg_upgrade from 9.1.3 to 9.2 failed 📎 Rural Hunter 03:40
PostGIS install fail on 64 bits Windows Seven system F. BROUARD / SQLpro 10:16
Re: pg_upgrade from 9.1.3 to 9.2 failed 📎 Bruce Momjian 18:06

Sept. 16, 2012

Thread Author Time
Re: pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 04:38
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 17:17
Re: what is maximum allowed value of autovacuum_freeze_max_age Kevin Grittner 17:38
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 22:04

Sept. 17, 2012

Thread Author Time
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 01:35
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 01:48
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 01:56
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 03:07
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 04:32
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 04:35
Re: Windows Services and Postgresql 9.1.3 Craig Ringer 04:42
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 04:47
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 05:03
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 05:07
Problem after changing the port number of postgres himanshu.joshi 06:25
Re: Problem after changing the port number of postgres Devrim GÜNDÜZ 06:29
Re: Problem after changing the port number of postgres Rural Hunter 06:34
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 21:07

Sept. 18, 2012

Thread Author Time
Linux: ps output shows multiple instances of PostgreSQL running on the same port David Throckmorton 00:38
Re: Windows Services and Postgresql 9.1.3 Anibal David Acosta 01:27
Re: Linux: ps output shows multiple instances of PostgreSQL running on the same port Tom Lane 01:36
Re: Windows Services and Postgresql 9.1.3 Anibal David Acosta 01:42
Problem in taking the database dump himanshu.joshi 08:57
Re: Schema diagramming tool? Cédric Villemain 11:12
Re: Problem in taking the database dump Tom Lane 14:03
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 23:22

Sept. 19, 2012

Thread Author Time
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 06:05
Postgres Cache usage A J 16:36
Re: Postgres Cache usage Steve Crawford 17:38
max_locks_per_transaction and partitioned tables Michael Holt 18:25
max_locks_per_transaction and partitioned tables Michael Holt 18:28
Re: max_locks_per_transaction and partitioned tables Tom Lane 21:03
Re: max_locks_per_transaction and partitioned tables Michael Holt 21:17
Problem creating temporary tables . . . Rubén Crespo Flores 21:21
Re: Problem creating temporary tables . . . Tom Lane 21:30

Sept. 20, 2012

Thread Author Time
WAL File Volume David Morton 02:13
Re: Postgres Cache usage Craig Ringer 02:28
how to allow integer overflow for calculating hash code of a string? Haifeng Liu 08:55
Re: how to allow integer overflow for calculating hash code of a string? Craig James 14:34
Backup and Restore from 8.3.0 to 9.1.3 Kasia Tuszynska 17:01
Re: Problem creating temporary tables . . . Tom Lane 17:36
Re: Problem creating temporary tables . . . Rubén Crespo Flores 20:09
Re: Problem creating temporary tables . . . Tom Lane 21:04

Sept. 21, 2012

Thread Author Time
Re: Backup and Restore from 8.3.0 to 9.1.3 Craig Ringer 01:18
Re: how to allow integer overflow for calculating hash code of a string? Haifeng Liu 02:56
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 09:16
Re: [ADMIN] Windows Services and Postgresql 9.1.3 Anibal David Acosta 15:06
Re: how to allow integer overflow for calculating hash code of a string? Craig James 15:21
Re: Windows Services and Postgresql 9.1.3 Scott Marlowe 16:33
Multiple servers with Postgresql John Coryat 19:50
Re: Windows Services and Postgresql 9.1.3 Walter Hurry 22:25

Sept. 22, 2012

Thread Author Time
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 04:15
Re: Windows Services and Postgresql 9.1.3 Craig Ringer 08:46

Sept. 23, 2012

Thread Author Time
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Peter Eisentraut 12:33
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 14:20
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Peter Eisentraut 22:46

Sept. 24, 2012

Thread Author Time
Re: Multiple servers with Postgresql Cliff Pratt 00:45
Re: Multiple servers with Postgresql Pascal Heraud 10:25
Re: Multiple servers with Postgresql John Coryat 11:50
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 12:55
changes to postgresql.conf Johnny Tan 13:05
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Peter Eisentraut 13:06
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 13:08
Re: changes to postgresql.conf Magnus Hagander 13:20
Re: changes to postgresql.conf Johnny Tan 13:32
Re: Windows Services and Postgresql 9.1.3 Vincent Dautremont 13:38
CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load Dennis Brouwer 13:53
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 13:59
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 14:13
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 14:26
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 14:31
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 14:38
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 14:45
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 14:57
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 15:04
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 15:07
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Peter Eisentraut 15:22
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Peter Eisentraut 15:24
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 15:28
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 15:30
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 15:44
Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load Tom Lane 16:30
Re: changes to postgresql.conf Steve Crawford 17:34
Backup and Restore from 8.3.0 to 9.1.3 Kasia Tuszynska 18:07
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed 📎 Bruce Momjian 18:51
Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load Dennis Brouwer 20:00
Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load Marcello Perathoner 21:05
dropping a large table is taking a very long time (about 2 hours so far) Evan Walter 21:10
Re: dropping a large table is taking a very long time (about 2 hours so far) Steve Crawford 21:15
Spurious failure to obtain row lock possible in PG 9.1? henk de wit 21:21
Re: dropping a large table is taking a very long time (about 2 hours so far) Vibhor Kumar 21:33
file descriptors still open to deleted files Greg Williamson 23:10

Sept. 25, 2012

Thread Author Time
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 00:41
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed 📎 Bruce Momjian 03:00
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 04:22
Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load Dennis Brouwer 12:58
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 13:10
Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load Tom Lane 15:57
WAL Log Processing For OLAP? P R 17:19
WAL recovery failure Rick Dicaire 18:22
Upgrading and streaming replication Steve Crawford 21:22
Re: Upgrading and streaming replication Devrim GÜNDÜZ 21:44

Sept. 26, 2012

Thread Author Time
Re: WAL recovery failure Fujii Masao 00:01
Re: WAL recovery failure Rick Dicaire 01:56
Re: WAL recovery failure Albe Laurenz 09:21
Re: WAL recovery failure Rick Dicaire 11:35
Debian Squeeze - no xml support for Pg 9.2 Volkmar Herbst 18:07
Debian Squeeze - no xml support for Pg 9.2 Volkmar Herbst 18:11
Re: WAL Log Processing For OLAP? Cédric Villemain 22:12

Browse Archives

Prev | Next