Re: [GENERAL] could not accept SSPI security context

2010-11-29 Thread Reto Schöning
thanks a lot for the hints. client side logging: the user name corresponds to the expected user, without the domain prefix (rsc). See the full log output below. security event log: I should get that shortly from our IT. Regards, Reto 29.11.2010 10:37:17 4412 Debug Entering

Re: [GENERAL] plpyhton

2010-11-29 Thread Joshua Tolley
On Sat, Nov 27, 2010 at 04:38:27PM +0530, c k wrote: How can we implement procedure cache? Cane you please give details regarding this? It will be helpful for me. This is something the PL implementation needs to do for you. I finally looked at the plpython code, and found that it does indeed

Re: [GENERAL] ERROR: xlog flush request 17/4D6C2720 is not satisfied

2010-11-29 Thread Vick Khera
2010/11/29 Sofer, Yuval yuval_so...@bmc.com: He reported about storage problems which triggered node switch (it is postgres installation on windows 2008 cluster) But now although postgres.exe is running, it is not really functioning… Sounds to me like your clustering software caused some

Re: [GENERAL] could not accept SSPI security context

2010-11-29 Thread Reto Schöning
I just heard back from our IT. There's nothing in the logs for this connection attempt, but they noted in the Npgsql log that the authentication was attempted using NTLM. However our domain controller no longer supports NTLM, but only LDAP(s) and kerberos (it's a Windows 2008 server). From the

[GENERAL] postgresql-8.4 error

2010-11-29 Thread Mohammed Rashad
I am running ubuntu 10.04 I have problem installing postgresql-8.4 when i tried to start postgresql /etc/init.d/postgresql-8.4 start I am getting this error * Starting PostgreSQL 8.4 database server * Error: could not exec

Re: [GENERAL] postgresql-8.4 error

2010-11-29 Thread Adrian Klaver
On Monday 29 November 2010 7:02:46 am Mohammed Rashad wrote: I am running ubuntu 10.04 I have problem installing postgresql-8.4 when i tried to start postgresql /etc/init.d/postgresql-8.4 start I am getting this error * Starting PostgreSQL 8.4 database server

Re: [GENERAL] [BUGS] postgresql-8.4 error

2010-11-29 Thread Kevin Grittner
Mohammed Rashad mohammedrasha...@gmail.com wrote: I am getting this error * Starting PostgreSQL 8.4 database server * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl /usr/lib/postgresql/8.4/bin/pg_ctl start -D /var/lib/postgresql/8.4/main

Re: [GENERAL] [BUGS] postgresql-8.4 error

2010-11-29 Thread Mohammed Rashad
I reinstalled the postgresql and got this error * Starting PostgreSQL 8.4 database server * Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster line 63. On Mon, Nov 29, 2010 at 8:43 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Mohammed Rashad

Re: [BUGS] [GENERAL] postgresql-8.4 error

2010-11-29 Thread Kevin Grittner
Adrian Klaver adrian.kla...@gmail.com wrote: On Monday 29 November 2010 7:02:46 am Mohammed Rashad wrote: /etc/init.d/postgresql-8.4 start Are you trying to start Postgres as root? If so Postgres will not run as root, you will need to start it as the Postgres superuser, usually that is

Re: [GENERAL] [BUGS] postgresql-8.4 error

2010-11-29 Thread Martin Pitt
Hello Mohammed, Mohammed Rashad [2010-11-29 20:50 +0530]: I reinstalled the postgresql and got this error * Starting PostgreSQL 8.4 database server * Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster line 63. This is not an upstream bug at all. Can

Re: [GENERAL] postgresql-8.4 error

2010-11-29 Thread Scott Marlowe
On Mon, Nov 29, 2010 at 8:02 AM, Mohammed Rashad mohammedrasha...@gmail.com wrote: I am running ubuntu 10.04 I have problem installing postgresql-8.4 when i tried to start postgresql /etc/init.d/postgresql-8.4 start I am getting this error  * Starting PostgreSQL 8.4 database server        

Re: [GENERAL] postgresql-8.4 error

2010-11-29 Thread Scott Marlowe
As a followup I just noticed you cross posted to pgsql-bugs. 1: please don't cross post. 2: PLEASE don't cross post to bugs especially, unless you have a reproduceable test case that proves it's a pg bug. 3: Again, please don't cross post. -- Sent via pgsql-general mailing list

Re: [GENERAL] postgresql-8.4 error

2010-11-29 Thread Scott Marlowe
You want to use apt-get purge to remove it completely. and keep the list cc'd others might have more input. On Mon, Nov 29, 2010 at 8:53 AM, Mohammed Rashad mohammedrasha...@gmail.com wrote: I installed using apt-get install postgresql-8.4 and it worked correctly for me today when i tried to

Re: [GENERAL] postgresql-8.4 error

2010-11-29 Thread Mohammed Rashad
Dear scott, I forgot to add cc so you please ignore this I installed using apt-get install postgresql-8.4 and it worked correctly for me today when i tried to start postgresql server using /etc/init.d/postgresql-8.4 restart it not starting now will you please tell me how to completely remove

[GENERAL] postgresql-8.4 error

2010-11-29 Thread Mohammed Rashad
i removed the postgresql packages using apt-get purge postgresql-8.4 and deleted all directories and installed using apt-get install postgresql-8.4 and get this error * Starting PostgreSQL 8.4 database server * Error: /var/lib/postgresql/8.4/main is not accessible or

[GENERAL] lock file permisson

2010-11-29 Thread Mohammed Rashad
when i start postgresql using /etc/init.d/postgresql-8.4 start I am getting this error IST FATAL: could not create lock file /var/run/postgresql/.s.PGSQL.5432.lock: Permission denied I changed ownership of /var/run/postgresql using chown postgres /var/run/postgresql -- Rashad

