: Saturday, 13 June, 2009, 9:55 AM
daviesi123 [2009-06-11 19:08 -]:
> $ sudo ls -l /var/lib/postgresql/8.3/main/ id postgres
Sorry, these are actually two lines. Can you please give me the output
of
id postgres
?
> lrwxrwxrwx 1 root root 31 2009-05-01 10:08 root.crt ->
Well done Martin, your command worked!
I'm not using anything like LDAP, I'm a home user and mine is the only
user account, so I don't know why postgres wasn't in the ssl-cert group.
I can now start the database and run psql from the Applications, Other
menu.
Thanks very much for your efforts; I
** Attachment added: "Dependencies.txt"
http://launchpadlibrarian.net/27387518/Dependencies.txt
** Attachment added: "DpkgTerminalLog.gz"
http://launchpadlibrarian.net/27387519/DpkgTerminalLog.gz
--
The PostgreSQL server failed to start.
https://bugs.launchpad.net/bugs/382584
You received
Public bug reported:
Binary package hint: postgresql-8.3
2009-06-01 23:19:56 BST FATAL: could not access private key file "server.key":
Permission denied
[fail]
invoke-rc.d: initscript postgresql-8.3, action "start" failed
It doesn't look that clear to me.
i...@ubuntu:/etc/ssl$ ls -l
total 36
drwxr-xr-x 2 root root 20480 2009-04-30 23:23 certs
-rw-r--r-- 1 root root 9374 2008-07-25 19:40 openssl.cnf
drwx--x--- 2 root ssl-cert 4096 2009-01-07 23:08 private
i...@ubuntu:/etc/ssl$
How do I change this to wha
Hello Martin,
$ sudo ls -l /etc/ssl/private/ssl-cert-snakeoil.key
-rw-r- 1 root ssl-cert 887 2009-01-07 23:08
/etc/ssl/private/ssl-cert-snakeoil.key
I haven't knowingly changed postgresql.conf but I've attached the one from
/etc/postgresql/8.3/main
I hope this makes more sense to you than
$ sudo ls -l /var/lib/postgresql/8.3/main/ id postgres
ls: cannot access id: No such file or directory
ls: cannot access postgres: No such file or directory
/var/lib/postgresql/8.3/main/:
total 40
drwx-- 7 postgres postgres 4096 2009-05-01 12:07 base
drwx-- 2 postgres postgres 4096 2009-06
