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

2006-10-21 Thread Chris Mair
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 issues

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

2006-10-21 Thread Peter Bauer
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

Re: [GENERAL] Log-based repliaction?

2006-10-21 Thread Joshua D. Drake
*) 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 private

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

2006-10-21 Thread Peter Bauer
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

[GENERAL] 8.2 release schedule

2006-10-21 Thread Marek Lewczuk
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

[GENERAL] Call for translations

2006-10-21 Thread Peter Eisentraut
With the upcoming release of PostgreSQL 8.2, it is once again time to update the message translations. If you want to help, see http://pgtranslation.projects.postgresql.org/ for instructions and other information. If there are already active translation teams, please communicate with them

Re: [GENERAL] Log-based repliaction?

2006-10-21 Thread Tobias Brox
[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

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

2006-10-21 Thread Berend Tober
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

[GENERAL] Wordpress PostgreSQL ...

2006-10-21 Thread Marc G. Fournier
-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 !!???

2006-10-21 Thread Joshua D. Drake
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? The feeling that

Re: [GENERAL] unstable postgres on freebsd

2006-10-21 Thread Marc G. Fournier
-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

Re: [GENERAL] Wordpress PostgreSQL ...

2006-10-21 Thread Joshua D. Drake
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 talk :(

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

2006-10-21 Thread Steve Atkins
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

Re: [GENERAL] Wordpress PostgreSQL ...

2006-10-21 Thread Marc G. Fournier
-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] Wordpress PostgreSQL ...

2006-10-21 Thread Christopher Browne
[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 anything that

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

2006-10-21 Thread Ron Johnson
-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 !!??? Yes!!??? But of