Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread Tom Lane
vishal saberwal <[EMAIL PROTECTED]> writes: > Guess i can stay on 8.0.1 until we get 8.0.4 ... (is it right for me > to ask what data-loss you are talking about) ... Yeah, they're all documented in the pgsql-committers archives. Let's see... 2005-08-19 20:39 tgl * src/: backend/access/h

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread vishal saberwal
Yes you are right again tom ... When i checked, i found that fedora core came with postgresql 7.4 ... hence the reason for my SSL not working ... Installed 8.0.1 on the client and yes it works ... Guess i can stay on 8.0.1 until we get 8.0.4 ... (is it right for me to ask what data-loss you are t

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread Tom Lane
vishal saberwal <[EMAIL PROTECTED]> writes: > I agree with what you said ... They considered 8.0.1 as a stable > version they can rely on (but i believe i can propose a change now > after this SSL fix in 8.0.3) ... Well, actually, I just looked through the CVS logs, and I do not see any changes re

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread vishal saberwal
hi tom, I agree with what you said ... They considered 8.0.1 as a stable version they can rely on (but i believe i can propose a change now after this SSL fix in 8.0.3) ... Can you direct me to a website that shows the bug fixes and new features in 8.0.3 when compared to 8.0.1 and 8.0.2 ... than

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread Tom Lane
vishal saberwal <[EMAIL PROTECTED]> writes: > But, Management requires me to use 8.0.1 (on both servers and clients) > as our total infrastructure and coding is based on it ... Is there a > patch I can apply to 8.0.1 so that I could install same version on all > clients and servers ... There's not

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread Tom Lane
vishal saberwal <[EMAIL PROTECTED]> writes: > LOG: could not accept SSL connection: peer did not return a certificate It looks to me like you've got the server side set up correctly, but not the client side. The client needs to have a certificate to return when the server demands it. See http:/

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread vishal saberwal
Thanks a lot TJ, You were right ... I installed 8.0.3 and then placed the certificates as suggested by you ... It worked ... But, Management requires me to use 8.0.1 (on both servers and clients) as our total infrastructure and coding is based on it ... Is there a patch I can apply to 8.0.1 so tha

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread vishal saberwal
hi TJ, thanks for your input but i think i am still doing something wrong ... I have done exactly what the mysql site said ... The way we have it set up, changing the version really hampers work for many (as it is under use all the time) ... Can i achieve this without changing the version to 8.0.

Re: [BUGS] BUG #1843: pg_restore -O restores lowercase schemanaam

2005-08-24 Thread Tom Lane
"D.J. Kniep" <[EMAIL PROTECTED]> writes: > Description:pg_restore -O restores lowercase schemanaam Thanks for the report. This bug seems to exist only in the 7.4 branch. Applied patch is attached if you need it right away. regards, tom lane Index: src/bin/pg_dump

Re: [BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread T.J. Ferraro
Vishal, I can't recall but I think if you use 8.0.3 the error would offer more explanation. Bug 1321 was related to SSL support on windows. The error you are getting isn't a bug. It's basically telling you it can't find the postgresql.key and postgresql.crt. For creating SSL certs I've al

[BUGS] Ref: BUG#1321: SSL error: sslv3 alert handshake failure

2005-08-24 Thread vishal saberwal
hi, I was reading the post for BUG # 1321 (Date: Tue, 16 Nov 2004 13:30:33 -0700) the error "sslv3 alert handshake failure" that i have encountered now. I have postgreSQL 8.0.1 and have OpenSSL 0.9.7a. I have read through the documentation and a few other sites. PG_HBA.CONF --

Re: [BUGS] Permission denied errors

2005-08-24 Thread Alvaro Herrera
On Tue, Aug 23, 2005 at 11:06:44AM -0400, Zeki Mokhtarzada wrote: > Very interesting... We recently changed the location of the data files > using a symbolic link. Although all of the files had the correct ownership, > the new parent directory was not owned by postgres. The strange thing > is

Re: [BUGS] Problemas durante a instalacao do postgresql 8.0.3 no suse sles 9

2005-08-24 Thread Alvaro Herrera
On Tue, Aug 23, 2005 at 05:55:25PM -0300, Elmival Sousa wrote: > Estou tentando instalar o postgresql 8.0.3 no linux suse sles 9.0 e > esta ocorrendo um erro. Quando executo o comando ./configura da o > seguinte erro: configure: error: readline library not found > If you have readline already insta

[BUGS] BUG #1844: Failed to start service 'PostgreSQL Database Server 8.0'

2005-08-24 Thread Gennadiy Donchyts
The following bug has been logged online: Bug reference: 1844 Logged by: Gennadiy Donchyts Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Pro SP2 Description:Failed to start service 'PostgreSQL Database Server 8.0' Details: At

Re: [BUGS] Permission denied errors

2005-08-24 Thread Zeki Mokhtarzada
Very interesting... We recently changed the location of the data files using a symbolic link. Although all of the files had the correct ownership, the new parent directory was not owned by postgres. The strange thing is that we have been running like this for over a week, and even now, only t

[BUGS] Problemas durante a instalacao do postgresql 8.0.3 no suse sles 9

2005-08-24 Thread Elmival Sousa
Estou tentando instalar o postgresql 8.0.3 no linux suse sles 9.0 e esta ocorrendo um erro. Quando executo o comando ./configura da o seguinte erro: configure: error: readline library not found If you have readline already installed, see config.log for details on the failure. It is possible the co

[BUGS] BUG #1843: pg_restore -O restores lowercase schemanaam

2005-08-24 Thread D.J. Kniep
The following bug has been logged online: Bug reference: 1843 Logged by: D.J. Kniep Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.8 Operating system: Linux (SuSE 9.3) Description:pg_restore -O restores lowercase schemanaam Details: I make a backup using