Re: [ADMIN] remove my name from mailing list

2008-04-28 Thread Phillip Smith
> I want to remove my name from mailing list could you suggest me the procedure by which i can do this The headers of every message on the list contains the information you're after: List-Archive: List-Help: List-ID: List-Own

[ADMIN] remove my name from mailing list

2008-04-28 Thread madhu.harchandani
Hello I want to remove my name from mailing list could you suggest me the procedure by which i can do this Regards Madhu Harchandani Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this

Re: [ADMIN] Bus error in postgres 8.3

2008-04-28 Thread Pavan Deolasee
On Tue, Apr 29, 2008 at 10:35 AM, Peter Koczan <[EMAIL PROTECTED]> wrote: > > I'm going to try to force a crash on my test server to see if I can > find out anything more. Does anyone know how to get useful debugging > info at the time of the crash? I don't think I have things set to dump > co

Re: [ADMIN] Bus error in postgres 8.3

2008-04-28 Thread Tom Lane
"Peter Koczan" <[EMAIL PROTECTED]> writes: > I'm going to try to force a crash on my test server to see if I can > find out anything more. Does anyone know how to get useful debugging > info at the time of the crash? I don't think I have things set to dump > core anywhere, but that and/or stack tra

[ADMIN] Bus error in postgres 8.3

2008-04-28 Thread Peter Koczan
Hi all, I'm looking to push 8.3 out this week, but I'm running into a particularly nasty bus error. I'm not sure what's causing it as it appears to be transient (or at least somewhat random), but I do know that it bites on connection time and takes down the entire server with it. I'm going to try

Re: [ADMIN] Remove Postgres from Solaris 10

2008-04-28 Thread Jignesh K. Shah
I guess what you mean is to remove the "role" postgres so that you can redefine it as a normal user and not remove the binaries that are installed with Postgres as they can be overridden by having right PATH variables Its easy... Modify /etc/user_attr and remove type=role from the postgres li

[ADMIN] Remove Postgres from Solaris 10

2008-04-28 Thread Thomas Bräutigam
Hello all, I have a software solution with a postgres database. The user postgres is abolutly needed for my software. With Solaris 10, Postgres is automatically installed and uses the user postgres. How can I easily remove the current postgres install from this Solaris 10? Is there a proces

Re: [ADMIN] warm standby issues

2008-04-28 Thread Julio Leyva
I have setup this feature using postgresql 8.3.1 on a suse linux version and pg_standby as a recovery script, works very good and I use rsync as a script to ship logs This is my configuration in the primary D.B archive_mode = on archive_command = 'rsync -atz %p backup:/data01/wal_files/%f

Re: [ADMIN] Problem with GeomFromText('POINT(...

2008-04-28 Thread Brian Modra
The "long" column isn't being referenced the way you've written this, because its inside of a quoted string. You need to construct the string GeomFromText('POINT(' || public.Contenedor.long || ' 49.8543)', 4326) 2008/4/28 J Fran <[EMAIL PROTECTED]>: > > I'm trying upate a group of records. In the

[ADMIN] Problem with GeomFromText('POINT(...

2008-04-28 Thread J Fran
I'm trying upate a group of records. In the table I have 1 field geometry and 2 fields ineteger with long. and lat. everyone. I try to update the field geometry with point(long lat). I use this update with numbers and this is ok.UPDATE public."Contenedor" SET ubicacion = GeomFromText('POINT(1