Re: [GENERAL] autovacuum,8.1, Win

2005-11-08 Thread Wes Williams
Correct, the default setting for PostgreSQL 8.1 W32 value in postgresql.conf is 'autovacuum' to 'on'. You can see this and more settings in pgAdmin III by visiting 'Tools', 'Server Configuration', then the config file of your choice. Now, if only I could setup my home to autovaccum. -Origin

Re: [GENERAL] OT It is here: Oracle 10g Express

2005-11-03 Thread Wes Williams
Go ahead and proceed through the click-throughs...this is still the same old demo for development and testing only that they have had available for some time. This updated on Oct-28th only is for a newer version(http://www.oracle.com/technology/software/products/database/xe/index .html) of the sam

Re: [GENERAL] OT It is here: Oracle 10g Express

2005-11-03 Thread Wes Williams
Again, the previously provide link is NOT the version that is licensed free for commercial production use! The version in the headlines lately suggesting a free Oracle database for professional and production use is NOT YET PUBLICLY AVAILABLE [expected by year-end]. Still, the link below is likel

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-11-01 Thread Wes Williams
Still, at least Oracle 10g provides for an easy GUI from which to configure and perform imports and exports of data. Some of use have need for a database that can dump all data and accept another series of new data...only to be dropped again in a few days. The GUI tools make this MUCH easier - es

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-10-31 Thread Wes Williams
Precisely the point I was trying to make sure everyone would understand clearly. Although I don't have a copy of Oracle's suspected new license, if it is close to the existing license verbiage, even though it is "crippled" by having certain hardware and software limits, those limits are per physic

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-10-31 Thread Wes Williams
EMAIL PROTECTED] Sent: Monday, October 31, 2005 11:50 AM To: Wes Williams Cc: Postgresql-General; [EMAIL PROTECTED] Subject: Re: [GENERAL] Oracle 10g Express - any danger for Postgres? I assume they are probably thinking of a free for non-commercial use, which is great and all, but I assume that lik

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-10-31 Thread Wes Williams
I presume this thread was all brought about by the /. article http://developers.slashdot.org/article.pl?sid=05/10/31/0659254&tid=221&tid=1 87 According to the link provided in the /. article (http://news.zdnet.com/2100-3513_22-5920796.html), Oracle has *proposed* a free version by "year end". Obv

Re: [GENERAL] Why database is corrupted after re-booting

2005-10-26 Thread Wes Williams
Even with a primary UPS on the *entire PostgreSQL server* does one still need, or even still recommend, a battery-backed cache on the RAID controller card? [ref SCSI 320, of course] If so, I'd be interest in knowing briefly why. Thanks. -Original Message- ===snip=== ... every server I'

Re: [GENERAL] Why database is corrupted after re-booting

2005-10-26 Thread Wes Williams
Type the following at the Windows command prompt (start, run, "cmd"): convert c: /fs:ntfs /v It will complain about locked files and perform the convert at the next reboot, which you should do immediately. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jos

Re: [GENERAL] PostgreSQL vs mySQL, any performance difference for

2005-10-25 Thread Wes Williams
set sql_mode='MYSQL323'; Query OK, 0 rows affected (0.00 sec) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe Sent: Tuesday, October 25, 2005 3:24 PM To: Wes Williams Cc: 'Jan'; pgsql-general@postgresql.org Subject: Re: [GE

Re: [GENERAL] PostgreSQL vs mySQL, any performance difference for

2005-10-25 Thread Wes Williams
For what it may be worth, executing the same commands into MySQL 5.0.15-nt-max (Win XP Pro) the following it received: mysql> create table test (i1 int); Query OK, 0 rows affected (0.41 sec) mysql> insert into test values (123913284723498723423); ERROR 1264 (22003): Out of range value adjusted fo

Re: [GENERAL] password

2005-10-21 Thread Wes Williams
What platform?  Solaris, FreeBSD, Linux, Windows   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Michael UvhagenSent: Friday, October 21, 2005 6:10 AMTo: pgsql-general@postgresql.orgSubject: [GENERAL] passwordHi.I was installing po