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(at)pinpointresearch(dot)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(at)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(dot)klaver(at)gmail(dot)com