X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2D8AED1B211 for ; Tue, 18 May 2004 16:09:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 44757-06 for ; Tue, 18 May 2004 16:09:20 -0300 (ADT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 35C5AD1B20D for ; Tue, 18 May 2004 16:09:19 -0300 (ADT) Received: from localhost.localdomain (unknown [200.35.66.77]) by www.postgresql.com (Postfix) with ESMTP id 49A25CF51D5 for ; Tue, 18 May 2004 16:09:18 -0300 (ADT) Received: from localhost.localdomain (FWVasa [127.0.0.1]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id i4IJ6q9v025367; Tue, 18 May 2004 15:06:52 -0400 Received: (from apache@localhost) by localhost.localdomain (8.12.8/8.12.8/Submit) id i4IJ6kn2025365; Tue, 18 May 2004 15:06:46 -0400 X-Authentication-Warning: localhost.localdomain: apache set sender to mario_soto@venezolanadeavaluos.com using -f Received: from 200.35.66.77 (proxying for 192.168.0.100) (SquirrelMail authenticated user mario_soto) by mail.venezolanadeavaluos.com with HTTP; Tue, 18 May 2004 15:06:46 -0400 (VET) Message-ID: <42890.200.35.66.77.1084907206.squirrel@mail.venezolanadeavaluos.com> Date: Tue, 18 May 2004 15:06:46 -0400 (VET) Subject: Re: Postgresql ssl mode From: "Mario Alberto Soto Cordones" To: In-Reply-To: <40AA4C80.6080402@spacemonkeylabs.com> References: <35992.200.35.66.77.1084893950.squirrel@mail.venezolanadeavaluos.com> <200405181821.38034.peter_e@gmx.net> <38187.200.35.66.77.1084899098.squirrel@mail.venezolanadeavaluos.com> <40AA4C80.6080402@spacemonkeylabs.com> X-Priority: 3 Importance: Normal Cc: X-Mailer: SquirrelMail (version 1.2.10) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/182 X-Sequence-Number: 13498 Hi, the certificate was create in the directori of data, an the permision its to user postgres. but the database not start Thank Mario > Hi Mario, > > Did you remember to create SSL certificates, place them in your > pgsql/data directory and set permissions on those files? > > This is what keeps PG from firing up in SSL mode (on my setup, at > least). > > HTH, > > -- Mitch > > Mario Alberto Soto Cordones wrote: > >> Hi donīt say error only not start >> >> Thank >> >> >>>Mario Alberto Soto Cordones wrote: >>> >>>>I have installed a postgresql 7.4.2, and when try to up in ssl mode >>>> this not up. then comment the ssl line in postgresql.conf and this >>>> start correctly. >>> >>>Tell us the error messages, then we can maybe help you. > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match