I get this failure on current CVS running configure --with-python:
checking for python... /usr/local/bin/python
checking for Python distutils module... no
configure: error: distutils module not found
gmake: *** [config.status] Error 1
I have python
Bruce Momjian wrote:
I get this failure on current CVS running configure --with-python:
checking for python... /usr/local/bin/python
checking for Python distutils module... no
configure: error: distutils module not found
gmake: *** [config.status] Error 1
What part
Gaetano Mendola wrote:
Shachar Shemesh wrote:
Tom Lane wrote:
Parameters are only supported in plannable statements
(SELECT/INSERT/UPDATE/DELETE; I think there is some hack for DECLARE
CURSOR these days too).
That's a shame.
Aside from executing prepared statements, parameters are also useful
I've just spent a while this afternoon attempting to get SSL support
working. It appears to be lacking in a few areas, foremost
documentation. I've got a patch filling in the missing pieces for the
server side, but I am unsure where I should document the client side
bits (~/.postgresql/root.crt
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
I am also unsure of the
procedures for submitting patches; is it ok to just send to hackers?
[EMAIL PROTECTED]
In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass
in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT flag.
Hi
I think verification of the server certificates is not supported either.
SSL only serves for encryption, not authentication or integrity checking
(which is probably a stupid idea).
I have this feeling that SSL in PostgreSQL isn't category 1 supported if you
can put it that way. Maybe I'm
Bruce Momjian wrote:
What about the original request to turn off the bgwriter? Would setting
the delay to a very high value do that?
Setting the delay to the same value as checkpoint_timeout would effectivly
disable bgwriter between checkpoints. This is what I wanted.
The problem is that this
On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote:
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
I am also unsure of the
procedures for submitting patches; is it ok to just send to hackers?
[EMAIL PROTECTED]
Thanks, I'll send it along there.
In
On Tue, Sep 21, 2004 at 10:44:22AM +0200, Kaare Rasmussen wrote:
I think verification of the server certificates is not supported either.
SSL only serves for encryption, not authentication or integrity checking
(which is probably a stupid idea).
I have this feeling that SSL in PostgreSQL
In article [EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] writes:
David Wheeler [EMAIL PROTECTED] writes:
On Sep 20, 2004, at 12:34 AM, Bruce Momjian wrote:
I think we should favor libpq usage wherever possible and only
re-implement it in the native language when required, like for
Bruce Momjian wrote:
I get this failure on current CVS running configure --with-python:
checking for python... /usr/local/bin/python
checking for Python distutils module... no
configure: error: distutils module not found
gmake: *** [config.status] Error 1
I have python
Harald Fuchs wrote:
The first problem with this approach is that it requires libpq to be all
things to all people. We've already had some discussion in this thread
about the tension between supporting application programs written in C,
which want one set of features, and drivers, which need some
Bruce Momjian wrote:
I get this failure on current CVS running configure --with-python:
checking for python... /usr/local/bin/python
checking for Python distutils module... no
configure: error: distutils module not found
gmake: *** [config.status] Error 1
I
Hi,
I am using postgresql windows based "8.0-beta2-dev3". I have provided default user and password while installing. When i am trying to connecto to psql through dos command prompt, i am getting following error:
[D:\Postgresql\8.0-beta2-dev3\bin]psqlpsql: FATAL: Password authentication failed
[I sent this 24 hours ago and it hasn't shown up yet. I may have used
the wrong address. If not apologies for the dup.]
I had previously mentioned that queries run much different depending on
whether a VACUUM ANALYZE is done or just a plain ANALYZE. At the time I
was told that that couldn't be
Use psql -U postgres
Dave
On Tue, 2004-09-21 at 07:38, Sudhakar Kurumella wrote:
Hi,
I am using postgresql windows based 8.0-beta2-dev3. I have provided
default user and password while installing. When i am trying to
connecto to psql through dos command prompt, i am getting following
I tried that, the error is the same but with user "postgres"
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgrespsql: FATAL: Password authentication failed for user "postgres"
It is not taking my password if i give option with "-W" as well.
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres -W
Laszlo Hornyak [EMAIL PROTECTED] writes:
I am implementing a java language handler. If unrecoverable error occurs,
it needs to send a signal to the java process, so it can stop the
execution of the stored procedure, otherwise it would stay in inconsystent
state.
Well, an elog callback is
On Tue, Sep 21, 2004 at 10:35:56AM +0100, Dominic Mitchell wrote:
I think it's misleading to talk about SSL being supported without these
options. I've used SSL in other places (apache/mod_ssl, curl, stunnel)
and I came to expect this sort of verification as standard behaviour.
What's more,
Michael Paesold [EMAIL PROTECTED] writes:
Setting the delay to the same value as checkpoint_timeout would effectivly
disable bgwriter between checkpoints. This is what I wanted.
The problem is that this is currently not possible, since bgwriter_delay has
an upper limit of 5 seconds. Tom said
Which database are you trying to connect to?
try:
psql -U postgres template1
or
psql -U postgres -W template1
and see what happens
cheers
andrew
Sudhakar Kurumella wrote:
I tried that, the error is the same but with user postgres
[D:\Postgresql\8.0-beta2-dev3\bin]psql -U postgres
psql: FATAL:
[EMAIL PROTECTED] (Dominic Mitchell) writes:
On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote:
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass
in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT flag. This
Gaetano Mendola wrote:
Bruce Momjian wrote:
I get this failure on current CVS running configure --with-python:
checking for python... /usr/local/bin/python
checking for Python distutils module... no
configure: error: distutils module not found
gmake: ***
I am trying to connect to database called "sos", i tried as you said:
[D:\]psql -U postgres template1psql: FATAL: Password authentication failed for user "postgres"
[D:\]psql -U postgres -W template1psql: FATAL: Password authentication failed for user "postgres"
[D:\]
I got the above error
Added to open items list:
* adjust bgwriter defaults, allow disabling
---
Tom Lane wrote:
Michael Paesold [EMAIL PROTECTED] writes:
Setting the delay to the same value as checkpoint_timeout would effectivly
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I had previously mentioned that queries run much different depending on
whether a VACUUM ANALYZE is done or just a plain ANALYZE.
The problem appears to be that it's picking the wrong index to use for
the second part of the query (the certrans_active =
You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not nice, but quick :)
On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
I am trying to connect to database
On Tue, Sep 21, 2004 at 10:22:57AM -0400, Bruce Momjian wrote:
Added to open items list:
* adjust bgwriter defaults, allow disabling
Now that the oid2name patch has been applied, you can remove the
oid2name item from the open items list.
Additionaly, there's a patch in the patch queue
Dear Laszlo,
Indeed that is tough, It is highly appreciated if you could explain a bit in detail. I tried with option "password no need" in my server, and also tried remove md5 from pg_hba.conf :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all postgres md5
it is not working.
thanks
kuruLaszlo
That doesn't answer the question of why he isn't even asked for a password.
cheers
andrew
Laszlo Hornyak wrote:
You could enable local connections with no password, then connect with
your postgres user, change pwd, and then re-enable security.
use pg_ctl reload for reloading security settings.
Not
Bruce Momjian wrote:
So distutils is now required to build python? If that is intended, I
will just skip building python. I didn't realize we had new
requirements for python, but that is fine.
Yes, the python docs imply that it is a reasonable expectation. Here's a
snippet from the thread a
The local line has no effect on Windows - it only has relevance for
Unix domain socket connections, which Windows does not support.
The line that affects local connections on Windows is host all all
127.0.0.1/32 ...
(We really need to make that crystal clear in the pg_hba.conf ...)
cheers
On Tue, 21 Sep 2004, Sudhakar Kurumella wrote:
Dear Laszlo,
Indeed that is tough, It is highly appreciated if you could explain a bit in detail.
I tried with option password no need in my server, and also tried remove md5 from
pg_hba.conf :
# TYPE DATABASEUSERCIDR-ADDRESS
-- Forwarded message --
From: Fx [EMAIL PROTECTED]
Date: Mon, 20 Sep 2004 14:32:09 -0300
Subject: How to change/replace an in-memory palloced tuple- tuple data
To: [EMAIL PROTECTED]
Hi there ,
i have this scenario :
- postgresql 7.5 ( with modified heap_* functions
Is there any alternative for me ?...Any suggestinons would be highly appreciated.
thanks,
kuruAndrew Dunstan [EMAIL PROTECTED] wrote:
The "local" line has no effect on Windows - it only has relevance for Unix domain socket connections, which Windows does not support.The line that affects local
try
host all all 127.0.0.1/32 trust
restart the server, then try to connect.
Sudhakar Kurumella wrote:
Is there any alternative for me ?...Any suggestinons would be highly
appreciated.
thanks,
kuru
*/Andrew Dunstan [EMAIL PROTECTED]/* wrote:
The local line has no effect on Windows - it
Dear Andrew,
Thanks a LOT!!
It is working:
[D:\]psql -U postgres sosWelcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit
Joe Conway [EMAIL PROTECTED] writes:
Bruce Momjian wrote:
So distutils is now required to build python?
Yes, the python docs imply that it is a reasonable expectation.
FWIW, CVS tip still builds --with-python on my pretty-nearly-stock
RHL 8.0 box, so distutils was standard a couple years ago
On Tue, Sep 21, 2004 at 01:00:18PM -0300, Fx wrote:
I tried to do this using the heap_modifytuple function , and
returning a newSlot with a newTuple instead the resultSlot but as
i suppose im missing something , can anyone help me ? or give me a
clue
You need to provide more info.
hello
I am a student of MTech at IIT Bombay, India.
I am trying to implement Compression/Decompression techniques in
PostgreSQL, I am not able to figure out where and how to integrate it.
Did anybody worked on it.
Please help me !!
--
~~
Piyush Porwal
CSE - Mtech1
IIT Bomabay
On Tue, 21 Sep 2004 11:00:33 -0400
Tom Lane [EMAIL PROTECTED] wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I had previously mentioned that queries run much different depending
on whether a VACUUM ANALYZE is done or just a plain ANALYZE.
The problem appears to be that it's picking the
Tom Lane wrote:
[EMAIL PROTECTED] (Dominic Mitchell) writes:
On Tue, Sep 21, 2004 at 10:17:51AM +0200, Peter Eisentraut wrote:
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass
in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT
Piyush Porwal wrote:
I am trying to implement Compression/Decompression techniques in
PostgreSQL, I am not able to figure out where and how to integrate
it. Did anybody worked on it.
Compression already happens automatically. There is nothing left to do
on the storage side.
--
Peter
Folks,
We will be listing some of the companies who made major contributions to
PostgreSQL 8.0 in the press release. I'd like to make sure I don't leave
anyone out just because I don't know about them. What we're covering is:
a) any company that under-wrote a feature for 8.0 (such as
Alvaro Herrera wrote:
On Tue, Sep 21, 2004 at 10:22:57AM -0400, Bruce Momjian wrote:
Added to open items list:
* adjust bgwriter defaults, allow disabling
Now that the oid2name patch has been applied, you can remove the
oid2name item from the open items list.
Done.
On Tue, 21 Sep 2004, Josh Berkus wrote:
c) any company which sponsored a major add-on which was significantly
improved/created in the last year.
What would you say falls under this category?
Gavin
---(end of broadcast)---
TIP 6: Have you
On Wed, 2004-09-22 at 00:16, Bruce Momjian wrote:
So distutils is now required to build python? If that is intended, I
will just skip building python. I didn't realize we had new
requirements for python, but that is fine.
Should this be documented in the installation instructions?
-Neil
On Fri, 2004-09-17 at 01:43, Tom Lane wrote:
PS: this points up once again that the regression tests do not do very
well at testing concurrent behavior. We need to think about some sort
of parallel-test harness that would let us write tests that have better
odds of catching bugs like this.
I
Dear Hackers,
I would like to implement and contribute two TODO items:
"Have views on temporary tables exist in the temporary namespace" and
"Allow temporary views on non-temporary tables".
I would like to discuss several points with community.
*Synopsis
CREATE [
On Wed, 22 Sep 2004, Neil Conway wrote:
On Fri, 2004-09-17 at 01:43, Tom Lane wrote:
PS: this points up once again that the regression tests do not do very
well at testing concurrent behavior. We need to think about some sort
of parallel-test harness that would let us write tests that
Kind people,
I've figured out something that many others probably have, but I
thought I'd put it out there anyhow.
As PL/PgSQL doesn't allow assignment of singleton SELECTs and dynamic
queries to variables, as mentioned in the docs.
Here's a working hack that gets around this.
DECLARE foo_rec
Neil Conway [EMAIL PROTECTED] writes:
On Fri, 2004-09-17 at 01:43, Tom Lane wrote:
PS: this points up once again that the regression tests do not do very
well at testing concurrent behavior. We need to think about some sort
of parallel-test harness that would let us write tests that have
On Tue, 2004-09-21 at 17:13, Neil Conway wrote:
Should this be documented in the installation instructions?
I think so.
I figure just a mention should be enough.
(Also add some productname tags around 'Python'.)
--
Regards,
James William Pye
Index: installation.sgml
53 matches
Mail list logo