Hi, You would need to install Postgres to your home directory to use the above modules. Here is how you can do that: 1. Create a new Custom Application (listening on port) in the control panel called "pgport" to reserve a port. Enter it as a shell variable:
Now proceed to install Postgresql:
Hope that helps! answered 19 Apr '11, 05:02 neeravk So far seems good as to install PostgreSQL itself. But how about the contrib modules? They are not included in the default installation, are they? Usually you do that by running "sudo apt-get install postgresql-contrib", but that doesn't work on webfaction command line. So how should we go about that?
(08 Jan '13, 14:34)
Nico
Instead of If you only want to install the contrib modules then you can run the If you want to install only a specific module you would need to traverse to its directory and run the above command. See this page for more info.
(09 Jan '13, 03:16)
iliasr ♦♦
I am building postgres v9.3 using these instructions. I already have a private postgres in my account and that seemed to create a bunch of build subdirectories in my home account: lib, include, share... If I uses these instructions and set --prefix=$HOME then will i have potentially conflicting or overwritten lib and include files? Moreover, if later want to build a 3rd postgres (say, pg version 9.4) then should I also use --prefix=$HOME ?? What is the recommended --prefix setting if I want to keep my builds separate? Is it just creating a build area for each product (eg: ~/build/postgres_93 ). Is this the recommend build strategy for multiple postgres builds?
(23 Oct '14, 10:51)
twtwt
Yes.
No.
Yes, exactly that.
(23 Oct '14, 15:05)
seanf
Another suggestion from my support ticket:
(24 Oct '14, 10:05)
twtwt
another tip: regarding the default settings in pg_hba.conf file, using 'trust' is not secure in a shared hosting environment.
(28 Oct '14, 16:58)
twtwt
showing 5 of 6
show 1 more comments
|