WebFaction
Community site: login faq

I need a postgres db 9.0 (to get access to hstore as datatype).

On our server web136 postgresql 8.3.11 is running.

How can I: A - get a database on a separate webfaction server B - migrate to a newer server or C - install postgres 9.1 in my home directory?

asked 04 Mar '12, 14:29

ampelmann
3521924
accept rate: 0%

I'm very interested in installing Postgres from source, but I'd like to make it easily maintainable. One option I know of is Buildout and I've seen some recipes around that could be tweaked to do just Postgres. Does anyone know of any Buildout-like options? Alternatively, has anyone seen a Buildout recipe for Postgres only?

(14 Aug '12, 00:59) Rob Hills

I have never seen anyone use buildout to build postgres, normally people build it following the INSTALL file with the source code and the standard build options.

(14 Aug '12, 02:06) johns

Thanks for your reply. I'm familiar with the INSTALL file process, however the benefit of the buildout method is later upgrading to a new version is often as simple as changing the download URL (or even just the version number) in the buildout recipe. I've found something here (http://code.activestate.com/pypm/cp.buildout-postgres/) that I'll investigate further when I get some spare time.

(15 Aug '12, 11:50) Rob Hills

Your best option might be to migrate to a 64bit server for postgres 9.1. However if you don't want 64bit, then A) You can add an additional server (64bit) to your account and create the database there. The problem here could be network latency. Especially if the new server is in another data center. C) You can always do an install from source. We have documentation here http://docs.webfaction.com/software/home-install.html?highlight=install%20from%20source#installing-software-from-source that can help with that.

permanent link

answered 04 Mar '12, 14:38

bmeyer71 ♦♦
1.5k3613
accept rate: 33%

The config&installing worked, however I can't connect (createdb: could not connect to database postgres: FATAL: no pg_hba.conf entry for host "[local]", user "username", database "postgres", SSL off)

I have the feeling I should tell the createdb method to connect to "my" postgres instead of the default one, any pointers?

(04 Mar '12, 15:37) ampelmann

Yes you will need to tell the command to connect to your instance of postgres and the port number you have assigned. If you need us to look into it further, feel free to open a support ticket here https://help.webfaction.com/

(04 Mar '12, 15:49) bmeyer71 ♦♦

figured it out, thx

(04 Mar '12, 16:47) ampelmann

Excellent. Glad I could help.

(04 Mar '12, 16:51) bmeyer71 ♦♦
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:

×108
×84
×21

question asked: 04 Mar '12, 14:29

question was seen: 3,388 times

last updated: 15 Aug '12, 11:50

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 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