[Duraspace] Install Dspace Server Setup - BIB ITD

[Hilton Gibson]

On Tue, 2009-10-13 at 17:58 +0200, Sherwyn Mack wrote:
> Thanks hg
> 
> Your purge definitely worked, but I'm still unable to install. Am I the only one having trouble with postgresql?
No. You have stumbled upon a possible bug.
Debian/Ubuntu developers have very strict guidelines not to destroy user
data. So instead they are instructed to copy files before overwriting
them.

However your "purge" caused an unusual situation.
Postgresql was marked as previously installed by the aptitude database
and the re-install therefore triggered the need to make a copy of the
previous config that is not there. Obviously the "purge" did not update
the database as it should. This is my assumption.

So to hack it, do the following:
sudo -u postgres touch /var/lib/postgresql/8.3/main/postgresql.conf
This is assuming the postgres user exists.

Then run the cluster command again.

In general the Debian/Ubuntu developers are VERY WARY of destroying
valuable user data in databases !!!

Cheers

hg.

>  My output below:
> 
>         root at dspace:~# aptitude install postgresql-8.3
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Reading extended state information
> Initializing package states... Done
> Building tag database... Done
> The following NEW packages will be installed:
>   postgresql-8.3
> 0 packages upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
> Need to get 0B/3617kB of archives. After unpacking 14.0MB will be used.
> Writing extended state information... Done
> Selecting previously deselected package postgresql-8.3.
> (Reading database ... 32449 files and directories currently installed.)
> Unpacking postgresql-8.3 (from .../postgresql-8.3_8.3.8-0ubuntu8.04_i386.deb) ...
> Setting up postgresql-8.3 (8.3.8-0ubuntu8.04) ...
> Configuring already existing cluster (configuration: /etc/postgresql/8.3/main, data: /var/lib/postgresql/8.3/main, owner: 107:114)
> Error: move_conffile: required configuration file /var/lib/postgresql/8.3/main/postgresql.conf does not exist
> Error: could not create default cluster. Please create it manually with
> 
>   pg_createcluster 8.3 main --start
> 
> or a similar command (see 'man pg_createcluster').
> 
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Reading extended state information
> Initializing package states... Done
> Writing extended state information... Done
> Building tag database... Done
>         root at dspace:~# pg_createcluster 8.3 main --start
> Configuring already existing cluster (configuration: /etc/postgresql/8.3/main, data: /var/lib/postgresql/8.3/main, owner: 107:114)
> Error: move_conffile: required configuration file /var/lib/postgresql/8.3/main/postgresql.conf does not exist
> 
> 
> 
> -----Original Message-----
> From: duraspace-admin at moo.sun.ac.za [mailto:duraspace-admin at moo.sun.ac.za] On Behalf Of Hilton Gibson
> Sent: 12 October 2009 05:44 PM
> To: duraspace at moo.sun.ac.za
> Subject: RE: [Duraspace] Install Dspace Server Setup - BIB ITD
> 
> On Mon, 2009-10-12 at 17:24 +0200, Sherwyn Mack wrote:
> > Hi All
> >
> > I've run into some trouble with my pg_hba.conf file so I decided to uninstall PostgreSQL and re-install.
> > I ran 'aptitude install postgresql-8.3' it ran a long download and said that it was successful and all that, but when I check, there's no postgresql in the /etc directory.
> >
> > I thought that maybe I hadn't installed properly, but then when I tried the install again, it said that I already had the latest version installed. I got frustrated and tried to uninstall again, but then it said there was nothing to uninstall!
> >
> > Please help. Thanks
> Ok. Assuming you do not want to use ANY of the old postgresql, do the
> following (run this at your own peril !!!)
> 
> Open a terminal on the server and type the following:
> sudo dpkg --purge postgresql-8.3
> After is it purged, there should no config files and NO databases.
> Then do the installation again and recreate your dspace database
> according to the wiki instructions strictly.
> 
> Then run the Dspace installation instructions again.
> 
> Hope you export your digital assets first !!
> 
> Cheers
> 
> hg.
> 
> > _______________________________________________
> > Duraspace mailing list
> > Duraspace at moo.sun.ac.za
> > http://moo.sun.ac.za/mailman/listinfo/duraspace
> 
> 
> --
> Hilton Gibson
> Systems Administrator
> JS Gericke Library
> Stellenbosch University
> Private Bag X5036 Stellenbosch 7599
> South Africa
> 
> Tel: +27 21 808 4100 | Cell: +27 84 646 4758
> 
> _______________________________________________
> Duraspace mailing list
> Duraspace at moo.sun.ac.za
> http://moo.sun.ac.za/mailman/listinfo/duraspace
> 
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.421 / Virus Database: 270.14.11/2430 - Release Date: 10/12/09 04:01:00
> _______________________________________________
> Duraspace mailing list
> Duraspace at moo.sun.ac.za
> http://moo.sun.ac.za/mailman/listinfo/duraspace


-- 
Hilton Gibson
Systems Administrator
JS Gericke Library
Stellenbosch University
Private Bag X5036 Stellenbosch 7599
South Africa

Tel: +27 21 808 4100 | Cell: +27 84 646 4758