pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql ssl mode
7+ messages / 4 participants
[nested] [flat]
* Postgresql ssl mode
@ 2004-05-18 15:25 Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
0 siblings, 1 reply; 7+ messages in thread
From: Mario Alberto Soto Cordones @ 2004-05-18 15:25 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql ssl mode
@ 2004-05-18 16:21 Peter Eisentraut <peter_e@gmx.net>
parent: Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
0 siblings, 1 reply; 7+ messages in thread
From: Peter Eisentraut @ 2004-05-18 16:21 UTC (permalink / raw)
To: Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql ssl mode
@ 2004-05-18 16:51 Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 7+ messages in thread
From: Mario Alberto Soto Cordones @ 2004-05-18 16:51 UTC (permalink / raw)
To: peter_e@gmx.net; +Cc: mario_soto@venezolanadeavaluos.com; pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql ssl mode
@ 2004-05-18 17:48 Mitch Pirtle <mitchy@spacemonkeylabs.com>
parent: Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
0 siblings, 1 reply; 7+ messages in thread
From: Mitch Pirtle @ 2004-05-18 17:48 UTC (permalink / raw)
To: Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql ssl mode
@ 2004-05-18 19:06 Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
parent: Mitch Pirtle <mitchy@spacemonkeylabs.com>
0 siblings, 2 replies; 7+ messages in thread
From: Mario Alberto Soto Cordones @ 2004-05-18 19:06 UTC (permalink / raw)
To: mitchy@spacemonkeylabs.com; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql ssl mode
@ 2004-05-18 19:23 Mitch Pirtle <mitchy@spacemonkeylabs.com>
parent: Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
1 sibling, 0 replies; 7+ messages in thread
From: Mitch Pirtle @ 2004-05-18 19:23 UTC (permalink / raw)
To: Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgresql ssl mode
@ 2004-05-19 17:25 Tony Reina <reina_ga@hotmail.com>
parent: Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
1 sibling, 0 replies; 7+ messages in thread
From: reina_ga@hotmail.com @ 2004-05-19 17:25 UTC (permalink / raw)
To: pgsql-admin
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2004-05-19 17:25 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-18 15:25 Postgresql ssl mode Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
2004-05-18 16:21 ` Peter Eisentraut <peter_e@gmx.net>
2004-05-18 16:51 ` Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
2004-05-18 17:48 ` Mitch Pirtle <mitchy@spacemonkeylabs.com>
2004-05-18 19:06 ` Mario Alberto Soto Cordones <mario_soto@venezolanadeavaluos.com>
2004-05-18 19:23 ` Mitch Pirtle <mitchy@spacemonkeylabs.com>
2004-05-19 17:25 ` Tony Reina <reina_ga@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox