[ADMIN] installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error)

2010-10-07 Thread Kiswono Prayogo
Error: Visual C++ Runtime Installation error and installation not continued (i forgot the exact error phrase, i'm using linux right now) PostgreSQL: 9.0.0 OS: Windows XP SP3 Notes: 1. i believe Visual C++ 2005 and 2008 Runtime already installed before 2. im using sing administrator Account 3. m

Re: [ADMIN] Compile Problem for Alpha 5 in /src/backend/utils/error/elog.c

2010-04-07 Thread Kiswono Prayogo
oic, thanks ^^ -- Regards, Kiswono P GB -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Compile Problem for Alpha 5 in /src/backend/utils/error/elog.c

2010-04-07 Thread Kiswono Prayogo
Just reporting that Alpha 4 was working just fine.. http://pastebin.com/ri2gXJDN but Alpha 5 didn't: make[4]: Entering directory `/home/kyz/Repository/postgres/pgsql/src/backend/utils/error' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-stric

Re: [ADMIN] Postgesql and SSL

2010-03-19 Thread Kiswono Prayogo
ok, please ignore this thread ^^ now i know that i shouldn't using code from cvs anyway.. On Fri, Mar 19, 2010 at 2:14 PM, Kiswono Prayogo wrote: > for complete build log: > http://pastebin.com/UfVFixQY > > and there are no errors T^T > i didn't understand where is

Re: [ADMIN] Postgesql and SSL

2010-03-19 Thread Kiswono Prayogo
for complete build log: http://pastebin.com/UfVFixQY and there are no errors T^T i didn't understand where is the possible cause of the problem.. any help, welcome ^^ thank you in advance.. On Fri, Mar 19, 2010 at 1:48 PM, Kiswono Prayogo wrote: > oh yeah i forgot to show you that it&

Re: [ADMIN] Postgesql and SSL

2010-03-18 Thread Kiswono Prayogo
8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00284000) libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00135000) libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x004b6000) libssl.so.0.9.8 => /lib/i686/cmov/libssl.so.0.9.8 (0x00603000) On Fri, Mar 19, 2010 at 1:33 P

Re: [ADMIN] Postgesql and SSL

2010-03-18 Thread Kiswono Prayogo
Hi, i had the same problem building using latest cvs, it works fine on 64-bit ubuntu, but on 32-bit ubuntu (virtualbox) when i started the postgres it shows: # idir=/home/`whoami`/Software/PostgreSQL-9 # sudo su -p postgres -c "$idir/bin/postgres -D $idir/data" ; LOG: SSL is not supported by this b

[ADMIN] Best Replication Tool

2010-02-07 Thread Kiswono Prayogo
Hi, i'm really new to postgresql replication, was there any replication tool for postgresql that can do real-time replication from 1 database to ~3-10 database (on the other machines) with little overhead for load balancing purpose? -- Regards, Kiswono P GB -- Sent via pgsql-admin mailing list

Re: [ADMIN] How to increase postgresql performance

2010-02-02 Thread Kiswono Prayogo
USE LEFT/JOIN instead of WHERE IN possibly would improve the performance.. On Tue, Feb 2, 2010 at 5:51 PM, fida aljounaidi wrote: > Hi > > I have an sql query which takes 20 seconds to be executed. > > this sql query contain more than 870 id under the select where in () > condition. > > So , it

[ADMIN] Help me understanding the schema

2009-12-05 Thread Kiswono Prayogo
hi, i've used postgresql for few months now, but i still don't understand about the schema/database part and it's security consideration.. was there any better documentation (with pictures ^^) than this: http://www.postgresql.org/docs/current/static/ddl-schemas.html so, here's my current statement