Re: [ADMIN] Backup

Hi, I have a 61Gig base at the moment and do a full online backup each night. It's not really that much of a strain so I haven't bothered with cooking up a scheme for differential backups. Using my simple scripts it takes one hour and in my case I end up with 2.5Gigs (compressed) worth of backup

[ADMIN] problem with connection logging

I'm running PostgreSQL 7.4.7 and have the following problem. I have "log connections" enabled in the configuration file so that I can keep track of who's been logging on. The problem is that I also have pg_autovacuum running which logs on an off constantly and fills up the log with its own

[ADMIN] explain analyze of PG server level

Hello, Is there a global PG server level explain analyze parameter I can turn on to catch all SQLs issued against PG server, like Oracle SQL_TRACE, and PG log_statement in PG 7.3.2? Thanks,

Re: [ADMIN] explain analyze of PG server level

On Fri, 2005-03-25 at 10:00 -0700, Lee Wu wrote: -- Hello, Is there a global PG server level explain analyze parameter I can turn on to catch all SQLs issued against PG server, like Oracle SQL_TRACE, and PG log_statement Some of these options in the postgresql.conf might help

Re: [ADMIN] explain analyze of PG server level

debug_print_plan = true can give explain info, but not explain ANALYZE info, like Seq Scan on tmp_user (cost=0.00..20.00 rows=1000 width=0) (actual time=0.04..30164.59 rows=1019462 loops=1 which is most interesting to me. Thanks, -Original Message- From: Joshua D. Drake [mailto:[EMAIL

[ADMIN] 64 or 32 postgres

Title: 64 or 32 postgres How to figure out whether the installed postgres version is 32 bit or 64bit ? We installed postgres801 from src on susu box with EMT64 bit hardware. I assume since the hardware was 64 bit, postgres should have compiled in 64 bit too, but then we ran into this error

Re: [ADMIN] 64 or 32 postgres

On Fri, Mar 25, 2005 at 11:12AM -0800, I got a letter, where Subbiah, Stalin told me: How to figure out whether the installed postgres version is 32 bit or 64bit ? We installed postgres801 from src on susu box with EMT64 bit hardware. I assume since the hardware was 64 bit, postgres should

Re: [ADMIN] 64 or 32 postgres

Subbiah, Stalin [EMAIL PROTECTED] writes: How to figure out whether the installed postgres version is 32 bit or 64bit ? We installed postgres801 from src on susu box with EMT64 bit hardware. I assume since the hardware was 64 bit, postgres should have compiled in 64 bit too, but then we ran

Re: [ADMIN] 64 or 32 postgres

Hmm.. It was complied with ./configure --without-readline. That's it. Does postgres801 rpm (postgresql-server-8.0.1-0.1.x86_64.rpm) comes with --enable-integer-datetimes enabled by default ? The reason it prompted me to ask is that, we have postgres801 rpm install in the same machine in

[ADMIN] out of memory error

Hi , I try to make insert into myTable select on pg 8.0.1 and freeBSD 5.3. After ~10 sec. pg returns out of memory. In log file I found: Portal hash: 8192 total in 1 blocks; 2008 free (0 chunks); 6184 used Relcache by OID: 8192 total in 1 blocks; 4040 free (0 chunks); 4152 used Relcache by