Postgresql database help

kxjakkk · 2015-12-03 17:10:59 UTC

I’m trying to upload a database for postgresql, but I’m kindof stumped on how to do it? I can open up postgresql but I just don’t know how to make/upload a database and have it connected to postgresql.

Any help would be great! Thank you.

mikeumus · 2015-12-04 22:25:05 UTC

Hey @kxjakkk, I’ve yet to import a postgres database but I’ve got a couple running in C9 workspaces before. Check out the rough notes I’ve wrote on the topic in this gist:

gist.github.com

https://gist.github.com/mikeumus/03626d5cd3e1aa42918f

posgres-in-c9.md

###### Gist shortlink: https://git.io/vV0xB

#### Official Living Doc for Postgres in C9: https://community.c9.io/t/setting-up-postgresql/1573

##### @mikeumus' Postgres in Cloud9 Notes:
 - http://stackoverflow.com/questions/28177912/postgres-database-setup-on-cloud9-asks-for-sudo-password
 - http://stackoverflow.com/questions/11919391/postgresql-error-fatal-role-username-does-not-exist
 - `$ sudo -u postgres -i` or `sudo sudo -u postgres psql` <-- use this one in C9
 - `$ sudo -s` then `sudo -u postgres psql` or `sudo su - postgres`
 - `$ createuser -d -P -s starseed`

This file has been truncated. show original

Hope it help! :smileblush: