Re: [ADMIN] Finding active connections to postmaster

2001-09-27 Thread Tom Lane
[EMAIL PROTECTED] (Doobee R. Tzeck) writes: > Is it possible to list active connectons? How? 7.2 will have a better solution to this (SELECT * FROM pg_stat_activity). regards, tom lane ---(end of broadcast)--- TIP 4: Don't

Re: [ADMIN] turning on debug without restarting postgres

2001-09-27 Thread Tom Lane
"Rainer Mager" <[EMAIL PROTECTED]> writes: > Is there any way to alter postgres' debug levels without restarting it? postgresql.conf to affect all backends, SET command to affect only one backend. regards, tom lane ---(end of broadcast)-

[ADMIN] Data Base System debug question

2001-09-27 Thread Tom Poe
Hello: SuSE7.1Pro Edition pgsql version 7.0.3-6 installed from SuSE packages [rpm]. I'm in need of steps to take at this point. postgres@aether:~ > /usr/bin/postmaster -i -D /usr/local/pgsql/data 010922.16:56:21.358 [19321] DEBUG: Data Base System is starting up at Sat Sep 22 16:56:21 2001

[ADMIN] Stored procedures

2001-09-27 Thread Peter Kelders
Hallo, Is there a methode to use temporary tables with in a "stored procedure"? (2 or 3 transaction in the procedure would also be nice :) I cant get it to work in de function implementation.. Now i'am forced to put a lot of querie code in to a client application and therefore makes the system l

[ADMIN] pg_dump fails

2001-09-27 Thread David Stanaway
Here goes: $ sudo su - postgres $ pg_dump -x -Ft nvplayer > nvplayer-010920.tar getDatabase(): SELECT failed. Explanation from backend: 'ERROR: More than one tuple returned by a subselect used as an expression. '. Any suggestions? -- Best Regards David Stanaway .--

Re: [ADMIN] Migrating to DB2 from Postgres

2001-09-27 Thread X
--Thanks for the reply: --While trying to see if it's just the sheer size of the file, I just created one table and put it into a sql file. The statements are semicolon delimited. --I'm thinking that the files themselves are just too big. I'm trying to figure out options, hoping that just c