Postgresql ssl mode

Поиск
Список
Период
Сортировка
Искать

Postgresql ssl mode

От:
"Mario Alberto Soto Cordones" <mario_soto@venezolanadeavaluos.com>
Дата:
Hi... first sorry by my english.


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.

what can do ???

Thank

-- 
Ing. Mario Soto Cordones
 Venezolana de Avaluos

www.venezolanadeavaluos.com




Re: Postgresql ssl mode

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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.

Re: Postgresql ssl mode

От:
"Mario Alberto Soto Cordones" <mario_soto@venezolanadeavaluos.com>
Дата:
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 6: Have you searched our list archives?
>
>                http://archives.postgresql.org



Re: Postgresql ssl mode

От:
Mitch Pirtle <mitchy@spacemonkeylabs.com>
Дата:
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.

Re: Postgresql ssl mode

От:
"Mario Alberto Soto Cordones" <mario_soto@venezolanadeavaluos.com>
Дата:
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



Re: Postgresql ssl mode

От:
Mitch Pirtle <mitchy@spacemonkeylabs.com>
Дата:
Mario Alberto Soto Cordones wrote:

> Hi,
> 
> the certificate was create in the directori of data, an the permision its
> to user postgres.
> 
> but the database not start

Not sure if this is supposed to go on the list, so send me your 
pg_hba.conf and postgresql.conf files (off-list).  I believe you have an 
error in one of them, and that is your problem with startup.

Moderator:  can we share config files on the list or is that stuff to be 
done in private?

-- Mitch

Re: Postgresql ssl mode

От:
reina_ga@hotmail.com (Tony Reina)
Дата:
> Hi,
> 
> the certificate was create in the directori of data, an the permision its
> to user postgres.
> 
> but the database not start
> 

Print the postmaster log file (I think it's $PGDATA/serverlog). It
should tell you specifically why the SSL mode can't start
(permissions/existence/etc).

-Tony
FAQ