From: | Klint Gore <kgore4(at)une(dot)edu(dot)au> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Need Help Recovering from Botched Upgrade Attempt |
Date: | 2008-06-18 02:36:25 |
Message-ID: | 485874A9.7020408@une.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rich Shepard wrote:
> On Wed, 18 Jun 2008, Klint Gore wrote:
>
> >> 5.) Built postgresql-8.3.3 using the SlackBuild script, then ran
> >> 'upgradepkg postgresql-8.3.3*tgz'; other than reporting not finding an
> >> expected pid file, that went smoothly.
> >>
> > Is there an initdb in here somewhere? Or is the 8.3 server trying to start
> > with an 8.1 file structure?
>
> Klint,
>
> Backed up a couple of steps, and tried again. Removed postgresql-8.3.3;
> deleted all contents of /var/lib/pgsql/data (because initdb is supposed to
> create the contents, if I correctly read the Postgresql book); re-installed
> postgresql-8.3.3; ran (as user postgres) 'initdb -D /var/lib/pgsql/data'.
> Nothing!
>
> I've really FUBARed this and don't understand how, or what to do to
> recover.
>
> Thanks,
>
>
Make sure that initdb is the version you want
initdb --version
then
initdb -E UTF8 -D /var/lib/pgsql/data
then post the output of that.
kllint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4(at)une(dot)edu(dot)au
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2008-06-18 02:37:05 | Re: Need Help Recovering from Botched Upgrade Attempt |
Previous Message | Rich Shepard | 2008-06-18 02:18:38 | Re: Need Help Recovering from Botched Upgrade Attempt |