Home > mailing lists

Mailing lists [pgsql-admin]

1 February 2006

00:04 where i can find ? slackman@unika.ac.id
01:15 Re: where i can find ? Michael Fuhr
01:21 Re: where i can find ? Guido Barosio
06:36 Re: query to select the table primary key column name Düster Horst
08:00 Navicat PostgreSQL Manager for Mac OS X (ver. 6.1.3) is now available navicat
16:29 Re: [HACKERS] autovacuum Alvaro Herrera
16:36 Re: autovacuum Chris Browne
16:43 Re: [HACKERS] autovacuum Matthew T. O'Connor
17:21 Re: [HACKERS] autovacuum Tom Lane
20:06 Re: autovacuum Chris Browne
20:16 Default autovacuum settings too conservative Jim C. Nasby
20:21 Re: autovacuum Jim C. Nasby
20:37 Re: [PERFORM] Default autovacuum settings too conservative Matthew T. O'Connor

2 February 2006

02:06 Re: autovacuum Christopher Browne
02:45 is there any missing ?? slackman@unika.ac.id
02:57 is there anything wrong in my configuration??? slackman@unika.ac.id
12:07 Re: is there any missing ?? Dario Brignardello
14:56 pg_stat_activity Cédric BUSCHINI
14:58 Postmaster errors mcelroy, tim
15:01 Re: pg_stat_activity Brad Nicholson
15:10 Re: Postmaster errors Michael Fuhr
15:19 Re: pg_stat_activity Tom Lane
15:27 Re: pg_stat_activity Cédric BUSCHINI
16:18 strange hung processes Jeremy Ashcraft
16:32 Re: strange hung processes Jeremy Ashcraft
16:34 Re: Postmaster errors mcelroy, tim
17:05 Re: Postmaster errors Michael Fuhr
17:06 Re: Postmaster errors mcelroy, tim
17:40 Re: strange hung processes Ben Kim
18:40 Re: strange hung processes Larry Rosenman
19:23 Re: strange hung processes Jeremy Ashcraft

3 February 2006

01:10 Re: is there any missing ?? slackman@unika.ac.id
02:17 Re: is there any missing ?? Michael Fuhr
03:47 Re: strange hung processes Tom Lane
22:48 su-like behavior David Lutterkort

4 February 2006

01:44 Re: su-like behavior Bruno Wolff III
03:04 Re: su-like behavior Alvaro Herrera
08:15 autovacuum Alp UYANIK
14:06 Re: autovacuum Christopher Browne
18:12 Re: autovacuum Tom Lane
19:56 Installation problem question Luba Alpin
21:55 Postgres 8.1.x and MIT Kerberos 5 Mohan Anon

5 February 2006

01:38 Help Enzo Daddario
02:14 Re: Help Tom Lane
11:14 Re: Postgres 8.1.x and MIT Kerberos 5 Magnus Hagander
14:50 Re: [HACKERS] Postgres 8.1.x and MIT Kerberos 5 Stephen Frost
14:57 Re: [HACKERS] Postgres 8.1.x and MIT Kerberos 5 Magnus Hagander

6 February 2006

07:06 Re: Run external program on a trigger? Peter Eisentraut
07:06 Re: Online Backup and WAL archives Tom Lane
07:08 Re: Convenient dump of table and object size in PG 7.4 Tom Lane
07:08 Re: reading vacuum verbose output Tom Lane
07:09 Re: FATAL: invalid value for parameter "wal_sync_method": Scott Marlowe
07:10 Re: caching table/query Michael Fuhr
07:10 Re: caching table/query Chris Travers
07:10 Re: caching table/query Michael Fuhr
07:13 pgAdminII download Tomas Kratochvil
09:26 Actual expression of a constraint lrotger
11:36 Re: pgAdminII download Magnus Hagander
14:10 Re: Postgres 8.1.x and MIT Kerberos 5 Mohan K
14:20 Re: Postgres 8.1.x and MIT Kerberos 5 Magnus Hagander
14:50 Re: Postgres 8.1.x and MIT Kerberos 5 Mohan K
16:11 Re: Postgres 8.1.x and MIT Kerberos 5 Peter Eisentraut
16:44 Re: Postgres 8.1.x and MIT Kerberos 5 Mohan K
17:05 Re: Actual expression of a constraint Tom Lane
17:37 Re: autovacuum Scott Marlowe

7 February 2006

00:33 Re: [HACKERS] Postgres 8.1.x and MIT Kerberos 5 Bruce Momjian
04:05 Re: [PERFORM] Default autovacuum settings too conservative Jim C. Nasby
05:36 Re: is there anything wrong in my configuration??? Jim C. Nasby
14:33 Re: Actual expression of a constraint lrotger
15:01 Re: Actual expression of a constraint Tom Lane
15:51 Re: Actual expression of a constraint lrotger
17:16 Re: Actual expression of a constraint Tom Lane
17:20 PostgreSQL 8.1 x86_64 and 32bit shared objects CG
17:38 Re: PostgreSQL 8.1 x86_64 and 32bit shared objects Tom Lane
19:02 Re: PostgreSQL 8.1 x86_64 and 32bit shared objects CG
19:11 Re: PostgreSQL 8.1 x86_64 and 32bit shared objects Tom Lane
20:48 Re: Actual expression of a constraint Alvaro Herrera
22:09 Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Colin Freas
22:27 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Joshua D. Drake
22:43 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Devrim GUNDUZ

8 February 2006

04:29 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Tom Lane
04:37 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Tom Lane
09:36 Re: Actual expression of a constraint lrotger
10:29 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Bradley Kieser
14:59 Re: Actual expression of a constraint Kris Deugau
17:58 Manipulating pg_hba.conf David Lutterkort
18:59 Cross schema Primary Key Indexes problem with datatype in the public schema CG
20:37 auth methods David Bear
20:46 Re: auth methods Stephen Frost
23:28 db user named 'root' Atul Shah
23:43 Re: db user named 'root' Tom Lane

9 February 2006

19:04 Upgrading O/S requires Postgres re-build? Tomeh, Husam
21:58 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Dominik Składanowski
22:07 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Devrim GUNDUZ
22:08 Re: Upgrading O/S requires Postgres re-build? Chris Browne
22:31 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Dominik Składanowski

10 February 2006

00:10 Need query parameter in logs Robert Perry
07:38 Migration James Dey
07:44 Re: Migration Devrim GUNDUZ
07:51 Re: Migration James Dey
07:58 Re: Migration Devrim GUNDUZ
09:18 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Bradley Kieser
09:20 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Bradley Kieser
10:16 Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM Devrim GUNDUZ
12:35 HELP Marcos de Lima Takayas
13:16 Postgresql performance and tuning questions Given, Robert A
13:18 Re: HELP Marcos de Lima Takayas
14:14 Re: HELP Stef
14:16 Re: Postgresql performance and tuning questions Tom Lane
14:43 Re: Postgresql performance and tuning questions Given, Robert A
15:04 Is the database being VACUUMed? C. Bensend
15:16 Re: Postgresql performance and tuning questions Tom Lane
15:16 Re: Postgresql performance and tuning questions Scott Marlowe
19:41 performance question related to pgsql david drummard
19:45 Re: performance question related to pgsql Stephen Frost
20:08 Re: Is the database being VACUUMed? Chris Browne
20:13 Re: Is the database being VACUUMed? C. Bensend
20:19 Re: Is the database being VACUUMed? Brad Nicholson
20:26 Re: performance question related to pgsql david drummard
20:32 Re: Is the database being VACUUMed? C. Bensend
23:03 Re: performance question related to pgsql Stephen Frost

11 February 2006

