Re: [GENERAL] Libpq Asynchronous Command Processing

2010-05-31 Thread Giles Lean
=?iso-8859-1?Q?Alonso_Garc=EDa_=2C_Bruno_Elier?= wrote: > And the problems I am finding are the following: > ->Queries from the client to the new DB server take a lot of time. > ->Queries from the client to the old DB server are fast. > ->The same query takes 150 secs in one case an 1 sec in the

Re: [GENERAL] hi, trying to compile postgres 8.3.11

2010-05-28 Thread Giles Lean
erobles wrote: >> Do you need the Pg server to run on SCO OpenServer? > > Yes, i need it :-P Of course it's none of my business, but whenever I had a supplier insisting on some idosyncratic or obsolete OS I started thinking hard about replacing the supplier and their product. Even worse if

Re: [GENERAL] Unable to run createlang (or psql for that matter)

2010-04-26 Thread Giles Lean
Dave Page wrote: > The account doesn't have a password by default as it's a service > account and you shouldn't need to use it interactively. > > If you really want to though, just set a password: > > gator:~ dpage$ sudo passwd postgres > Changing password for postgres. > New password: > Retyp

Re: [GENERAL] Database viewpoint of subject - Sending e-mails from database table with Cronjob

2010-04-21 Thread Giles Lean
Andre Lopes wrote: > My doubt is... The CronJob runs every 10 minutes, but If I have 100.000 > e-mails to send the script will not be able to send all the 100.000 e-mails > in 10 minutes. More generally, your question is how to deal with a cron job that is intended to run every ten minutes, but

Re: [GENERAL] Perl interface

2000-06-16 Thread Giles Lean
> I would like to extract data from my postgreSQL7.0 database and present > them on a web-page. I want to use CGI scripts written in Perl. How do I > connect to and query the DB from Perl? A reference to a tutorial or some > sort of documentation would be highly appreciated! :)) The choi

Re: [GENERAL] postmaster logs

2000-06-16 Thread Giles Lean
> I would like to direst the postmaster log output to a file. At the > same time, because it will grow indefinitely I would like to be able > to rotate the log using newsyslog (as I do for other daemons). > > Is there a mechanism for doing this? There was discussion of this recently, with some

Re: [GENERAL] optimization by removing the file system layer?

2000-06-16 Thread Giles Lean
> I think that the Un*x filesystem is one of the reasons that large > database vendors rather use raw devices, than filesystem storage > files. This used to be the preference, back in the late 80s and possibly early 90s. I'm seeing a preference toward using the filesystem now, possibly with so

[GENERAL] Re: Industrial-Strength Logging

2000-06-03 Thread Giles Lean
--- Blind-Carbon-Copy To: [EMAIL PROTECTED] Subject: Re: Industrial-Strength Logging In-reply-to: <[EMAIL PROTECTED]> Date: Sat, 03 Jun 2000 22:59:34 +1000 Message-ID: <[EMAIL PROTECTED]> From: Giles Lean <[EMAIL PROTECTED]> On Sat, 3 Jun 2000 01:48:33 +0200 (CEST)

Re: [GENERAL] Migrating from mysql.

2000-05-24 Thread Giles Lean
On Wed, 24 May 2000 14:26:32 -0500 "Ross J. Reedstrom" wrote: > Actually, it's "\d tablename". The rest is right, though. Teach me to try to tidy things up before posting won't it? Thanks! Giles (sigh, time for coffee)

Re: [GENERAL] Migrating from mysql.

2000-05-24 Thread Giles Lean
On Mon, 15 May 2000 23:04:48 +0100 Joe Karthauser wrote: > And last but not least I'm used to using the 'desc tablename' sql command > to show the structure of a table within MySQL. How do I do the same in > PostgreSQL. In psql "\i tablename". Check out \? or the documentation for all the di

Re: Logging (was Re: [GENERAL] PostgreSQL 7.0-2 RPMset released.)

2000-05-21 Thread Giles Lean
On Mon, 22 May 2000 00:19:45 -0400 Tom Lane wrote: > There needn't be a lot of code involved, we just need a > well-thought-out spec for how it should work. Comments anyone? I run postmaster under Dan Bernstein's "daemontools", which include logging facilities: http://cr.yp.to/daemon