WebFaction
Community site: login faq

If you need to use extensions, such as unaccent, in your Postgresql database, you cannot do it with a shared database instance as you need to be a superuser to install extensions.

Follow these steps to get it running with your own private db instance:

  1. Create a private instance of the postgresql database server as detailed in the webfaction docs and follow the steps up until step 4 - the CREATE USER point.
  2. Now at this point you have a choice. Either create your database user as a superuser, or create your user as a normal user (as specified in the docs) at this point. If you create a normal user that account will not have permissions to install extensions either - you will need to create another user as superuser which will have the necessary permissions to install the extension on your database.
  3. Either way you create your superuser account by running: CREATE USER your_superuser WITH PASSWORD 'your_password' SUPERUSER;
  4. Once your superuser is created grant access with: GRANT ALL PRIVILEGES ON DATABASE your_database_name TO your_superuser;
  5. Now exit psql (type: \q at the prompt) and re-enter as your superuser: psql -h localhost -p your_port_num your_database_name your_superuser;
  6. Type: CREATE EXTENSION unaccent; and the extension is created/installed and is now available to the users of that database.

And that's it. This took me a few days to resolve with the good folks at webfaction, but it is now working. Hopefully someone else gets some benefit from these instructions.

This question is marked "community wiki".

asked 03 Jun '15, 20:07

houdinihound
36227
accept rate: 66%

edited 17 Dec '15, 13:58


marking as answered.

permanent link
This answer is marked "community wiki".

answered 03 Jun '15, 20:08

houdinihound
36227
accept rate: 66%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×109
×12
×6

question asked: 03 Jun '15, 20:07

question was seen: 11,447 times

last updated: 17 Dec '15, 13:58

                              
WEBFACTION
REACH US
SUPPORT
LEGAL
© COPYRIGHT 2003-2020 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM