Mailing lists [pgsql-admin]

1 July 2009

• 01:40   Re: terminate PG connections raghu ram
• 02:15   Re: Restiring pg_dump text file raghu ram
• 03:26   Re: Restiring pg_dump text file donghe@caltech.edu
• 03:36   Re: Restiring pg_dump text file Scott Mead
• 03:44   Re: how much memory (work_mem) is a query using? raghu ram
• 05:58   Re: Restiring pg_dump text file Scott Marlowe
• 20:13   Hot standby Mark Steben
• 20:13   Re: Restiring pg_dump text file Scott Mead
• 20:14   large cache Brian Modra
• 20:14   Restricting administrator's DB access Ankur Sam
• 20:21   Re: Hot standby Joshua D. Drake
• 20:40   DBA Opening Ray Galvin
• 21:31   Re: Restricting administrator's DB access Mike Ivanov

2 July 2009

• 13:32   Questions on setup and usage Michael Gould

3 July 2009

• 17:20   pg_check_queries.pl: an ineffective way to check for slow queries? Mark Stosberg
• 18:35   Re: pg_check_queries.pl: an ineffective way to check for slow queries? Kevin Grittner
• 21:35   Re: Statistical tracking issue Benjamin Krajmalnik
• 21:35   Statistical tracking issue Benjamin Krajmalnik

5 July 2009

• 20:02   Re: order by question Sergio Gabriel Rodriguez
• 20:59   Compile errors when building 32-bit on 64-bit system Andy Shellam
• 22:23   Re: Compile errors when building 32-bit on 64-bit system Tom Lane
• 22:29   Re: Compile errors when building 32-bit on 64-bit system Andy Shellam
• 22:34   Re: Compile errors when building 32-bit on 64-bit system Tom Lane
• 22:40   Re: Compile errors when building 32-bit on 64-bit system Andy Shellam

6 July 2009

• 04:43   REINDEX "is not a btree" Vanessa Lopez
• 04:44   Make the primary key a multilingual value Ransika de Silva
• 09:52   Re: order by question Harald Fuchs
• 12:35   Re: Make the primary key a multilingual value Peter Eisentraut
• 16:13   postgresql won't restart. Cannot allocate memory. Must reboot. Any alternative short of reboot? Mitchell Laks
• 16:58   Re: Questions on setup and usage Kevin Grittner
• 17:21   Re: Questions on setup and usage Kevin Grittner
• 18:23   Re: Questions on setup and usage Michael Gould
• 18:36   Re: Compile errors when building 32-bit on 64-bit system Andy Shellam
• 18:50   Re: Compile errors when building 32-bit on 64-bit system Tom Lane
• 18:50   Re: Compile errors when building 32-bit on 64-bit system Andy Shellam

7 July 2009

• 02:38   Catching up Production from Warm Standby after maintenance - Please help Jennifer Spencer
• 03:57   Catching up Production from Warm Standby after maintenance - Please help Jennifer Spencer
• 05:54   Re: Catching up Production from Warm Standby after maintenance - Please help Scott Marlowe
• 09:12   Re: Catching up Production from Warm Standby after maintenance - Please help Jennifer Spencer
• 11:33   Re: Catching up Production from Warm Standby after maintenance - Please help Scott Mead
• 15:22   Java Persistence and Partitioned Tables Affecting "Zero" Rows User
• 16:43   Re: Catching up Production from Warm Standby after maintenance - Please help Jennifer Spencer
• 16:53   Re: Catching up Production from Warm Standby after maintenance - Please help Kevin Grittner
• 17:02   Re: Catching up Production from Warm Standby after maintenance - Please help Jennifer Spencer
• 17:13   Re: Catching up Production from Warm Standby after maintenance - Please help Scott Marlowe
• 17:15   Re: Catching up Production from Warm Standby aftermaintenance - Please help Scott Marlowe
• 17:22   Re: Catching up Production from Warm Standby aftermaintenance - Please help Scott Whitney
• 17:35   Re: Catching up Production from Warm Standby aftermaintenance - Please help Scott Whitney
• 17:35   Re: Catching up Production from Warm Standby aftermaintenance - Please help Alvaro Herrera
• 17:41   Re: Catching up Production from Warm Standbyaftermaintenance - Please help Scott Whitney
• 17:43   Re: Catching up Production from Warm Standby aftermaintenance - Please help Jennifer Spencer
• 17:48   Re: Catching up Production from Warm Standbyaftermaintenance - Please help Lewis Kapell
• 17:52   Re: Catching up Production from Warm Standby aftermaintenance - Please help Scott Mead
• 17:52   Re: Catching up Production from Warm Standbyaftermaintenance - Please help Scott Mead
• 17:55   Re: Catching up Production from Warm Standby aftermaintenance - Please help Kevin Grittner
• 19:27   Concurrency question Mark Steben
• 19:45   Re: Catching up Production from Warm Standby after maintenance - Please help Scott Marlowe
• 19:53   Re: Catching up Production from Warm Standby after maintenance - Please help Scott Marlowe
• 20:24   Re: Concurrency question Scott Marlowe
• 21:41   Re: Concurrency question Tom Lane
• 22:05   Re: Concurrency question Scott Marlowe
• 22:12   Re: Concurrency question Tom Lane
• 22:58   Re: Catching up Production from Warm Standby after maintenance - Please help Jennifer Spencer

8 July 2009

• 00:17   Re: Concurrency question Greg Stark
• 02:17   Re: Catching up Production from Warm Standby after maintenance - Please help Scott Marlowe
• 15:53   Re: Catching up Production from Warm Standby after maintenance - Please help Kevin Grittner
• 16:02   Re: Catching up Production from Warm Standby after maintenance - Please help Kevin Grittner
• 16:44   Re: Catching up Production from Warm Standby after maintenance - Please help Chris Browne
• 18:04   Postgres 8.4 and PostGIS 1.3.6 installation Kasia Tuszynska
• 18:33   Re: Concurrency question Mark Steben
• 18:40   Direct Hire Position - PostgreSQL DBA Jennifer Haughs
• 18:51   Re: Direct Hire Position - PostgreSQL DBA Tom Lane
• 19:48   Problem with PAM/LDAP auth Thomas Kirchtag
• 22:18   Hard link / rsync backup strategy successful Kevin Grittner

9 July 2009

• 15:50   Re: Hard link / rsync backup strategy successful Alvaro Herrera
• 19:16   Installing Postgresql on Debian (-E parameter question) Panos Katergiathis
• 19:39   Re: Installing Postgresql on Debian (-E parameter question) Dimitri Fontaine
• 22:19   Setting Shared-Buffers Rafael Domiciano
• 22:29   Re: Setting Shared-Buffers Tino Schwarze

10 July 2009

• 00:05   Re: Setting Shared-Buffers Scott Mead
• 08:04   Setting kernel.shmmax fatih ozturk
• 08:21   Re: Setting kernel.shmmax Iñigo Martinez Lasala
• 12:26   Re: Setting Shared-Buffers Rafael Domiciano
• 13:50   Re: Setting Shared-Buffers Kevin Grittner
• 14:04   Re: Setting Shared-Buffers Tino Schwarze
• 14:16   Re: Setting Shared-Buffers Kevin Grittner
• 14:58   Re: Setting kernel.shmmax fatih ozturk
• 19:50   Re: Installing Postgresql on Debian (-E parameter question) Dimitri Fontaine
• 21:27   Re: Setting Shared-Buffers Anj Adu
• 21:31   Re: Setting kernel.shmmax Mike Ivanov

11 July 2009

• 02:04   Re: Setting Shared-Buffers Scott Marlowe
• 02:13   Re: Setting Shared-Buffers Scott Marlowe
• 05:19   Re: Setting Shared-Buffers Scott Marlowe
• 14:06   Re: Setting Shared-Buffers Iñigo Martinez Lasala

13 July 2009

• 07:27   Re: Catching up Production from Warm Standbyaftermaintenance - Please help Michael Monnerie
• 12:56   Re: Cannot compile pgadmin3-1.10.0-beta3 Ibrahim Shaame
• 15:03   Difficulty with make check Lasher, Glenn

14 July 2009