[GENERAL] current postgresql error

2010-11-29 Thread Mohammed Rashad
now i am getting this error when starting postgresql using /etc/init.d/postgresql-8.4 start in ubuntu 10.04 my data directory is copied from a different system. postgresql incorrect checksum in control file -- Rashad

Re: [GENERAL] Question about OID and TCID

2010-11-29 Thread Zhipan Wang
Since in-place seems not possible, I am trying to use arrays to store different ranges of that column, and it's fast to fetch a big array, so I believe an array is stored continuously on disk. I can convert an array to a column easily by unnest() function, but I didn't find any function that

Re: [GENERAL] Question about OID and TCID

2010-11-29 Thread Raymond O'Donnell
On 29/11/2010 16:56, Zhipan Wang wrote: Since in-place seems not possible, I am trying to use arrays to store different ranges of that column, and it's fast to fetch a big array, so I believe an array is stored continuously on disk. I can convert an array to a column easily by unnest()

[GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread hubert depesz lubaczewski
hi, got (another time, it's not the first thing) this situation: 1. server: 64gb of ram, 24 cores of xeon processors (hyperthreading is off), storage is fusion io. 2. at one point load skyrocketed to 48 (i know, it's not high with this hardware) 3. we were not able to connect to PostgreSQL from

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread Tom Lane
hubert depesz lubaczewski dep...@depesz.com writes: straced postmaster when the problem was happening, and I was opening new connections. strace looks like this: [ backend hangs on semop immediately after reading global/pg_database ] It looks like something had exclusive lock on the database

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread hubert depesz lubaczewski
On Mon, Nov 29, 2010 at 01:23:00PM -0500, Tom Lane wrote: hubert depesz lubaczewski dep...@depesz.com writes: straced postmaster when the problem was happening, and I was opening new connections. strace looks like this: [ backend hangs on semop immediately after reading global/pg_database ]

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread hubert depesz lubaczewski
On Mon, Nov 29, 2010 at 01:23:00PM -0500, Tom Lane wrote: hubert depesz lubaczewski dep...@depesz.com writes: straced postmaster when the problem was happening, and I was opening new connections. strace looks like this: [ backend hangs on semop immediately after reading global/pg_database ]

Re: [GENERAL] could not accept SSPI security context

2010-11-29 Thread Brar Piening
On Mon, 29 Nov 2010 15:27:35 +0100, Reto Schöning reto.schoen...@gmail.com wrote: I just heard back from our IT. There's nothing in the logs for this connection attempt, but they noted in the Npgsql log that the authentication was attempted using NTLM. However our domain controller no longer

Re: [GENERAL] current postgresql error

2010-11-29 Thread Adrian Klaver
On 11/29/2010 08:35 AM, Mohammed Rashad wrote: now i am getting this error when starting postgresql using /etc/init.d/postgresql-8.4 start in ubuntu 10.04 my data directory is copied from a different system. postgresql incorrect checksum in control file -- Rashad As you found out doing the

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread Vick Khera
On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane t...@sss.pgh.pa.us wrote: hubert depesz lubaczewski dep...@depesz.com writes: straced postmaster when the problem was happening, and I was opening new connections. strace looks like this: [ backend hangs on semop immediately after reading

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread Joshua D. Drake
On Mon, 2010-11-29 at 15:57 -0500, Vick Khera wrote: On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane t...@sss.pgh.pa.us wrote: hubert depesz lubaczewski dep...@depesz.com writes: straced postmaster when the problem was happening, and I was opening new connections. strace looks like this: [

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread Ben Chobot
On Nov 29, 2010, at 12:57 PM, Vick Khera wrote: On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane t...@sss.pgh.pa.us wrote: hubert depesz lubaczewski dep...@depesz.com writes: straced postmaster when the problem was happening, and I was opening new connections. strace looks like this: [ backend

[GENERAL] Pgadmin for Fedora 14?

2010-11-29 Thread Jerry LeVan
Hi, Is there a Fedora 14 rpm for pgadmin that works out of the box for pg 8 and pg 9? Thanks, Jerry Trapped in Steve Jobs Reality Distortion Field -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Pgadmin for Fedora 14?

2010-11-29 Thread John R Pierce
On 11/29/10 1:17 PM, Jerry LeVan wrote: Hi, Is there a Fedora 14 rpm for pgadmin that works out of the box for pg 8 and pg 9? you mean, like these http://yum.pgrpms.org/9.0/fedora/fedora-14-i386/repoview/ ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Pgadmin for Fedora 14?

2010-11-29 Thread David Fetter
On Mon, Nov 29, 2010 at 04:17:44PM -0500, Jerry LeVan wrote: Hi, Is there a Fedora 14 rpm for pgadmin that works out of the box for pg 8 and pg 9? To get pgAdmin3, do the following as root: yum install pgadmin3 Just so as to abate some confusion, the major releases of PostgreSQL are

Re: [GENERAL] Pgadmin for Fedora 14?

2010-11-29 Thread John R Pierce
On 11/29/10 1:29 PM, David Fetter wrote: On Mon, Nov 29, 2010 at 04:17:44PM -0500, Jerry LeVan wrote: Hi, Is there a Fedora 14 rpm for pgadmin that works out of the box for pg 8 and pg 9? To get pgAdmin3, do the following as root: yum install pgadmin3 Just so as to abate some

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-29 Thread Dusan Misic
On Mon, Nov 29, 2010 at 10:03 PM, Ben Chobot be...@silentmedia.com wrote: On Nov 29, 2010, at 12:57 PM, Vick Khera wrote: On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane t...@sss.pgh.pa.us wrote: hubert depesz lubaczewski dep...@depesz.com writes: straced postmaster when the problem was