00:47 gepo optimizer question uwcssa
01:04 Pg 7.4 to 8.1 UTF problems Mario Splivalo
01:04 Re: vacuum taking longer over time Matthew T. O'Connor
01:04 Re: How to compare the schemas ? Peter Eisentraut
01:04 Re: where with NULL values are not selected Dawid Kuroczko
01:04 Re: Stripping raid vs. table spaces Scott Marlowe
01:04 Re: How to compare the schemas ? Scott Marlowe
01:04 Re: change existing table definition Chuming Chen
01:04 Re: PGSQL 7.4.8 : idle in transaction problem imi
01:04 Re: Regarding a backup scenario Thomas F. O'Connell
01:04 Re: caching table/query Tsirkin Evgeny
01:05 Re: 7.4 <-> 8.0 Peter Childs
01:06 Re: How may I set LC_COLLATE and LC_CTYPE to Russian_Russia.1251 on Fedora Core Linux? Peter Eisentraut
01:06 Re: Disabling WAL for bulk data loads Tom Lane
01:06 Re: How to determine date / time of last postmaster restart Tom Lane
01:06 Re: Alter Table vs. Rename/Create/Drop table with plpgsql functions. Jaime Casanova
01:06 Re: caching table/query Tsirkin Evgeny
01:06 Re: caching table/query Chris Travers
01:08 Re: backing up without lock ? Martin Fandel
01:08 Re: HELP Stef
01:08 Statement duration reporting Erik G. Burrows
01:08 Could not start the PostgreSQL Database Server [version # inserted here] service on local computer Vinicius Ferreira
02:15 How to VACUUM this table? "998994633 estimated total rows" Aldor
04:19 Writing to a flat file using procedures Nalin Bakshi
14:49 Re: Pg 7.4 to 8.1 UTF problems Josh O'Brien
14:56 Re: Could not start the PostgreSQL Database Server [version # inserted here] service on local computer Magnus Hagander
15:14 Re: Pg 7.4 to 8.1 UTF problems Tom Lane
15:19 Ancient messages regurgitated into pgsql-admin, again Tom Lane
15:23 Re: Statement duration reporting Tom Lane
17:49 Re: Postgresql performance and tuning questions lst_hoe01@kwsoft.de
23:10 Re: Writing to a flat file using procedures Jim C. Nasby
23:46 Re: Postgresql performance and tuning questions Tom Lane

12 February 2006

01:09 Re: How to VACUUM this table? "998994633 estimated total rows" Chris Browne
09:47 Switch log (WAL) postgres@pivert.org

13 February 2006

00:00 Change port number Rodrigo Sakai
00:03 Re: Change port number Joshua D. Drake
00:13 Re: Change port number Tom Lane
07:59 Re: Need query parameter in logs Tsirkin Evgeny
11:35 Re: How to VACUUM this table? "998994633 estimated total rows" Guido Barosio
13:50 constraint_exclusion on OLTP tables Chris Hoover
14:02 Re: constraint_exclusion on OLTP tables Tom Lane
14:09 Re: How to VACUUM this table? "998994633 estimated total rows" Chris Browne
15:42 Lost tables in Postgres 7.1 Steve Burrows
15:42 vacuumdb Juliano
16:25 Re: Lost tables in Postgres 7.1 Tom Lane
16:43 Re: Switch log (WAL) Jim C. Nasby
16:46 Re: vacuumdb Jim C. Nasby
19:41 Re: vacuumdb Guido Barosio
19:44 to_date Jim Fu
19:45 Re: How to VACUUM this table? "998994633 estimated total rows" Guido Barosio
20:12 Re: to_date Michael Fuhr
20:22 Re: to_date Jim Fu
20:26 Re: to_date Scott Marlowe
21:52 Re: Switch log (WAL) postgres@pivert.org
22:18 Re: to_date Goulet, Dick

14 February 2006

00:13 Re: to_date Michael Fuhr
10:38 pg_xlog location Arnau
12:40 Re: Change port number Christopher Browne
13:25 Possible to check integrity of restored database? Mike Lott
14:09 Re: pg_xlog location Tom Lane
14:43 Wich systema catalog table?? Rodrigo Katsumoto Sakai
14:56 Re: Wich systema catalog table?? Guido Barosio
22:48 Re: Wich systema catalog table?? Alvaro Herrera

15 February 2006

00:42 Feedback on auto-pruning approach Mark Liberman
02:33 Re: Feedback on auto-pruning approach Tom Lane
02:52 hba conf ident sameuser not working David Bear
09:27 Re: hba conf ident sameuser not working Peter Eisentraut
09:40 how test postgresql.conf settings? Arnau
09:48 Best filesystem Arnau
12:10 Re: Best filesystem Christopher Browne
13:57 making duplicate of database for development Tilman Baumann
14:08 Re: making duplicate of database for development Tilman Baumann
20:20 Re: constraint_exclusion on OLTP tables Simon Riggs
20:22 Re: Switch log (WAL) Simon Riggs
23:37 Re: hba conf ident sameuser not working David Bear

16 February 2006

01:00 Re: hba conf ident sameuser not working Tom Lane
14:36 Dropping of indexes with cached PL query plans Jerry Sievers
15:13 Re: Dropping of indexes with cached PL query plans Tom Lane
15:39 Re: Postgresql performance and tuning questions Tomeh, Husam
16:14 Re: Dropping of indexes with cached PL query plans Jerry Sievers
16:29 Re: hba conf ident sameuser not working David Bear
17:21 Trouble starting server Barry Moore
17:31 Re: Trouble starting server Jeff Frost
17:31 Re: Switch log (WAL) RW
18:02 Re: Trouble starting server Barry Moore
19:14 Re: Postgresql performance and tuning questions Scott Marlowe

17 February 2006

02:37 Re: Postgresql performance and tuning questions Ang Chin Han
04:11 Something like pg_dump for 7.4 Gregory S. Williamson
05:19 Re: Something like pg_dump for 7.4 Tom Lane
06:49 Re: Something like pg_dump for 7.4 Artur Pietruk
07:58 Re: Something like pg_dump for 7.4 Gregory S. Williamson
08:42 WAL archive stopping too early Andy Shellam
11:33 Re: Something like pg_dump for 7.4 Gregory S. Williamson
13:47 Announcement regarding GBorg project citext Donald Fraser
13:50 Re: Something like pg_dump for 7.4 Tom Lane
13:55 Re: WAL archive stopping too early Tom Lane
14:02 Re: WAL archive stopping too early Andy Shellam
14:06 Re: WAL archive stopping too early Alvaro Herrera

18 February 2006

01:40 Unrecognized service: 8.1.3 on Fedora Core 3 François
02:59 Re: Ancient messages regurgitated into pgsql-admin, again Tsirkin Evgeny
03:00 Re: Ancient messages regurgitated into pgsql-admin, again Tsirkin Evgeny
03:01 A question about differences between createdb and "create database" Paul Vogel
03:01 Best filesystem Arnau Rebassa Villalonga
03:01 how test postgresql.conf settings? Arnau Rebassa Villalonga
05:02 Re: A question about differences between createdb and "create database" Tom Lane
05:20 Re: Unrecognized service: 8.1.3 on Fedora Core 3 Tom Lane
05:45 Re: Unrecognized service: 8.1.3 on Fedora Core 3 François
06:38 PGOLEDB Problems fathur rohman
06:40 Function Parameter Problem fathur rohman
06:42 Trigger and PL Registration Problem fathur rohman
17:16 Re: Function Parameter Problem Tom Lane

19 February 2006

02:44 Re: how test postgresql.conf settings? Chandra Sekhar Surapaneni
03:06 Re: how test postgresql.conf settings? Joshua D. Drake

20 February 2006

03:27 Re: Function Parameter Problem fathur rohman
07:33 Re: Function Parameter Problem Milorad Poluga
12:29 Temporal Databases Rodrigo Sakai
14:08 Re: Temporal Databases Richard Broersma Jr
15:12 Re: Best filesystem Chris Browne

21 February 2006

06:02 Delete performance adey
08:22 Disk crash problems: postgres database not functioning anymore Joost Kraaijeveld
11:04 problems to install PostgreSQL Paolo De Simone
11:09 Re: problems to install PostgreSQL sandhya
11:57 Re: Disk crash problems: postgres database not functioning anymore Alvaro Herrera
13:51 Re: problems to install PostgreSQL Anjan Dave
14:01 Re: Delete performance Tom Lane
15:46 Installing my PostgreSQL client richard.hardgrave@emersonnetworkpower.com
20:14 binary data types and streaming David Durham
20:31 Re: binary data types and streaming Peter Eisentraut
22:43 Re: binary data types and streaming David Durham

22 February 2006

04:51 ... sagar KUDALE
04:56 rohan rasane
08:00 Re: binary data types and streaming Dennis Wagner
08:03 Re: how test postgresql.conf settings? Arnau
08:09 Re: Delete performance Arnau
08:49 Installation Postgres 8.1.3 on Linux Suse 9.1 Moritz Bayer
08:55 Re: Installation Postgres 8.1.3 on Linux Suse 9.1 Hakan Kocaman
08:59 Re: Installation Postgres 8.1.3 on Linux Suse 9.1 Andy Shellam
09:52 Re: Installation Postgres 8.1.3 on Linux Suse 9.1 Peter Eisentraut
11:55 Re: Installation Postgres 8.1.3 on Linux Suse 9.1 Andy Shellam
12:58 unsubscribe Jayaram Bhat
13:31 Re: Delete performance Tom Lane
14:26 WARNING: foreign key constraint will require costly sequential scans during pg_restore CG
14:30 Re: WARNING: foreign key constraint will require costly sequential scans during pg_restore Tom Lane
15:26 WAL recovery Andy Shellam
15:45 broken restore.sql script !? Christian Sengstock
16:00 Re: broken restore.sql script !? Tom Lane
16:23 Re: WAL recovery Jeff Frost
17:03 Re: broken restore.sql script !? Christian Sengstock
17:59 Re: broken restore.sql script !? Tom Lane
18:55 Re: WAL recovery CG
19:04 Re: WAL recovery Joshua D. Drake

23 February 2006

07:21 large object unlinking sandhya
07:32 8.0.3 pg_autovacuum doesn't clear out stats table? Robin Iddon
09:27 Re: Delete performance Arnau
13:26 Re: WAL recovery Simon Riggs
14:28 Re: large object unlinking Michael Fuhr
15:18 Re: WAL recovery Andy Shellam
15:24 Deinstallation Moritz Bayer
15:28 Re: Deinstallation Andy Shellam
15:35 Re: Delete performance Tom Lane
15:45 Re: Delete performance Arnau
15:52 Re: WAL recovery Simon Riggs
17:32 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Robin Iddon
17:54 how to use PostGIS with Postgres Yantao Shi
18:04 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Robin Iddon
18:43 PGPASSWORD Mr. Dan
18:48 ERROR: Cannot determine geometry type (empty table). Sunanda Kumaraguru
19:30 Re: problems to install PostgreSQL Tomeh, Husam
19:44 Re: PGPASSWORD Milen A. Radev
19:55 Re: PGPASSWORD Mr. Dan
20:18 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Jim C. Nasby
20:21 Re: how to use PostGIS with Postgres Jim C. Nasby
20:23 Re: PGPASSWORD Jim C. Nasby
20:39 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Tom Lane
20:40 Re: how to use PostGIS with Postgres Michael Fuhr
20:46 Re: PGPASSWORD Tom Lane
20:51 Re: ERROR: Cannot determine geometry type (empty table). Jim C. Nasby
20:55 Re: ERROR: Cannot determine geometry type (empty table). Michael Fuhr
21:08 Re: ERROR: Cannot determine geometry type (empty table). Michael Fuhr
22:08 Re: PGPASSWORD Andy Shellam
22:23 Re: Deinstallation Andy Shellam
22:34 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Robin Iddon
22:43 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Jim C. Nasby
22:44 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Robin Iddon
22:49 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Jim C. Nasby
22:49 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Robin Iddon
22:58 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Jim C. Nasby

24 February 2006

05:23 Re: large object unlinking sandhya
06:14 Re: large object unlinking Michael Fuhr
13:26 Multiplequeries sandhya
21:00 pgStatTuple Lane Van Ingen
22:13 Re: pgStatTuple Michael Fuhr

25 February 2006

07:15 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Robin Iddon
22:00 Re: 8.0.3 pg_autovacuum doesn't clear out stats table? Jim C. Nasby

27 February 2006

04:38 Reg: Multiplequeries pls help me sandhya
05:03 Re: Reg: Multiplequeries pls help me Michael Fuhr
11:16 Priviliges and Roles Dayo Johnson
11:22 Re: Priviliges and Roles CaT
11:22 Re: Priviliges and Roles Andy Shellam
12:28 Re: pgStatTuple Lane Van Ingen
12:40 Re: Priviliges and Roles Dayo Johnson
17:29 Re: Priviliges and Roles Bruno Wolff III
22:22 Security / Annoucements List August Zajonc
23:40 Re: Security / Annoucements List Marc G. Fournier

28 February 2006

00:56 Re: Security / Annoucements List August Zajonc
07:01 Problem in date function Ramesh Patel
11:44 Re: Security / Annoucements List Guido Barosio
12:01 how to create new user Mohamed Fazil
13:24 Re: Problem in date function Jason Minion
14:53 pg_diff, or something like it...? Mario Splivalo
19:44 Re: how to create new user Magnus Hagander