• 20:06   user connection properties Isabella Ghiurea
• 20:13   Re: user connection properties Alvaro Herrera
• 20:14   Re: user connection properties Scott Mead
• 20:15   ezSQL postgres connection string... Carol Walter
• 21:03   Re: Hard link / rsync backup strategy successful Chander Ganesan
• 21:14   Re: Hard link / rsync backup strategy successful Greg Spiegelberg

15 July 2009

• 02:47   Networking request Dirk E Zondag Jr
• 02:48   Re: Setting Shared-Buffers 
• 06:33   PostgreSQL/PAM problem Thomas Kirchtag
• 06:40   Re: PostgreSQL/PAM problem Tom Lane
• 11:52   Flush Shared Buffer Cache Suvankar Roy
• 13:53   Re: Difficulty with make check Alvaro Herrera
• 15:17   Re: PostgreSQL/PAM problem Scott Mead
• 15:18   Re: Flush Shared Buffer Cache Chander Ganesan
• 15:22   Re: Networking request Chander Ganesan
• 16:17   Old version? Carol Walter
• 16:22   Re: Old version? Alvaro Herrera
• 17:03   Re: Old version? Carol Walter
• 17:46   Re: Difficulty with make check Lasher, Glenn
• 18:40   Re: Old version? Chander Ganesan
• 19:12   out of memory for query, partitioning & vacuuming Lee, Mija
• 19:16   Re: out of memory for query, partitioning & vacuuming Scott Marlowe
• 19:18   Re: out of memory for query, partitioning & vacuuming Anj Adu
• 21:58   commit within function Anj Adu
• 22:02   Re: commit within function Scott Marlowe
• 22:17   Re: out of memory for query, partitioning & vacuuming Lee, Mija
• 22:45   pg_dump dumping out some irrelevant grants Chris Browne
• 22:57   Re: pg_dump dumping out some irrelevant grants Tom Lane

16 July 2009

• 01:36   Re: commit within function Anj Adu
• 02:34   Re: commit within function Scott Marlowe
• 02:36   Re: commit within function Scott Marlowe
• 03:09   initdb --encoding=LATIN1 fails on Windows Abraham, Danny
• 03:57   Where 8.4.0 binaries-no-installer for win32 dayat
• 05:23   Re: Flush Shared Buffer Cache Suvankar Roy
• 06:31   Re: Networking request Dirk E Zondag Jr
• 09:00   PostgreSQL using 100% CPU rasa
• 09:14   Re: Where 8.4.0 binaries-no-installer for win32 Andreas Wenk
• 13:57   Re: PostgreSQL using 100% CPU Emanuel Calvo Franco
• 15:27   Tests with switch of WAL segment files. J. Carlos Muro
• 15:42   Re: user connection properties Kevin Grittner
• 15:57   Re: user connection properties Isabella Ghiurea
• 17:06   Re: commit within function Scott Marlowe
• 17:18   Re: Where 8.4.0 binaries-no-installer for win32 Thomas Kellerer
• 17:20   Enhancement - code completion when typing set search_path Campbell, Lance
• 18:23   Re: Old version? Carol Walter
• 19:00   Re: user connection properties Kevin Grittner
• 19:03   Re: commit within function Scott Marlowe
• 19:15   Re: PostgreSQL using 100% CPU Scott Marlowe
• 19:18   how to REINDEX pg_database on Joshua Daniel Franklin
• 20:10   Re: initdb --encoding=LATIN1 fails on Windows Jan-Peter Seifert
• 20:15   convert an Insert Into... select from... to use COPY ? Kevin Kempter
• 21:07   Re: Flush Shared Buffer Cache Kevin Grittner
• 21:08   Re: convert an Insert Into... select from... to use COPY ? Tom Lane
• 21:20   Re: Hard link / rsync backup strategy successful Kevin Grittner
• 21:28   Re: Hard link / rsync backup strategy successful Kevin Grittner
• 22:19   Re: Hard link / rsync backup strategy successful Chander Ganesan
• 22:24   Re: Hard link / rsync backup strategy successful Kevin Grittner

17 July 2009

• 05:12   disable trigger all John Liu
• 09:17   Re: PostgreSQL using 100% CPU rasa
• 11:15   Re: Tests with switch of WAL segment files. J. Carlos Muro
• 13:18   Re: Enhancement - code completion when typing set search_path Andreas Wenk
• 14:30   8.4 contrib binaries Michael Gould
• 15:22   Re: Tests with switch of WAL segment files. Kevin Grittner
• 18:53   migrating from 8.1.x to 8.4 Anj Adu
• 18:58   Re: migrating from 8.1.x to 8.4 Joshua D. Drake
• 21:59   pgsnmpd Gergely CZUCZY

18 July 2009

• 00:37   pgsnmpd Gergely CZUCZY
• 00:37   One data dir and two servers Nikolai ZHUBR
• 02:48   Re: One data dir and two servers Scott Marlowe
• 06:37   Re: disable trigger all Scott Marlowe
• 15:36   Re: One data dir and two servers Scott Marlowe
• 20:37   Re: One data dir and two servers Nikolai ZHUBR
• 20:37   Re: One data dir and two servers Nikolai ZHUBR

19 July 2009

• 07:20   implement ldap authentication in PostgreSQL mitra nazemian
• 16:47   Re: PostgreSQL using 100% CPU Emanuel Calvo Franco

20 July 2009

• 07:54   Cannot create UTF8 database Ibrahim Shaame
• 11:50   Re: implement ldap authentication in PostgreSQL Andreas Wenk
• 14:00   Re: how to REINDEX pg_database on Joshua Daniel Franklin
• 15:41   Re: how to REINDEX pg_database on Alvaro Herrera
• 17:50   Re: how to REINDEX pg_database on Joshua Daniel Franklin
• 18:01   Re: how to REINDEX pg_database on Alvaro Herrera
• 18:02   Re: how to REINDEX pg_database on Tom Lane
• 18:25   Re: how to REINDEX pg_database on Joshua Daniel Franklin
• 18:33   migrating from 8.1.x to 8.2 Anj Adu
• 18:40   Re: migrating from 8.1.x to 8.2 Alvaro Herrera
• 20:39   Re: Setting Shared-Buffers Rafael Domiciano

21 July 2009

• 06:20   Re: Cannot create UTF8 database Ibrahim Shaame
• 08:25   Re: Cannot create UTF8 database raghu ram
• 10:30   Re: implement ldap authentication in PostgreSQL Andreas Wenk
• 10:42   Re: implement ldap authentication in PostgreSQL Andreas Wenk
• 13:42   Re: COUNT(DISTINCT field) OVER (PARTITION BY another_field) Daniel Cristian Cruz
• 14:19   COUNT(DISTINCT field) OVER (PARTITION BY another_field) Daniel Cristian Cruz
• 16:35   Cannot connect to postgresql Carol Walter
• 18:24   Re: Cannot connect to postgresql Kevin Kempter
• 18:53   First SV PostgreSQL Meetup Dan Bikle

22 July 2009

• 06:12   General queries regarding backup Deepak Bala
• 08:23   Re: implement ldap authentication in PostgreSQL mitra nazemian
• 08:40   Re: implement ldap authentication in PostgreSQL Andreas Wenk
• 08:40   complie postgresql with kerberos in centos rahimeh khodadadi
• 08:47   Re: implement ldap authentication in PostgreSQL mitra nazemian
• 09:01   Re: implement ldap authentication in PostgreSQL mitra nazemian
• 09:25   Re: implement ldap authentication in PostgreSQL Andreas Wenk
• 14:06   Re: complie postgresql with kerberos in centos Tom Lane
• 16:42   General queries regarding backup Deepak Bala

23 July 2009

• 04:29   Re: complie postgresql with kerberos in centos rahimeh khodadadi
• 19:22   pg_stat_activity reporting of VACUUM in 8.1 Kevin Kempter
• 19:55   autovacuum configuration Lee, Mija

24 July 2009

• 00:00   newbie Administrator Scott Holmes
• 00:13   Re: newbie Administrator Joshua D. Drake
• 00:25   Re: newbie Administrator Lacey Powers
• 03:08   Newbie Admin. Scott Holmes
• 07:14   Re: Cannot connect to postgresql Julius Tuskenis
• 17:00   Re: pg_stat_activity reporting of VACUUM in 8.1 Alvaro Herrera
• 17:40   Re: Cannot connect to postgresql Carol Walter

