Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?

Поиск
Список
Период
Сортировка
От Steve Clark
Тема Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?
Дата
Msg-id 4CD025DE.1000908@netwolves.com
обсуждение исходный текст
Ответ на Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?  (Carlos Mennens <carlos.mennens@gmail.com>)
Ответы Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?  (Carlos Mennens <carlos.mennens@gmail.com>)
Список pgsql-general
On 11/01/2010 02:49 PM, Carlos Mennens wrote:
On Mon, Nov 1, 2010 at 2:27 PM, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
 
I'm guessing you are missing an initdb. Move your old data directory
somewhere else for now and do a new initdb so you can start up version 9.   
When you say 'old data' can you be more specific as to the path and
possible files I need to move?

I go to '/var/lib/postgres/data/' directory however I am not sure
where from that folder structure I need to start moving files away
without breaking basic server functionality & connection data.
 
mv /var/lib/postgres/data  /var/lib/postgres/data.old

You will then have to do an initdb to create the basic 9.x databases.
You can then use psql or pg_restore depending on how you dumped
your data to restore your databases.

With fedora you use either:
/etc/init.d/postgresql initdb
or
service postgresql initdb
to initialize the 9.x database system.

HTH
--
Stephen Clark
NetWolves
Sr. Software Engineer III
Phone: 813-579-3200
Fax: 813-882-0209
Email: steve.clark@netwolves.com
http://www.netwolves.com

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

Предыдущее
От: zhong ming wu
Дата:
Сообщение: Re: Is this a known feature of 8.1 SSL connection?
Следующее
От: zhong ming wu
Дата:
Сообщение: Feature request for this mail list