database setup instructions

[stoneleaf]

My apologies is this is already covered -- my searching did not find
it.

I have just installed EPL, and I already have postgres installed at my
site. I see that etherpad-lite supports many different dbs but I
couldn't find setup instructions for anything besides mysql.

Does anyone know of such a document?

My specific problem is this:

[settings.json]
"dbType" : "postgres",
"dbSettings" : {
"user" : "etherpad-lite",
"host" : "localhost",
"password": "etherpad",
"database": "etherpad"
},

[traceback]
/usr/local/lib/etherpad-lite$ bin/run.sh
Ensure that all dependencies are up to date...
Ensure jQuery is downloaded and up to date...
bin/installDeps.sh: 82: [: missing ]
Clear minfified cache...
ensure custom css/js files are created...
start...

events.js:71
throw arguments[1]; // Unhandled 'error' event
^
error: language "plpgsql" does not exist
at p.parseE (/usr/local/lib/etherpad-lite/node_modules/pg/lib/
connection.js:473:11)
at p.parseMessage (/usr/local/lib/etherpad-lite/node_modules/pg/
lib/connection.js:348:17)
at Socket.p.attachListeners (/usr/local/lib/etherpad-lite/
node_modules/pg/lib/connection.js:84:22)
at Socket.EventEmitter.emit (events.js:96:17)
at TCP.onread (net.js:396:14)

I have tried

psql
connect etherpad
create language plpgsql

but I still get the error.

Any pointers, links, etc., would be greatly appreciated.

~Ethan~

[John McLear]

https://github.com/Pita/ueberDB should help.

Basically
exports["postgres"] = {"user":"etherpadlite", host: "localhost",
"password":"etherpadlite", database: "etherpadlite"};

error: language "plpgsql" does not exist

looks like it might be an issue with UeberDB though.

Feel free to clone Ueber locally and test.

> --
> You received this message because you are subscribed to the Google Groups "etherpad-lite-dev" group.
> To post to this group, send email to etherpad...@googlegroups.com.
> To unsubscribe from this group, send email to etherpad-lite-...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/etherpad-lite-dev?hl=en.
>