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@xxxxxxxxxx
