[GENERAL] PostgreSQL local replication

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 on

[GENERAL] PostgreSQL local replication

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? W

[GENERAL] Converting mysql dump to pgsql

t.sql | my2pg.pl > dotproject.sql.pg But the resulting 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] Error in installing compat-postgresql-libs rpm

me problem? 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

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

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

h on RHEL x86_64 and > x86 boxes. > > I will be fixing FC5 and FC4 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?

ry for CentOS4 holding 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&#

[GENERAL] PostgreSQL best practices?

(unless 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

Re: [GENERAL] PostgreSQL best practices?

might not be complete or specific 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 feat

Re: [GENERAL] PostgreSQL best practices?

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 ex

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

this would slow down the take up rate for other database competitor. I 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"

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 fo