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
NpgsqlConnection.Npg
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
2010/11/29 Sofer, Yuval :
> 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 data
loss/corruptio
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
docs
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
/usr/lib/postgresql/8.4/bin/pg_c
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
>
Mohammed Rashad 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 -l
> /var/log/postg
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 wrote:
> Mohammed Rashad wrote:
>
> > I am getting th
Adrian Klaver 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 postgres.
Servi
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. Ca
On Mon, Nov 29, 2010 at 8:02 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
>
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 (pgsql-general@po
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
wrote:
> I installed using apt-get install postgresql-8.4
> and it worked correctly for me
> today when i tried to start postgresql server
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 postg
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 does
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
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
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 co
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() function,
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 ps
hubert depesz lubaczewski 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 that new
connect
On Mon, Nov 29, 2010 at 01:23:00PM -0500, Tom Lane wrote:
> hubert depesz lubaczewski 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 lo
On Mon, Nov 29, 2010 at 01:23:00PM -0500, Tom Lane wrote:
> hubert depesz lubaczewski 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 lo
On Mon, 29 Nov 2010 15:27:35 +0100, Reto Schöning
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 supports NTLM, but only LD
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 abo
On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane wrote:
> hubert depesz lubaczewski 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 som
On Mon, 2010-11-29 at 15:57 -0500, Vick Khera wrote:
> On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane wrote:
> > hubert depesz lubaczewski writes:
> >> straced postmaster when the problem was happening, and I was opening new
> >> connections. strace looks like this:
> >> [ backend hangs on semop immed
On Nov 29, 2010, at 12:57 PM, Vick Khera wrote:
> On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane wrote:
>> hubert depesz lubaczewski writes:
>>> straced postmaster when the problem was happening, and I was opening new
>>> connections. strace looks like this:
>>> [ backend hangs on semop immediately a
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:
http://www.postgresql.org/mailpref/pgs
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 ch
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
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 confusion,
On Mon, Nov 29, 2010 at 10:03 PM, Ben Chobot wrote:
> On Nov 29, 2010, at 12:57 PM, Vick Khera wrote:
>
> > On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane wrote:
> >> hubert depesz lubaczewski writes:
> >>> straced postmaster when the problem was happening, and I was opening
> new
> >>> connections.
33 matches
Mail list logo