Re: [GENERAL] Overload after some minutes, please help!

> its just a vacuumdb --all. We already learned that full vacuums are > evil because the database was carrupted after some time. Wait a sec... vacuum full maybe evil in the 'locks stuff and takes long to run'-sense, but it should definitly NOT corrupt your database. Are you sure there's no issue

Re: [GENERAL] Overload after some minutes, please help!

Hi, we had these problems with Version 7.4.7, you can find the old thread here: http://archives.postgresql.org/pgsql-general/2006-09/msg00079.php br, Peter 2006/10/21, Chris Mair <[EMAIL PROTECTED]>: > its just a vacuumdb --all. We already learned that full vacuums are > evil because the data

Re: [GENERAL] Log-based repliaction?

> *) boss has decided that a failover solution is important and should > be prioritied in 2007 ... even to the point where he's willing to of > throw money at it. If anyone have experiences with failover-solutions > built over a SAN, and can do consultancy services for us, please send > me a priv

Re: [GENERAL] Overload after some minutes, please help!

Hi all, here comes an update: Currently a loadtest is running since 4 hours which did not cause any problems so far. There are about 20 rows inserted, updated and deleted per hour. We made column_indexes for location1, location2, location3, register, type and multi_column_index for isbackup,

Re: [GENERAL] Overload after some minutes, please help!

> All other loadtests (no locking or no indexing) ended up in very high > load and an unusable system after max. one hour because of the very > long running sub-SELECT of the DELETE statement. > > So i think that sometimes there were deadlocks between these 3 > statements which were detected and

[GENERAL] 8.2 release schedule

Hello, is there any schedule for final 8.2 release ? As far I remember this should be around November ? I would like to know that in order to plan my work. Thanks in advance. ML ---(end of broadcast)--- TIP 3: Have you checked our extensive FA

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > Can we convert from Postgres to Oracle !!??? Yes!!??? -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hos

[GENERAL] Call for translations

With the upcoming release of PostgreSQL 8.2, it is once again time to update the message translations. If you want to help, see for instructions and other information. If there are already active translation teams, please communicate with them f

Re: [GENERAL] Log-based repliaction?

[Joshua D. Drake - Sat at 08:14:51AM -0700] > 1. Slony - Trigger based I don't know ... I'm not overly happy with the idea of using triggers for the replication. I'm a bit concerned about the overheads, both on the primary database server as well as the administrative costs setting it up and main

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

Devrim GUNDUZ wrote: On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: Can we convert from Postgres to Oracle !!??? Yes!!??? But of course, that begs the question: Why on earth would you want to!!??? ---(end of broadcast)--

[GENERAL] Wordpress & PostgreSQL ...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Does anyone know of any work being done to get wordpress ported to PostgreSQL? My search on the web finds emails from March of this year concerning some ppl more or less "looking into it", but I can't find anything that indicates they've done much

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

Berend Tober wrote: > Devrim GUNDUZ wrote: >> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: >> >>> Can we convert from Postgres to Oracle !!??? >>> >> >> Yes!!??? >> > > But of course, that begs the question: Why on earth would you want to!!??? Cost? Extensibility?

Re: [GENERAL] unstable postgres on freebsd

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Are you running this in a FreeBSD jail under 6.1? It sounds like the problem that I had where a second postmaster starts up and stomp's on the previous postgresql's shared memory ... To "fix", you have to make sure that both instances run as diffe

Re: [GENERAL] Wordpress & PostgreSQL ...

Marc G. Fournier wrote: > > Does anyone know of any work being done to get wordpress ported to > PostgreSQL? > My search on the web finds emails from March of this year concerning some ppl > more or less "looking into it", but I can't find anything that indicates > they've done much more then

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

On Oct 21, 2006, at 6:48 PM, Berend Tober wrote: Devrim GUNDUZ wrote: On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: Can we convert from Postgres to Oracle !!??? Yes!!??? But of course, that begs the question: Why on earth would you want to!!??? Sale of enterpris

Re: [GENERAL] Wordpress & PostgreSQL ...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ya, I found the wordpress-pg.sourceforge.org project, but that was for 1.2 ... major old :( I have one client running Blogsom w/ PostgreSQL that works well, but a whack running MySQL that I'd love nothing more then to get off of it :( If we ever

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

Joshua D. Drake wrote: > Berend Tober wrote: > > Devrim GUNDUZ wrote: > >> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > >> > >>> Can we convert from Postgres to Oracle !!??? > >> > >> Yes!!??? > > > > But of course, that begs the question: Why on earth would you want to!!?

Re: [GENERAL] Wordpress & PostgreSQL ...

[EMAIL PROTECTED] ("Joshua D. Drake") wrote: > Marc G. Fournier wrote: >> >> Does anyone know of any work being done to get wordpress ported to >> PostgreSQL? >> My search on the web finds emails from March of this year concerning some >> ppl >> more or less "looking into it", but I can't find

Re: [GENERAL] [SQL] Can we convert from Postgres to Oracle !!???

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/21/06 22:10, Steve Atkins wrote: > > On Oct 21, 2006, at 6:48 PM, Berend Tober wrote: > >> Devrim GUNDUZ wrote: >>> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: >>> Can we convert from Postgres to Oracle !!??? >>>