25 July 2009

• 07:03   Re: Cannot connect to postgresql Julius Tuskenis

26 July 2009

• 13:49   Re: complie postgresql with kerberos in centos rahimeh khodadadi
• 16:57   Re: complie postgresql with kerberos in centos Andreas Wenk

27 July 2009

• 02:44   Please, help me configuring RFT TRAN THI NGOC MAI
• 07:43   Slow adding Large Indexes Thorne, Francis
• 12:23   Re: complie postgresql with kerberos in centos Devrim GÜNDÜZ
• 12:24   Re: complie postgresql with kerberos in centos Devrim GÜNDÜZ
• 13:13   Re: complie postgresql with kerberos in centos Andreas Wenk
• 14:00   Re: Slow adding Large Indexes Tom Lane
• 14:03   Problem to compiling with SunStudio 
• 14:31   Re: Problem to compiling with SunStudio Tom Lane
• 14:33   Re: Slow adding Large Indexes Thorne, Francis
• 14:41   Re: Slow adding Large Indexes Tom Lane
• 15:41   Re: Please, help me configuring RFT Kevin Grittner
• 15:49   Re: Please, help me configuring RFT Tom Lane
• 17:09   Re: Cannot connect to postgresql - Problem solved - Why / How? Carol Walter
• 22:05   create of partition table slow Anj Adu

28 July 2009

• 03:33   force varchar column to be lowercase Kevin Kempter
• 07:52   WAL backup Albert Shih
• 10:15   Re: force varchar column to be lowercase Andreas Wenk
• 10:51   Re: force varchar column to be lowercase Greg Stark
• 11:11   Re: force varchar column to be lowercase Andreas Wenk
• 12:06   Re: WAL backup Greg Spiegelberg
• 12:23   Re: General queries regarding backup Deepak Bala
• 13:20   Re: WAL backup Albert Shih
• 19:34   Postgres/C'ish question Kristopher Kiger

29 July 2009

• 05:44   Problem to compiling with SunStudio 
• 07:16   Re: General queries regarding backup Peter Eisentraut
• 17:12   Off-topic - Hardware recommendation Benjamin Krajmalnik
• 17:17   Re: Off-topic - Hardware recommendation Alan McKay
• 17:28   Re: Off-topic - Hardware recommendation Kevin Grittner
• 17:49   Error in creating the backend query Benjamin Krajmalnik
• 19:04   Re: Off-topic - Hardware recommendation Michael Monnerie
• 21:21   Re: Error in creating the backend query Alvaro Herrera
• 21:26   Re: Error in creating the backend query Benjamin Krajmalnik
• 21:32   Re: Error in creating the backend query Tom Lane
• 21:33   Re: Error in creating the backend query Alvaro Herrera
• 21:49   Re: Error in creating the backend query Benjamin Krajmalnik
• 22:43   Re: Error in creating the backend query Tom Lane
• 23:00   Re: Error in creating the backend query Benjamin Krajmalnik

30 July 2009

• 00:39   Re: Error in creating the backend query Tom Lane
• 03:46   Re: General queries regarding backup Deepak Bala
• 21:48   Fix corrupt pg_toast table? Michael Clark
• 21:59   Re: Fix corrupt pg_toast table? Tom Lane

31 July 2009

• 06:41   Point in Time Recovery (WAL) archive_command ml ml
• 13:46   Re: Point in Time Recovery (WAL) archive_command Kevin Grittner
• 14:18   Replication for R/W offline use Gábor SZŰCS
• 18:00   Re: Replication for R/W offline use Greg Sabino Mullane
• 19:01   Re: Fix corrupt pg_toast table? Michael Clark
• 21:22   Re: out of memory Fabricio
• 21:26   Re: Fix corrupt pg_toast table? Greg Stark
• 22:57   Re: Fix corrupt pg_toast table? Michael Clark
• 23:18   Re: Fix corrupt pg_toast table? Tom Lane