Re: [ADMIN] Getting previous statements executed a backend currenly in an idle in transaction state.

2007-01-22 Thread Rajesh Kumar Mallah
AFAICS, log_statement and friends are much cheaper than any other alternative could be. Dear Sir, thanks for the reply and clarifying. regds mallah. regards, tom lane ---(end of broadcast)--- TIP 7: You can help

[ADMIN] server process (PID xxx) was terminated by signal 7

2007-01-22 Thread Achilleas Mantzios
In one of our remote pgsql 7.4.2 installations (no tcp/ip, no mgetty dialin works always), i got the above message. The pgsql server restarted right away, but in the meantime a significant cron job that just hapened to be executed between SIG7 and start, failed, and so that triggered the

[ADMIN] Startup problem

2007-01-22 Thread Alexandre Becquereau
Hello, I have a problem running Postgres at startup. I use the start-scripts/linux script in /etc/rc.local. The script is executed on boot but the system ask a question : Your default context is user_u:system_r:unconfined_t Do you want to choose a different one? [n] If I do not answer

[ADMIN] Install XML on Postgres 8.1

2007-01-22 Thread Alexander B.
Hi, I need to install XML on Postgres 8.1. What's the simples steps that I can follow? I found on the internet, but there are many versions, packages and ways to install. What's the right way to install? Can we compare the same powerful like Oracle has on Xml? If you could help me!! Thanks in

Re: [ADMIN] Startup problem

2007-01-22 Thread Devrim GUNDUZ
Hi, On Mon, 2007-01-22 at 12:20 +0100, Alexandre Becquereau wrote: Your default context is user_u:system_r:unconfined_t Do you want to choose a different one? [n] This is a SELinux issue. I haven't used SELinux until now; but you should either play with your SELinux policies or disable it.

Re: [ADMIN] Install XML on Postgres 8.1

2007-01-22 Thread Rajesh Kumar Mallah
On 1/22/07, Alexander B. [EMAIL PROTECTED] wrote: Hi, I need to install XML on Postgres 8.1. XML support is provided in PostgreSQL via a contrib module xml2. look for xml related folders in contrib folder after untarring the pgsql source. go through the README files on contrib modules to know

Re: [ADMIN] server process (PID xxx) was terminated by signal 7

2007-01-22 Thread Tom Lane
Achilleas Mantzios [EMAIL PROTECTED] writes: In one of our remote pgsql 7.4.2 installations (no tcp/ip, no mgetty dialin works always), i got the above message. Since you have not told us what the platform is, there is no way to guess what signal 7 means. Please look in its

Re: [ADMIN] Startup problem

2007-01-22 Thread Tom Lane
Alexandre Becquereau [EMAIL PROTECTED] writes: I have a problem running Postgres at startup. I use the start-scripts/linux script in /etc/rc.local. The one in our contrib/? That's pretty old, crufty, and unmaintained. The one most people actually use on RPM-based systems is the one that

[ADMIN] Installation under WinXP

2007-01-22 Thread Benjamin Otto
Hi, I was trying to install pgsql today but unfortunately the installer just dies away after selecting the installation language. I searched for the first error occuring in the log file but I couldn't find anything matching my problem in the archives. Below ist the logfile content. Thanks for

Re: [ADMIN] Startup problem

2007-01-22 Thread Alexandre Becquereau
Thank you, i replaced the su command by runuser and everything works perfectly now! Regards, Alexandre BECQUEREAU -- SafeLogic www.safelogic.com www.pgeep.com -Message d'origine- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : lundi 22 janvier 2007 17:10 À : Alexandre Becquereau Cc

Re: [ADMIN] server process (PID xxx) was terminated by signal 7

2007-01-22 Thread Alvaro Herrera
Tom Lane wrote: Achilleas Mantzios [EMAIL PROTECTED] writes: In one of our remote pgsql 7.4.2 installations (no tcp/ip, no mgetty dialin works always), i got the above message. Since you have not told us what the platform is, there is no way to guess what signal 7 means. Please look in

Re: [ADMIN] server process (PID xxx) was terminated by signal

2007-01-22 Thread Bruce Momjian
Alvaro Herrera wrote: Tom Lane wrote: Achilleas Mantzios [EMAIL PROTECTED] writes: In one of our remote pgsql 7.4.2 installations (no tcp/ip, no mgetty dialin works always), i got the above message. Since you have not told us what the platform is, there is no way to guess what

Re: [ADMIN] Startup problem

2007-01-22 Thread Ray Stell
On Mon, Jan 22, 2007 at 11:10:27AM -0500, Tom Lane wrote: but you really ought to adopt the whole script not just that one bit. where is the is script to be found? Nothing extracts to /etc/init.d [EMAIL PROTECTED] postgresql]$ rpm -qlp postgresql-8.2.1-1PGDG.i686.rpm /usr/bin/clusterdb

Re: [ADMIN] Startup problem

2007-01-22 Thread Ray Stell
found it: [EMAIL PROTECTED] postgresql]$ rpm -qlp postgresql-server-8.2.1-1PGDG.i686.rpm /etc/pam.d/postgresql /etc/rc.d/init.d/postgresql On Mon, Jan 22, 2007 at 01:20:21PM -0500, Ray Stell wrote: On Mon, Jan 22, 2007 at 11:10:27AM -0500, Tom Lane wrote: but you really ought to

[ADMIN] Function with Array

2007-01-22 Thread Smart Softwares - D. S.
Hello to all... I am with a problem in a function that I am creating. The parameters that are function go to receive are an ARRAY and the return also will be an ARRAY, the entrance parameters will be used in a clause SQL. E the exit ARRAY will be the result of the SQL. However, I elaborated the

Re: [ADMIN] Upgrading to 8.2, changes in user/group management scripts

2007-01-22 Thread Peter Koczan
The main thing I'm worried about is the orphaned objects problem. It's not adding users so much as removing them that I'm concerned about (I work at a University and we remove inactive/non-enrolled users). These cases would likely require a lot more in-depth intervention by myself and other

Re: [ADMIN] Upgrading to 8.2, changes in user/group management scripts

2007-01-22 Thread Stephen Frost
* Peter Koczan ([EMAIL PROTECTED]) wrote: The main thing I'm worried about is the orphaned objects problem. It's not adding users so much as removing them that I'm concerned about (I work at a University and we remove inactive/non-enrolled users). These cases would likely require a lot more

Re: [ADMIN] Upgrading to 8.2, changes in user/group management scripts

2007-01-22 Thread Alvaro Herrera
Peter Koczan wrote: The main thing I'm worried about is the orphaned objects problem. It's not adding users so much as removing them that I'm concerned about (I work at a University and we remove inactive/non-enrolled users). These cases would likely require a lot more in-depth intervention by

Re: [ADMIN] Function with Array

2007-01-22 Thread Iannsp
Smart Softwares - D. S. escreveu: Hello to all... I am with a problem in a function that I am creating. The parameters that are function go to receive are an ARRAY and the return also will be an ARRAY, the entrance parameters will be used in a clause SQL. E the exit ARRAY will be the result