HI,
I have an installation on a Debian vserver, which we recently tried to
move from an internal machine to a hosted vserver environment.

The verser runs a PHP web-site that has Postgres, MySQL and even links
to SQLSERVER.

We backed up the vserver and copied it up to the box. After a little
work we have everything but Postgres running again.

We get the following message in /var/log/postgres/ postgresql-8.1-main.log.1

2007-10-23 09:33:11 EST FATAL: could not access private key file
"server.key":
Permission denied
2007-10-23 09:47:19 EST FATAL: could not access private key file
"server.key":
Permission denied
2007-10-23 09:50:19 EST FATAL: could not access private key file
"server.key":
Permission denied
2007-10-23 10:40:46 EST FATAL: could not access private key file
"server.key":
Permission denied
2007-10-23 10:42:35 EST FATAL: could not access private key file
"server.key":



I checked out the file
prompt# ls -l /var/lib/postgresql/8.1/main/server.key
lrwxrwxrwx 1 root root 38 Oct 19 11:02
/var/lib/postgresql/8.1/main/server.key ->
/etc/ssl/private/ssl-cert-snakeoil.key
prompt# ls -l /etc/ssl/private/ssl-cert-snakeoil.key
-rw------- 1 postgres postgres 887 Jun 2 15:51
/etc/ssl/private/ssl-cert-snakeoil.key
surfguard2:/home/barry#

This is the same as on the box that works.

I have tried to look up the issue, but so far nothing seems to make much
sense.

Do I simply need to re-create the keys on then new machine? or what?

beach_defender <barry@hpfmdotcomdotau> wrote:
Let me ask - potentially stupid - questions:

- Is /var/lib/postgresql/8.1/main the PostgreSQL data directory,
i.e. does it contain PG_VERSION?

- Do you start the server with
pg_ctl -D /var/lib/postgresql/8.1/main start ?

- As user postgres, can you
cat /var/lib/postgresql/8.1/main/server.key ?

Yours,
Laurenz Albe