Mailing lists [pgsql-admin]

1 July 2005

• 05:37   Query on pg_dump manikeshwari prasad bohidar
• 09:07   Re: restore database from bare files jehan procaccia
• 13:08   encoding converting from ascii to unicode Joel Fradkin
• 13:31   Re: restore database from bare files Ben Kim
• 13:52   replication for hot-standby? Hannes Dorbath
• 18:29   Re: encoding converting from ascii to unicode (I got it Joel Fradkin

2 July 2005

• 11:29   Re: replication for hot-standby? Martin Fandel
• 12:02   Help needed to set the Optimal Value for shared_buffers. Kishore B
• 13:52   Re: Help needed to set the Optimal Value for shared_buffers. Tom Lane

3 July 2005

• 04:45   database size after a DELETE and VACUUM Mike.Samson@apcc.com
• 14:23   Re: database size after a DELETE and VACUUM Michael Fuhr
• 17:52   Re: database size after a DELETE and VACUUM Christopher Browne
• 22:24   Some Tip: take care to run routine vacuum as superuser ... Enrico Weigelt

4 July 2005

• 07:51   Still the 1069 logon problem Dimmel Friedrich
• 07:58   initdb problem at postgres install kalyanaraman rajaraman
• 09:26   Re: Still the 1069 logon problem Gevik babakhani
• 10:57   Re: Still the 1069 logon problem Michiel Lange
• 14:12   Re: initdb problem at postgres install Tom Lane
• 17:23   Re: restore database from bare files jehan procaccia
• 19:37   Re: replication for hot-standby? Brad Nicholson
• 22:07   Why file pgsql does not grow??? Dante Almonte

5 July 2005

• 08:22   Re: replication for hot-standby? Hannes Dorbath
• 08:28   Fw: reg libpqxx for windows sandhya
• 15:09   Re: replication for hot-standby? Brad Nicholson
• 16:51   Re: replication for hot-standby? Bruce Momjian
• 18:27   problems with pgadmin 3 jose fuenmayor
• 22:46   Batch Scripting of DB Objects to Separate Files Mike Fahrenkrog

6 July 2005

• 09:24   libpqxx on windows sandhya
• 18:36   Desparate: Lost WAL files Richard Doust
• 18:52   Re: Desparate: Lost WAL files Joshua D. Drake
• 18:53   Re: Desparate: Lost WAL files Bruce Momjian
• 18:59   Re: Desparate: Lost WAL files Richard Doust
• 19:03   Re: Desparate: Lost WAL files Joshua D. Drake
• 19:08   Re: Desparate: Lost WAL files Richard Doust
• 19:09   Re: Desparate: Lost WAL files Joshua D. Drake
• 21:06   RPM for Fedora Core 1 on i586 hardware vilson.farias
• 21:23   Re: RPM for Fedora Core 1 on i586 hardware Joshua D. Drake
• 21:41   Re: RPM for Fedora Core 1 on i586 hardware Devrim GUNDUZ
• 22:46   Re: problem with WAL files Jeff Frost
• 23:00   Re: problem with WAL files Bruce Momjian
• 23:01   Re: problem with WAL files Jeff Frost
• 23:06   Re: problem with WAL files Bruce Momjian
• 23:14   Re: problem with WAL files Jeff Frost

7 July 2005

• 01:08   installing postgres on solaris Mogin Mohandas
• 01:19   Re: installing postgres on solaris Joshua D. Drake
• 01:26   Re: installing postgres on solaris Michael Fuhr
• 01:36   Re: installing postgres on solaris Jonathan Daugherty
• 03:41   doubt Mogin Mohandas
• 03:52   Re: doubt Joshua D. Drake
• 04:16   Re: installing postgres on solaris Michael Fuhr
• 05:06   Re: doubt Dong B. Calmada
• 06:07   Re: doubt Joshua D. Drake
• 06:18   Re: doubt Jonathan Daugherty
• 06:23   Re: doubt Dong B. Calmada
• 06:29   Re: doubt Joshua D. Drake
• 12:47   Re: RPM for Fedora Core 1 on i586 hardware vilson.farias
• 12:51   Re: RPM for Fedora Core 1 on i586 hardware Devrim GUNDUZ

8 July 2005

• 08:18   doubt Mogin Mohandas
• 09:09   where with NULL values are not selected Düster Horst
• 09:55   Re: where with NULL values are not selected Peter Eisentraut
• 10:08   Re: where with NULL values are not selected Dawid Kuroczko
• 14:32   Re: where with NULL values are not selected Enrico Weigelt
• 19:50   Regarding backups nandan bsd
• 20:14   Re: Regarding backups Bruno Wolff III

11 July 2005

• 06:58   Regarding a backup scenario nandan bsd
• 09:29   Re: where with NULL values are not selected Düster Horst
• 14:22   ... Aris Aridis
• 15:00   Re: Benjamin GASSMANN
• 20:21   privilege & user Lee Wu
• 20:33   Re: privilege & user Alvaro Herrera

12 July 2005

• 12:58   Re: Regarding a backup scenario Thomas F. O'Connell
• 18:59   How to list user accounts? Thanh Q Lam
• 19:10   Re: How to list user accounts? Bruno Wolff III
• 19:12   Re: How to list user accounts? Scott Marlowe
• 19:17   Re: How to list user accounts? Michael Fuhr
• 23:40   Help for postgresql binary installation v.8.0.3 Jana Nguyen

13 July 2005

• 01:16   Specified driver could not be loaded due to system error 998 (PostgreSQL). Joel Fradkin
• 04:04   got my odbc working(re-loaded mdac as well as postgres) but it started working after I added a dsn (not using a dsn connection though so odd) Joel Fradkin
• 05:47   Postgres service user keeps losing password Karim Mardhani
• 06:27   Re: Help for postgresql binary installation v.8.0.3 Devrim GUNDUZ
• 12:16   procedural languages and public schema Francesco Dalla Ca'
• 14:20   Re: procedural languages and public schema Tom Lane
• 15:42   7.3 and user permissions Chris Hoover
• 16:49   Re: 7.3 and user permissions Tom Lane
• 18:46   Changing Ben Kim
• 23:31   Re: Help for postgresql binary installation v.8.0.3 Jana Nguyen

14 July 2005

• 00:03   Re: Help for postgresql binary installation v.8.0.3 Devrim GUNDUZ
• 05:12   Regarding backups devaki nandan
• 05:13   Anyone running PostgreSQL on Sun Solaris? Chris Hoover
• 05:13   LOOP and EXIT Sebastian Kühner
• 05:13   ERROR: Bogus amopstrategy number 2439 for opclass 1989 prav maha
• 05:21   functions vs stored procedures Ezequiel Tolnay
• 05:21   query concerning vacuum and tablespaces Colton Smith
• 05:22   Import Oracle to Postgres 
• 05:37   Re: Anyone running PostgreSQL on Sun Solaris? Marc McIntyre
• 06:09   Re: Anyone running PostgreSQL on Sun Solaris? Rainer J. H. Brandt
• 07:00   Re: Anyone running PostgreSQL on Sun Solaris? Marc McIntyre
• 13:17   Re: functions vs stored procedures Tom Lane
• 14:29   Re: LOOP and EXIT Stephan Szabo
• 14:59   Re: Import Oracle to Postgres Thomas Pundt
• 20:49   Error message: cannot identify operator 184 Chris White (cjwhite)
• 22:32   Re: Error message: cannot identify operator 184 Michael Fuhr
• 22:33   Re: Error message: cannot identify operator 184 Chris White (cjwhite)
• 22:38   Re: Error message: cannot identify operator 184 Chris White (cjwhite)

15 July 2005

• 03:08   Re: Error message: cannot identify operator 184 Michael Fuhr
• 04:42   Re: functions vs stored procedures Ezequiel Tolnay
• 04:42   pg_restore hangs on 'some' HP-UX machines Gopal Srinivasa
• 04:42   Install Problem on Windows XP Home - Password Issue Patrick Isaac
• 05:21   Re: Error message: cannot identify operator 184 Tom Lane
• 13:16   Re: functions vs stored procedures Alvaro Herrera
• 22:05   Re: pg_restore hangs on 'some' HP-UX machines Chris Travers

17 July 2005

• 10:56   caching table/query Tsirkin Evgeny
• 14:07   Re: caching table/query Michael Fuhr
• 14:55   Re: caching table/query Tsirkin Evgeny
• 15:53   Re: caching table/query Tom Lane
• 20:40   Re: Install Problem on Windows XP Home - Password Issue Magnus Hagander

18 July 2005

• 06:32   Re: caching table/query Tsirkin Evgeny
• 10:09   Statement logging per connection KÖPFERL Robert
• 11:09   unsubscribe Luiz Fernando de Menezes Calabria
• 17:26   backing up without lock ? FM
• 17:33   unable to configure Mogin Mohandas
• 17:51   Re: backing up without lock ? Scott Marlowe
• 17:58   Re: backing up without lock ? Scott Marlowe
• 21:46   Re: unable to configure Martin Fandel

19 July 2005

• 08:07   Mirroring problem with PostgreSQL Shashi Kanth Boddula
• 09:03   dump/restore needed when switching from 32bit to 64bit processor architecture? Dirk Lutzebäck
• 13:26   Re: backing up without lock ? Martin Fandel
• 14:05   Re: dump/restore needed when switching from 32bit to 64bit processor architecture? Tom Lane
• 14:30   how to build vsftpd with pgsql pam guly
• 16:21   how to load a .backup file Alain Rodriguez Arias
• 16:49   Re: how to load a .backup file Guido Barosio
• 17:49   Re: dump/restore needed when switching from 32bit to 64bit Dirk Lutzebäck
• 19:50   PGSQL 7.4.8 : idle in transaction problem FM
• 20:28   Re: dump/restore needed when switching from 32bit to 64bit Peter Eisentraut
• 20:30   Re: PGSQL 7.4.8 : idle in transaction problem Peter Eisentraut
• 20:33   Re: Mirroring problem with PostgreSQL Peter Eisentraut

20 July 2005

• 02:45   Re: PGSQL 7.4.8 : idle in transaction problem Tom Lane
• 03:31   can not start the postgresql, i use gentoo guo weidong
• 05:11   Re: PGSQL 7.4.8 : idle in transaction problem Alvaro Herrera
• 06:10   Re: can not start the postgresql, i use gentoo Peter Eisentraut
• 06:29   Re: PGSQL 7.4.8 : idle in transaction problem imi
• 07:15   Re: can not start the postgresql, i use gentoo Andy
• 07:22   Re: caching table/query Tsirkin Evgeny
• 07:52   Re: can not start the postgresql, i use gentoo Tsirkin Evgeny
• 08:50   Add new column Rafal Kedziorski
• 09:05   Re: Add new column Dawid Kuroczko
• 09:24   Re: backing up without lock ? Dawid Kuroczko
• 09:54   Re: caching table/query Michael Fuhr
• 11:26   su permission denied 梁炳場
• 11:38   Re: su permission denied Pascual De Ruvo
• 12:58   Re: Add new column Goulet, Dick
• 13:25   Determine PG version used for initdb Hannes Dorbath
• 13:35   Re: PGSQL 7.4.8 : idle in transaction problem Tom Lane
• 13:40   Re: Determine PG version used for initdb Joshua D. Drake
• 13:49   Re: Determine PG version used for initdb Hannes Dorbath
• 13:55   Re: Determine PG version used for initdb Dario
• 14:05   Re: Determine PG version used for initdb Tom Lane
• 14:19   Re: Determine PG version used for initdb Hannes Dorbath
• 14:19   Re: Determine PG version used for initdb Hannes Dorbath
• 14:32   Re: Determine PG version used for initdb Joel Fradkin
• 14:44   Re: Determine PG version used for initdb Michael Fuhr
• 14:49   Re: Determine PG version used for initdb Hannes Dorbath
• 15:59   Re: Determine PG version used for initdb Jim C. Nasby
• 17:49   Re: caching table/query Chris Travers
• 17:50   Re: Determine PG version used for initdb Michael Fuhr
• 20:28   FATAL: could not read statistics message Alexander Stanier
• 21:58   Re: can not start the postgresql, i use gentoo Guido Barosio
• 22:04   Re: Add new column Guido Barosio
• 22:17   Problems with starting/stoping Postmaster if homedir is not available Marco Lechner

21 July 2005

• 05:14   Re: FATAL: could not read statistics message Tom Lane
• 10:19   writer process hangs??? Andy
• 12:24   mirror for gborg.postgresql.org? Palle Girgensohn
• 12:44   Re: mirror for gborg.postgresql.org? Magnus Hagander
• 14:08   Re: mirror for gborg.postgresql.org? Palle Girgensohn
• 14:22   Re: FATAL: could not read statistics message Alexander Stanier
• 14:46   Re: PGSQL 7.4.8 : idle in transaction problem Brad Nicholson
• 14:50   Re: Statement logging per connection Bruce Momjian
• 15:37   N-to-N implementation Filipe Knoedt
• 16:02   Re: N-to-N implementation Oleg Bartunov
• 16:11   Re: PGSQL 7.4.8 : idle in transaction problem Alvaro Herrera

22 July 2005

• 12:01   Error: No se pudo localizar un registro de checkpoint valido ¿ Como soluciono ? Fabio C. Bon
• 12:15   Re: [ADMIN] Error: No se pudo localizar un registro de checkpoint valido ¿ Como soluciono ? Andy
• 12:47   RE: [ADMIN] Re: [ADMIN] Error: No se pudo localizar un registro de checkpoint valido ¿ Como soluciono ? Fabio C. Bon

24 July 2005

• 13:59   su: /bin/bsh Permission denied 梁炳場
• 15:36    Mark P Anderson
• 15:54   Re: caching table/query Chris Travers
• 15:55   Re: functions vs stored procedures Ezequiel Tolnay
• 15:55   Re: pg_restore hangs on 'some' HP-UX machines Gopal Srinivasa
• 15:56   help! I can not start postgreSQL service! Jiang Ma
• 15:58   Corrupt table, is zero_damaged_pages available in v7.2? Eric Comeau

25 July 2005

• 13:03   postgresql array with perl Tsirkin Evgeny
• 16:32   ssl with pem password Luca Stancapiano
• 16:32   How to Download Postgresql for Windows gudipudi sudheer
• 17:15   Re: ssl with pem password Tom Lane
• 18:41   Re: How to Download Postgresql for Windows Guido Barosio
• 18:50   Re: ssl with pem password Luca Stancapiano

26 July 2005

• 02:16   Re: Server side development Mogin Mohandas
• 02:19   server side extension Mogin Mohandas
• 06:38   Size of Large objects Bianca Oberst
• 07:47   Re: Size of Large objects Peter Eisentraut
• 07:55   Re: Size of Large objects Jim C. Nasby
• 08:42   Re: Size of Large objects Bianca Oberst
• 09:42   Re: Size of Large objects Peter Eisentraut
• 13:18   Re: Size of Large objects Tom Lane
• 15:42   postgres performance optimization Kailash Vyas
• 16:11   Database recovery. Martin Nikolov
• 16:17   Re: [pgsql-es-ayuda] bien, esta es mi duda sobre almacenamiento de datos grandes en una columna Carolina Aldaco
• 16:51   Hola Loan Joa Matos
• 17:26   Re: Hola Alvaro Herrera
• 19:49   Re: [pgsql-es-ayuda] bien, esta es mi duda sobre almacenamiento de datos grandes en una columna Jaime Casanova
• 22:22   Checkpoint segments Simon Riggs

27 July 2005

• 05:49   User Define Functions Lathika Wijerathne
• 07:08   Re: User Define Functions Gnanavel S
• 08:32   error on launching postgres in ssl mode Luca Stancapiano
• 09:54   Database disappeared Marco Rademeyer
• 10:13   Re: Database disappeared Guido Barosio
• 11:29   Problem with the compilation and running of postgresql Martin Nikolov
• 14:12   Re: Hola Guido Barosio
• 14:20   Re: error on launching postgres in ssl mode Tom Lane
• 14:24   Re: Database disappeared Tom Lane
• 14:27   Re: Problem with the compilation and running of postgresql Tom Lane
• 15:12   Help with view performance problem Chris Hoover
• 15:19   Re: Database disappeared Marco Rademeyer
• 15:32   Re: Database disappeared Rainer J. H. Brandt
• 16:04   Add a new disk to data directory jose fuenmayor
• 16:29   Re: Help with view performance problem Chris Hoover
• 16:42   libpq.so.3 compatability problem still there for 8.0.3 installs Gregory Zelesnik
• 16:58   Re: Add a new disk to data directory Michelle Konzack
• 21:32   Re: libpq.so.3 compatability problem still there for 8.0.3 Devrim GUNDUZ

28 July 2005

• 09:51   Re: Add a new disk to data directory Hans Peter Wiedau
• 18:54   Re: libpq.so.3 compatability problem still there for 8.0.3 installs Gregory Zelesnik

29 July 2005

• 06:07   start postgresql8 with -o "-i" option 王晓华
• 06:30   PostgreSQL Installation ararant
• 07:17   Re: PostgreSQL Installation Bruno Wolff III
• 09:36   Speed Up clean_pending.pl? John Abel
• 11:04   Re: PostgreSQL Installation Devrim GUNDUZ
• 11:06   Re: libpq.so.3 compatability problem still there for 8.0.3 Devrim GUNDUZ
• 11:34   postgres optimization Kailash Vyas
• 11:54   Re: Checkpoint segments Simon Riggs
• 13:24   postgres optimization Kailash Vyas
• 13:34   Re: Speed Up clean_pending.pl? Guido Barosio
• 13:49   Is there anyway to retrieve server name and/or ip from query Chris Hoover
• 13:52   Re: start postgresql8 with -o "-i" option Tom Lane
• 14:00   Re: Is there anyway to retrieve server name and/or ip from query Bruce Momjian
• 14:15   Re: Is there anyway to retrieve server name and/or ip from query Michael Fuhr
• 14:17   Re: start postgresql8 with -o "-i" option Guido Barosio
• 14:25   Re: start postgresql8 with -o "-i" option Bruce Momjian
• 15:33   Indexes on RAM disk = insanity? Steve Lane
• 15:47   Re: postgres optimization Scott Marlowe
• 15:58   Re: Indexes on RAM disk = insanity? Richard_D_Levine@raytheon.com
• 16:21   Re: Indexes on RAM disk = insanity? Tom Lane
• 16:50   Re: Indexes on RAM disk = insanity? Chris Travers
• 17:18   Re: Indexes on RAM disk = insanity? Steve Lane
• 17:31   problem on ssl client authentication Luca Stancapiano
• 18:15   rows in explain Lee Wu
• 18:45   Re: rows in explain Michael Fuhr
• 20:59   Re: rows in explain Lee Wu

30 July 2005

• 20:00   Question on placing database on a network attached storage device N/A
• 21:28   Re: Question on placing database on a network attached storage device N/A
• 22:00   Re: Question on placing database on a network attached storage Chris Travers
• 23:00   Re: Question on placing database on a network attached Jeff Frost

31 July 2005

• 02:29   Re: Question on placing database on a network attached storage Alvaro Herrera
• 11:16   Changing the database cluster locale initialization Martin Nikolov