Re: [GENERAL] WINDOWS INSTALLATION TIPS

2008-02-13 Thread Maarten Boekhold
Hi, Richard Huxton wrote: INDIANNIC-HOSTING wrote: a) if your server is hosted in a dataceneter for installation on windows 2000 you cannot use terminal service. Hmm - this *should* be documented somewhere. I don't really use Windows and I know about it somehow. Can't you use "change use

[Fwd: Re: [GENERAL] CGI program cannot access database]

2004-10-07 Thread Maarten Boekhold
Original Message Subject: Re: [GENERAL] CGI program cannot access database Date: Fri, 08 Oct 2004 10:34:12 +0400 From: Maarten Boekhold <[EMAIL PROTECTED]> To: Samik Raychaudhuri <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Samik Raychaudhuri wrote: Hel

Re: [GENERAL] [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

2004-06-07 Thread Maarten Boekhold
Hi, The original poster seemed not to care too much about whether the data in this database is persistent. Under that assumption, I wonder if it's possible to do the following: 1- start postmaster 2 - create database on RAM disk (will be easy once tablespaces are there) 3 - work with this databa

RE: [GENERAL] Postgres failover implementation

2000-12-14 Thread Maarten Boekhold
mes that if the PID in the file doesn't belong to >a live process *on the local machine*, then it's left over from a >crashed postmaster. You could remove that check, perhaps, but then >you'd have to remove the PID file manually anytime you had a postmaster >crash. (Howeve

Re: [GENERAL] Re: a "huge" table with small rows and culumns

2000-12-20 Thread Maarten Boekhold
Hi, AFAIK when an entity EJB is instantiated it will be read from the DB. Similarly, when it is destroyed, it will be serialized to the DB again. Thus an update, which causes your table to grow. Maarten Maarten Boekhold, [EMAIL PROTECTED] Reuters Consulting Entrada 308 1096 ED

[GENERAL] Strange stuff with fetch

1998-06-17 Thread Maarten Boekhold
Hi, I have a pice of code which does basiccaly this: $query = "fetch in T"; while (($res = PQexec($PG_CONN, $query)) && ($PGRES_TUPLES_OK == PQresultStatus($res)) && (PQntuples($res) == 1)) { do_stuff(); PQclear($res); } As you see I'm still using the old perl-interface :). No

[GENERAL] WWW: user gallery

1998-06-19 Thread Maarten Boekhold
Hi, I have send in a submission for the user gallery onthe web-site *two* times now, one time to psql-submitpostgresql.org (what the anchor text on the page says), and one time to [EMAIL PROTECTED] (which is what that link is pointing to). Apperently no use, cos my site is still not listed :(

[GENERAL] User authentication blues

1998-07-30 Thread Maarten Boekhold
Hi, I have a 6.3.2 server, and I want to use password authentication. So, I gave the user 'postgres' and some other user a password, and I put this in my pg_hba.conf: host all 127.0.0.1 255.255.255.255 password host all 206.31.72.11 255.255.255.255 passwo

Re: [GENERAL] User authentication blues

1998-07-30 Thread Maarten Boekhold
On Thu, 30 Jul 1998, Maarten Boekhold wrote: > Hi, > > I have a 6.3.2 server, and I want to use password authentication. > So, I gave the user 'postgres' and some other user a password, and I put this > in my pg_hba.conf: > > host all 127.0.0.1

[GENERAL] lower(varchar)

1998-08-13 Thread Maarten Boekhold
Hi, I just tried to create a functional index on a varchar column, which failed, cos lower() is not defined on varchars. I guess it's only supported for text columns (aren't they treated the same way internally?). So, I figured, let's cast the varchar to a text type: create index product_arti

Re: [GENERAL] Moving Databases

1998-07-10 Thread Maarten Boekhold
On Thu, 9 Jul 1998, Jeffrey Napolitano wrote: > I have two Postgresql databases - one on machine a, one on machine b. > Both are currently running. I want to put a copy of the database on a > onto machine b. I know I have to stop the postmaster (obviously) on > database b, but what else is the

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Maarten Boekhold
> MPSQL: http://troubador.com/~keidav/images/screenshots/sot.jpg > MPMGR: http://troubador.com/~keidav/mpmgr.html > - if nobody has checked out the screenshots on this, > check it out This one is looking *sooo* cool. Anybody knows of a good toolkit the

Re: [GENERAL] Performance

1999-03-31 Thread Maarten Boekhold
annoying when ppl quote whole messages when they have only a one-line answer? Please trim down your posts..... -- Maarten Boekhold, [EMAIL PROTECTED] TIBCO Finance Technology Inc. The Atrium Strawinskylaan 3051 1077 ZX Amsterdam, The Netherlands tel: +31 20 3012158, fax: +31 20 3012358 http://www.tibco.com

Re: [GENERAL] advice on buying sun hardware to run postgres

1999-04-27 Thread Maarten Boekhold
be touching that disk, there's only linux partitions on it). Maarten -- Maarten Boekhold, [EMAIL PROTECTED] TIBCO Finance Technology Inc. The Atrium Strawinskylaan 3051 1077 ZX Amsterdam, The Netherlands tel: +31 20 3012158, fax: +31 20 3012358 http://www.tibco.com

Re: [GENERAL] memory

1999-12-01 Thread Maarten Boekhold
bably another 74 megs to be allocated somewhere in memory(?) and finally it gets to psql which needs to get yet another 74 megs. Does this make any sense to the experts? Maarten -- Maarten Boekhold, [EMAIL PROTECTED] TIBCO Finance Technology Inc. "Sevilla" Building Entrada 308 1096