Hi there,
Regarding my last email. I have found the issue. Windows 2K is reporting
the timezine as GMTDT (GMT, Dublin time... I think) and I don't believe
Postgresql can understand this.
See the following code segments:
mcauleyt=# select timeofday();
timeofday
---
Hi,
I am unable to cast the output of timeofday() to a timestamp under
postgresql 7.3.3-1 under cygwin. I can do so under 7.3.2 running on Linux.
All the best,
Tim
Results as follows:
Cygwin - Postgresql 7.3.3 -
Tim McAuley <[EMAIL PROTECTED]> writes:
> Regarding my last email. I have found the issue. Windows 2K is reporting
> the timezine as GMTDT (GMT, Dublin time... I think) and I don't believe
> Postgresql can understand this.
No, it wouldn't recognize that. You could add the zone name as a
keyword
I've posted the information below twice to the admin list without getting a
solution, so I'm promoting it to a bug.
I'm not subscribed to the bug list, so please cc me on responses and I'll
try to supply information as needed.
I'm getting the following error message:
pg_dump: [tar archiver] co
since I moved from postgres 7.1 to 7.3 I get hangs when executing a
select on certaint rows with binary data using psql
The problem is reproducible and affects only single rows in the table .
The hangs happen only when I connect via network unsing psql -h
localhost template1
And the problem is g
Hello,
At http://ldbc.sourceforge.net/html/databases.html (see bottom of the
page), two problems in PostgreSQL are mentioned.
To me, it seems that the author is right: PostgreSQL's handling of
exceptions in transactions and trailing spaces in BYTEAs are buggy.
--
Greetings from Troels Arvin, Co
Hi To All,
AM facing a crucial problem. Now my all DBs r in SQL_ASCII formates . Now i want to
convert to unicode formates. its possible. then its possible how to do it. what r the
commands.
In postgres pg_encoding command is there . how to use it the commands.
Thanks For Ur Update
Your name : Patrick
Your email address : Valsecchi
System Configuration
-
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.20
PostgreSQL version (example: PostgreSQL-7.3.3): Post
I am encountering seriuos problems when altering,
creating tables and deleting records (zoombie process) with postgreSQL
7.3.3 and 7.3.2
I´ve seen that you´ve posted the new release of
postgreSQL 7.3.4. Are all this issues solved ? If not, which release do you
recommend ?
best regards,
Hi
I get this error when I try to backup my DB
C:\cygwin\bin>pg_dump -f nji.dump -F p NJI
pg_dump: [archiver (db)] connection to database "NJI" failed: server
closed the
connection unexpectedly
This probably means the server terminated abnormally
before or while processing the re
I am reporting a minor documentation problem in the PostgreSQL
Installation Instructions, Section 1.5.3 (Regression Tests).
The instructions imply that one can issue a "gmake check" command before
doing "gmake install" .
But, unless you have done an install, you get this error:
pg_regress: ini
Hello All,
Has anyone solved this problem. We are getting the same exact problem
with iPlanet server.
*** ERROR => accessCookie - missing cookie [WebServerPlu 120]
Can anyone tell the settings in the object ppath ???
AuthTrans fn="CheckAccess"
Service method="(POST)" fn="SendTeachCookie"
=?ISO-8859-1?Q?Hans-J=FCrgen?= Hay <[EMAIL PROTECTED]> writes:
> The hangs happen only when I connect via network unsing psql -h
> localhost template1
> And the problem is gone, when ssl is switched off in postgresql.conf
We have heard a couple of reports of problems with SSL connections,
but so f
On Sun, 27 Jul 2003, Troels Arvin wrote:
> At http://ldbc.sourceforge.net/html/databases.html (see bottom of the
> page), two problems in PostgreSQL are mentioned.
>
> To me, it seems that the author is right: PostgreSQL's handling of
> exceptions in transactions and trailing spaces in BYTEAs are
Tom Lane wrote:
=?ISO-8859-1?Q?Hans-J=FCrgen?= Hay <[EMAIL PROTECTED]> writes:
The hangs happen only when I connect via network unsing psql -h
localhost template1
And the problem is gone, when ssl is switched off in postgresql.conf
We have heard a couple of reports of problems with SSL con
Andreas Pflug <[EMAIL PROTECTED]> writes:
> I currently don't have a system to reproduce this, because I didn't
> succeed making my 7.4 server accepting ssl-connections. I posted for
> installation help on pgsql-admin but didn't get a reaction so far. RTFM
> up and down I couldn't see what I con
Tom Lane wrote:
Andreas Pflug <[EMAIL PROTECTED]> writes:
I currently don't have a system to reproduce this, because I didn't
succeed making my 7.4 server accepting ssl-connections. I posted for
installation help on pgsql-admin but didn't get a reaction so far. RTFM
up and down I couldn't se
Andreas Pflug <[EMAIL PROTECTED]> writes:
> I pushed client_min_messages and log_min_messages to debug5, and the
> only suspicious message at startup is
> LOG: could not load root cert file "/usr/data/pgsql-7.4/root.crt": No
> such file or directory
> DETAIL: Will not verify client certificates
Tom Lane wrote:
Bizarre. I looked through the recent sslmode patch, and while I found
some things I didn't like, none of them explain this. Could you perhaps
get a trace of the server-to-client interaction? Either strace'ing psql
or watching the IP traffic with a packet sniffer should do --- bu
Hi Tom,
reducing the traced conversation to its essence it's just a ssl-request
to a non-ssl server :-(
localhost.32822 > localhost.postgresql: 0008 04d2 162f
localhost.postgresql > localhost.32822: 4e
And no hints from serverlog.
Are there some more debugging options that I could enab
Andreas Pflug <[EMAIL PROTECTED]> writes:
> the attached file is a tcpdump of a connect attempt.
Hm. The postmaster is sending back 'N' indicating that it does not want
to do SSL.
Are you sure you are connecting to an SSL-enabled postmaster?
Also, is your connection by any chance IPV6? It does
Andreas Pflug <[EMAIL PROTECTED]> writes:
> reducing the traced conversation to its essence it's just a ssl-request
> to a non-ssl server :-(
Yeah, I had just come to the same conclusion. Either you're connecting
to the wrong server (check those port numbers?) or there's something
wrong with the
Tom Lane wrote:
Hm. The postmaster is sending back 'N' indicating that it does not want
to do SSL.
Are you sure you are connecting to an SSL-enabled postmaster?
Also, is your connection by any chance IPV6? It doesn't look like it
from the tcpdump, but I'm not sure I know how to tell.
Ah, that's
Andreas Pflug <[EMAIL PROTECTED]> writes:
> According to the comment, it should be
> if (!EnableSSL || port->laddr.addr.ss_family == AF_UNIX)
> and after changing this it works!
Right. I've committed the fix. One bug less, now to find the next one
...
> Dave reported this failing on snake.pgadm
At 02:47 PM 1/08/2003 -0500, Nick Fankhauser - Doxpop wrote:
pg_dump: [tar archiver] could not write to tar member (wrote 39, attempted
166)
One of the nasty features of TAR format is that it needs to know the file
size before adding it to the archive. As a result, pg_dump stores the file
in the
Greetings,
It appears that if you do the following:
Start the server with pg_hba.conf saying to use 'ident'
Change pg_hba.conf to use 'md5'
Send HUP signal to server
Log in to server (with password), create a database
It seems to revert to using 'ident' again, at least for that databas
Stephen Frost <[EMAIL PROTECTED]> writes:
> It appears that if you do the following:
> Start the server with pg_hba.conf saying to use 'ident'
> Change pg_hba.conf to use 'md5'
> Send HUP signal to server
> Log in to server (with password), create a database
> It seems to revert to usin
I am running into a problem with using contrib/fulltext on several tables.
postgres 7.3.2, script attached.
Here's the details...
I have one sql script which drops everything and recreates the database
structure, then populates it with some test data. In this script I create
tables a,b and c an
> > FWIW, I can confirm this, but I don't think it's a FreeBSD
> > specific problem given that the backend dies inside of an OpenSSL
> > routine.
>
> > #0 0x2864ae9c in EVP_DigestUpdate () from /usr/lib/libcrypto.so.3
> > #1 0x28576a90 in px_find_cipher () from /usr/local/lib/postgresql/pgcrypto
> >> testdb=# SELECT crypt('lalalal',gen_salt('md5'));
> >> server closed the connection unexpectedly
>
> > FWIW, I can confirm this, but I don't think it's a FreeBSD specific
> > problem given that the backend dies inside of an OpenSSL routine.
>
> Works fine here:
>
> regression=# SELECT crypt
30 matches
Mail list logo
