Re: [ADMIN] Re: [GENERAL] I screwed it up, my installation :(
Thanks John,
I tried your suggestion but it made no difference, and
whilst I wiped the egg off my face I reinstalled from the
6.5 CD after uninstalling 7.0 as root. So its all happy now.
I guess with my current configuration it ain't gonna work
under RedHat 6.1, but I am going to wait till a proven
version of RedHat 7.x comes out before I upgrade.
Cheers
Alan
On Fri, 18 Aug 2000, John Clark L. Naldoza wrote regarding
"[ADMIN] Re: [GENERAL] I screwed it up, my installation
:(": > Hello Alan, >
>
> From /usr/doc/postgresql-7.0.2/README.rpm it says...;-)
>
> NOTE: The 7.0 RPMs are only being built under RedHat 6.2! They
> may or may not work under RedHat 6.0 or 6.1.
>
> But like you, I have come across the exact same thing...;-) _IF_ you
> don't have any real data and are willing to start from scratch... try
> deleting all files and directories under
>
> /var/lib/pgsql
>
> and re-run your postgresql start-up script Postgresql should create
> an empty database for your perusal...;-)
>
> If you have some important data... Well then, I
strongly recommend that > you back-up your data from the
>
> /var/lib/pgsql
>
> directory before proceeding to delete all file and directories under
> it...;-)
>
> Hope that helps...;-)
>
>
> Cheers,
>
>
> John Clark
--
AlphaByte: PO Box 1941, Auckland, New Zealand
Specialising in:Graphic Design, Education and Training,
Technical Documentation, Consulting.
http://www.alphabyte.co.nz
Re: ODP: [ADMIN] I screwed it up, my installation :(
Thanks for the suggestion but the installation had updated
the start up script to read version 7.0, however the other
RPMs were not upgraded and were still 6.5. It all became
clear when I actually read the script.
I had to reinstall from the CD, so all done now :0)
Of course if I had read the README properly I would have
seen that version 7.0 doesnt run on RedHat 6.1 only 6.2,
duh.
As a suggestion to the powers though, perhaps it might be a
good idea to have the README contents on the download page,
or somewhere handy to it, I did try to find one but
couldn't.
Cheers
Alan
On Fri, 18 Aug 2000, Rybarczyk Mikolaj wrote regarding
"ODP: [ADMIN] I screwed it up, my installation :(": > I am
not sure but maybe this is a simple problem > with the
PostgreSQL start-up script. The script > is
/etc/rc.d/init.d/postgresql. There is version > checking in
it, find line: >
> if [ `cat /var/lib/pgsql/PG_VERSION` != '6.5' ]
>
> or something like that (it depends of your instalation).
> Then find your PG_VERSION file in your data directory,
> check real number in the file (perhaps 7.0) and place
> it in the script instead of your old version (perhaps 6.5).
>
> This should help.
>
> Mikolaj.
>
--
AlphaByte: PO Box 1941, Auckland, New Zealand
Specialising in:Graphic Design, Education and Training,
Technical Documentation, Consulting.
http://www.alphabyte.co.nz
[ADMIN] I screwed it up, my installation :(
Hi all, First a bit of background, I am using RH6.1 on intel and my window manager is HelixGnome with Sawfish. Now, I sure hope someone can help me, I started with a functioning pgsql 6.5.2-1 and decided to upgrade it with the current version 7.0.2-2. I saw on the Download page the comment about initdb and tried to find info about it, ending up in the Installation How-To so I followed it. On the first couple of attempts to install I kept getting an error saying that libpq.so.2 was needed by the current installation and hOpla, but logging in as root (yeah I know, real dumb) and running the installation from there the packages seemed to install ok (I downloaded the whole set of packages because I want to really explore what I can do with pgsql). But then my problems really seemed to start (or at least now become apparent) because then when I tried to restart the postmaster service I got an error saying: Checking postgresql installation: old version. Need to Upgrade.See /usr/doc/postgresql-7.0/README.rpm for more information. I tried to uninstall the old version but I can't using rpm or Gnorpm (which usually crashes anyway), I now realise the installation of the new version seems to have failed despite the fact that when it installed all the packages hash marks indicated the progress. So now it seems I am in a limbo-land where I cant go either one way or the other :-( Before anyone tells me I went about this a**e-about-face you are absolutely right and I am suitably shamed (never done anything so stupid before -- on this computer that is ;-) So please help me, I am desperate. Alan -- AlphaByte: PO Box 1941, Auckland, New Zealand Specialising in:Graphic Design, Education and Training, Technical Documentation, Consulting. http://www.alphabyte.co.nz --- -- AlphaByte: PO Box 1941, Auckland, New Zealand Specialising in:Graphic Design, Education and Training, Technical Documentation, Consulting. http://www.alphabyte.co.nz
[ADMIN] Still trying to get pgsql to run
For the next installment, I have reinstalled the new version of pgsql after having installed the older version and now cannot get it to run. Any help would be appreciated. This is what I get. [root@alphabyte abyte]# /etc/rc.d/init.d/postgresql start Checking postgresql installation: looks good! Starting postgresql service: Database system in directory /var/lib/pgsql is not compatible with this version of Postgres, or we are unable to read the PG_VERSION file. Explanation from ValidatePgVersion: Version number in file '/var/lib/pgsql/PG_VERSION' should be 7.0 , not 6.5 . No data directory -- can't proceed. failed. [root@alphabyte abyte]# So I change P_VERSION to read 7.0 and get this: [root@alphabyte abyte]# /etc/rc.d/init.d/postgresql start Checking postgresql installation: old version. Need to Upgrade. See /usr/doc/postgresql-6.5.2/README.rpm for more information. [root@alphabyte abyte]# Thanks Alan -- AlphaByte: PO Box 1941, Auckland, New Zealand Specialising in:Graphic Design, Education and Training, Technical Documentation, Consulting. http://www.alphabyte.co.nz
Re: [ADMIN] Still trying to get pgsql to run
Thanks, seems to have done the trick. Funny though because the last time I tried that it didnt work, in fact it did all kinds of nasty things. Alan On Thu, 24 Aug 2000, Aimin Pan wrote regarding "Re: [ADMIN] Still trying to get pgsql to run": > I deleted all files and directories in /var/lib/pgsql/ and it > worked. > -- AlphaByte: PO Box 1941, Auckland, New Zealand Specialising in:Graphic Design, Education and Training, Technical Documentation, Consulting. http://www.alphabyte.co.nz
