Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?

On 11/01/2010 11:49 AM, 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.
>

I installed from source so my data directory is in /usr/local/pgsql ,
but here is what the layout look likes. Basically everything under
~/data can be moved and the initdb run against ~/data

postgres@ford:/usr/local/pgsql/data$ l
total 112
drwx------ 13 postgres postgres  4096 2010-11-01 11:58 .
drwxr-xr-x  7 root     root      4096 2010-06-28 12:18 ..
drwx------ 13 postgres postgres  4096 2010-07-14 15:16 base
drwx------  2 postgres postgres  4096 2010-11-01 11:59 global
drwx------  2 postgres postgres  4096 2010-06-28 14:43 pg_clog
-rw-------  1 postgres postgres  3939 2010-06-28 14:43 pg_hba.conf
-rw-------  1 postgres postgres  1636 2010-06-28 14:43 pg_ident.conf
drwx------  3 postgres postgres 12288 2010-11-01 11:58 pg_log
drwx------  4 postgres postgres  4096 2010-06-28 14:43 pg_multixact
drwx------  2 postgres postgres  4096 2010-11-01 11:58 pg_notify
drwx------  2 postgres postgres  4096 2010-11-01 12:15 pg_stat_tmp
drwx------  2 postgres postgres  4096 2010-06-28 14:43 pg_subtrans
drwx------  2 postgres postgres  4096 2010-06-28 14:43 pg_tblspc
drwx------  2 postgres postgres  4096 2010-06-28 14:43 pg_twophase
-rw-------  1 postgres postgres     4 2010-06-28 14:43 PG_VERSION
drwx------  3 postgres postgres  4096 2010-06-28 16:17 pg_xlog
-rw-------  1 postgres postgres 17578 2010-10-21 11:28 postgresql.conf
-rw-------  1 postgres postgres    59 2010-11-01 11:58 postmaster.opts
-rw-------  1 postgres postgres    47 2010-11-01 11:58 postmaster.pid
-rw-r--r--  1 postgres postgres  3302 2010-07-01 14:52 server.crt
-rw-------  1 postgres postgres   887 2010-07-01 14:52 server.key
-rw-r--r--  1 postgres postgres  2094 2010-07-01 14:51 server.req



--
Adrian Klaver
adrian.klaver@gmail.com