Postgresql ssl mode

[Mario Alberto Soto Cordones]

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





---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Peter Eisentraut]

Post by Mario Alberto Soto Cordones
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

[Mario Alberto Soto Cordones]

Hi don´t say error only not start

Thank

Post by Peter Eisentraut

Post by Mario Alberto Soto Cordones
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Mitch Pirtle]

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

Post by Mario Alberto Soto Cordones
Hi don´t say error only not start
Thank

Post by Peter Eisentraut

Post by Mario Alberto Soto Cordones
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

[Mario Alberto Soto Cordones]

Hi,

the certificate was create in the directori of data, an the permision its
to user postgres.

but the database not start

Thank

Mario

Post by Mitch Pirtle
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

Post by Mario Alberto Soto Cordones
Hi don´t say error only not start
Thank

Post by Peter Eisentraut

Post by Mario Alberto Soto Cordones
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Mitch Pirtle]

Post by Mario Alberto Soto Cordones
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Tony Reina]

Post by Mario Alberto Soto Cordones
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