pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql 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