[GENERAL] Extensive PostgreSQL queries in PHP scripts causing browser error?

Hello all, I've recently begun getting some strange browser errors from PHP scripts that do heavy-duty DB work inserting data and creating tables in PostgreSQL (but not SELECTing data). One script creates databases for clients using a lengthy -- 459 lines -- SQL script file, and the other per

Re: [GENERAL] fork() bad

Hi, Herouth. On Mon, 22 Mar 1999, Herouth Maoz wrote: |o| > As some of you may know, I'm hacking Ascend RADIUS 2.01 to look up a |o| > PostgreSQL database for authentication and log to PG for accounting. |o| > Normally, RADIUS fork()s once for Accounting and fork()s for each |o| > Authentication

Re: [GENERAL] fork() bad

Hello, Richi Plana wrote: > > Hi, > [ previous discussion snipped ] > > Looks like the general consensus is fork()ing is a bad thing where > PostgreSQL is concerned. So what I did was refrained from opening a > connection to the backend until AFTER the process fork()ed. > > As some of you ma

Re: [GENERAL] fork() bad

At 17:48 +0200 on 22/03/1999, Richi Plana wrote: > As some of you may know, I'm hacking Ascend RADIUS 2.01 to look up a > PostgreSQL database for authentication and log to PG for accounting. > Normally, RADIUS fork()s once for Accounting and fork()s for each > Authentication request. That's a lo

Re: [GENERAL] fork() bad

Hi, On Mon, 22 Mar 1999, M Simms wrote: |o| > My process establishes a connection with a PostgreSQL backen and then |o| > fork()s (twice, actually). To make things even more complicated (though I |o| > don't know if it affects things), my connection handle is a global |o| > variable in a dynamic

Re: [GENERAL] fork() bad

> > Hi, > > I'm probably doing something wrong here. > > My process establishes a connection with a PostgreSQL backen and then > fork()s (twice, actually). To make things even more complicated (though I > don't know if it affects things), my connection handle is a global > variable in a dynamic

[GENERAL] fork() bad

Hi, I'm probably doing something wrong here. My process establishes a connection with a PostgreSQL backen and then fork()s (twice, actually). To make things even more complicated (though I don't know if it affects things), my connection handle is a global variable in a dynamically-loaded shared

[GENERAL] max # concurrent?

Hi, People. I have two questions: 1) How many concurrent connections to the same database can I make from one process (which incidentally later fork()s)? 2) What's the most sure and/or fastest way to do backups? L L Richi Plana 8^) ,-,-. ,-,-. ,-,-. ,-,-. ,- LL LL Sy

Re: [GENERAL] Vacuum

I had same problem...tables that have heavy deletes/inserts start to eat up tons of disk space and the vacuum seemed to hang. I posted too, but got no replies...so my solution was to dump the table and delete the database and recreate it all. Also I run the vaccum more often to avoid the prob in

Re: [GENERAL] Creating Users

I didn't see any replies for this...forgive me if I dupe someone elses reply. Create user will automatically add a record into the system tables. If you can specify exactly what the error you are getting I can give you some other ideas. Password in PostgreSQL is authenticated via the operating s

[GENERAL] JDBC and getPrimaryKey()

Hello, I know that this has been discussed before but a definite answer has never really been given. When I use the JDBC getPrimaryKey call for a table nothing is returned. I have gone through the sources of the driver and manually tried the query issued in the getPrimaryKey function. No luck. It