Re: PGSQL on shared hosting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PGSQL on shared hosting
Дата
Msg-id 28229.1069611069@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PGSQL on shared hosting  (Erick Papadakis <erick_papadakis@yahoo.com>)
Список pgsql-general
Erick Papadakis <erick_papadakis@yahoo.com> writes:
> So how can I execute it inside my own folder? Do I need to give any
> special commands? Is there any FAQ for this?

I think the other respondents already gave you the needed clues:
configure with --prefix set to someplace in your own directory tree,
and select a PGDATA directory under your own tree as well.

I'm also in the habit of selecting a default port that's not standard
(not 5432), so that there won't be a port conflict if the machine's
owner someday decides to install PG as standard.

In short, something like

./configure --with-pgport=5434 --prefix=/home/tgl/version74

(plus any other configure options you like) and then

export PGDATA=/home/tgl/version74/data

before running initdb or starting the postmaster.

If you do it exactly as above then you'll also need to add
/home/tgl/version74/bin to your PATH so that you can invoke psql and
other utilities conveniently.  I think you can also fool with
configure's more-detailed prefix options if you have an existing
personal bin directory that you'd rather put psql into.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Keith C. Perry"
Дата:
Сообщение: 7.4 Docs in PDF format
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Invalid page header in block xxxx