getting postgresql to work on cloud9

393 Views Asked by At

I'm trying to get PostgreSQL set up on cloud-based IDE Cloud9 but getting hung up getting getting the postgreSQL server, databases and roles started.

Cloud9 docs have instructions called "Setting Up PostgreSQL" but following them produces the error shown below.

I'm working in a new c9 workspace but it's possible that I've done something in c9 (like upgrading pg, starting pg server in other workspaces, etc.) that is messing things up, too.

Anyone have any ideas?

I hope to have the basics of getting pg set up well enough to set up rails 4.2 apps with rails_composer using postgreSQL.

[my c9 username]:~/workspace $ sudo service postgresql start
 * Starting PostgreSQL 9.3 database server
 * The PostgreSQL server failed to start. Please check the log output:

2015-11-08 13:10:11 UTC FATAL:  could not access private key file  "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied

   ...fail!

[my c9 username]:~/workspace $ 
1

There are 1 best solutions below

0
On

Got it working! Or I should say, "It's working now."

I'm embarrassed to say that I think the problem is related to having an open browser on my desktop with the same name as the new workspaces I was creating to get this working on my laptop.

I'll leave this question and answer up in case someone else has the same rare scenario and generates the same error message.