Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

Поиск
Список
Период
Сортировка
От DM
Тема Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
Дата
Msg-id eae6a62a0902220232k2c6f64ban316be578332b5e2b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
First make sure you stop the 8.3.3 / 8.3.6 server and then start 8.3.6 server and point the data path to 8.3.3 data path.

/usr/postgres/8.3.3/bin/pg_ctl -D  /usr/postgres/8.3.3/data/pgsql8.3.3 stop

/usr/postgres/8.3.6/bin/postgres -i -D /usr/postgres/8.3.3/data/pgsql8.3.3 >logfile 2>&1 &

Enjoy

Thanks
Deepak Murthy

Fighting spirit spreads like fire from one person to another. A leader's daring spirit will kindle flames of enthusiasm and inspire an entire organization. - Daisaku Ikeda
Nam Myoho Renge Kyo - The Key to Unlock Your Highest Potential
(www.sgi-usa.org)

On Sun, Feb 22, 2009 at 1:43 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Sun, Feb 22, 2009 at 2:32 AM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi,
>
> I am able to revert back to 8.3.3 system.  Maybe
> I can use 8.3.3 psql to read the dumpall output.
> How can I direct the output to data directory of
> 8.3.6 postgres?

You don't have to dump and restore for a minor point update.  Just
stop your 8.3.3 and start 8.3.6 in the same data directory.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
Следующее
От: "Tena Sakai"
Дата:
Сообщение: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6