Re: [ADMIN] Replication/Failover/HA solution

On Tue, Jul 22, 2003 at 03:49:00PM -0400, Renney Thomas wrote: > Does it just slightly depend on java or is the whole package developed > in java. At the moment, the trigger inside the database is C and the egine which does the replication is Java. > Either way I would love to see and test your

Re: [ADMIN] [PERFORM] slow table updates

On Wed, 2003-07-23 at 10:47, Guthrie, Jeremy wrote: Have you checked the sizes of your indexes? You may need to rebuild them... Multiply the relpages colum by 8192. So, what does this tell me? I'm guessing that you're implying that I should expect 8192 keys per page, and that this therefor

Re: [ADMIN] using ssl some of the time

Charles Hornberger wrote: > On Wed, 23 Jul 2003, Bruce Momjian wrote: > > Charles Hornberger wrote: > > > Am I right in interpreting this to mean that I either have to use SSL > > > all the time or none of the time? I'm especially tempted to believe > > > this might be the case after seeing this

Re: [ADMIN] [PERFORM] slow table updates

Richard- Thanks for the suggestions. I too had thought about the FK checks, even though the columns aren't getting updated. I'm flabbergasted that the update is still running (~22 hours elapsed). By comparison, the database takes only 4 hours to recreate from backup! Something funny is happen

Re: [ADMIN] Using the /var/lib/pgsql/data directory in the absense

Whatever version of postgresql you WERE running is the same version you now need to BE running. I.e. if you were running 7.3.x, you should download 7.3.3 (or 7.3.4 if it's ready to go yet) and use THAT to get your database up and running. Postgresql won't run databases from different major ve

Re: [ADMIN] compile error

Renney Thomas <[EMAIL PROTECTED]> writes: > I reconfigured the make to use openssl and I revceived the following > error using > gcc 3.3 > on SunOS 5.7 Generic_106541-25 sun4u sparc SUNW,Ultra-1 According to this recent change, you can just remove the inclusion of crypt.h ... 2003-06-23 13:03

[ADMIN] OID's

Somebody can tell me what's the difference on create the tables WITH OIDS or without them???   Thank you for ANY comments,     MAGO _  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí

[ADMIN] compile error

I reconfigured the make to use openssl and I revceived the following error using gcc 3.3 on SunOS 5.7 Generic_106541-25 sun4u sparc SUNW,Ultra-1 Thanks for any help! --- gmake[3]: Entering directory `/opt/sft/postgresql-7.3.3/src/interfaces/libpq' gcc -O3 -pthreads -Wall -Wmissing-prototypes