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 |
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. answered 04 Mar '12, 14:38 bmeyer71 ♦♦ 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 ♦♦
|
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?
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.
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.