[GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Leonard Soetedjo
? Thank you. Regards, Leonard Soetedjo ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Leonard Soetedjo
Hi, On Wednesday 06 December 2006 5:26 pm, Devrim GUNDUZ wrote: Hi, On Wed, 2006-12-06 at 16:43 +0800, Leonard Soetedjo wrote: I'm trying to install PostgreSQL 8.2.0 ony my development box using rpm on CentOS 4.4. Currently I'm stuck at installing compat-postgresql-libs

Re: [GENERAL] Error in installing compat-postgresql-libs rpm

2006-12-06 Thread Leonard Soetedjo
shortly. Well, it works (I tested it on x86). Thanks a lot! Too bad though, that the RPMs has to be done per platform :( Regards, Leonard Soetedjo ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] how to install 8.2 with yum?

2006-12-06 Thread Leonard Soetedjo
PostgreSQL 8.2.0 RPMs, and thus you can't use yum. You can just download the RPMs from PostgreSQL download mirror and get the binary version for redhat-es. Regards, Leonard Soetedjo ---(end of broadcast)--- TIP 5: don't forget to increase your

Re: [GENERAL] Oracle purchases Sleepycat - is this the other shoe for MySQL AB?

2006-02-15 Thread Leonard Soetedjo
just hope not Regards, Leonard Soetedjo ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Oracle purchases Sleepycat - is this the other shoe

2006-02-15 Thread Leonard Soetedjo
On Thursday 16 February 2006 10:15, Steve Manes wrote: Leonard Soetedjo wrote: Is it possible that Oracle is trying to buy MySQL to kill off other open source competitor, e.g. PostgreSQL? MySQL has a strong number of users and therefore it is a good deal for Oracle to buy MySQL

Re: [GENERAL] PostgreSQL best practices?

2006-02-02 Thread Leonard Soetedjo
answers, but at least it gives some direction to the questioner. I found Varlena.com's PostgreSQL General Bits to be quite good. However the archives are sorted by date and therefore more difficult to discover articles/tips (regarding new PostgreSQL features, for example). Regards, Leonard

Re: [GENERAL] PostgreSQL best practices?

2006-02-02 Thread Leonard Soetedjo
On Friday 03 February 2006 13:02, Bruce Momjian wrote: Read the FAQ. Thanks. Somehow it slipped my mind to go to PostgreSQL's FAQ :P Regards, Leonard Soetedjo ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

[GENERAL] PostgreSQL best practices?

2006-01-24 Thread Leonard Soetedjo
of course I don't know that there is an existing ones). Thanks :) Regards, Leonard Soetedjo ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Converting mysql dump to pgsql

2005-10-16 Thread Leonard Soetedjo
dump still uses auto_increment backtick, which produces error. Am I missing some steps? Thanks Regards, Leonard Soetedjo ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] PostgreSQL local replication

2005-09-05 Thread Leonard Soetedjo
Hi, I'm currently using PostgreSQL 8.0.3 and would like to have a load- balancing and failover solution over LAN. From reading the mailing list, it seems that pgpool and slony1 combination has been recommended for LAN replication. But seems that pgcluster is still actively maintained?

[GENERAL] PostgreSQL local replication

2005-08-31 Thread Leonard Soetedjo
Hi, I'm currently using PostgreSQL 8.0.3 and would like to have a load- balancing and failover solution over LAN. From reading the mailing list, it seems that pgpool and slony1 combination has been recommended for LAN replication. But seems that pgcluster is still actively maintained? Which