Hello,
Thanks a lot. I finally manage to install Postgres-6.4.2
But, the new Postgres still unable to run postmaster.
The system can't fine the database. My prevoius Postgres has a different
directory for the database, and now it keep pointing back to the old directory
(the old Postgres 'home' dir)
I'm using GNU bash, version 1.14.7(1)
I've tried editting the .bash_profile as below,
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
export PATH MANPATH PGLIB PGDATA
then execute: $source .bash_profile
My new Postgres is installed in the /usr/local/pgsql directory, wheras the old
Postgres was installed in /usr/include/pgsql and database created in
/var/lib/pgsql directory.
The system still recognize the Postgres "home" as in /var/lib/pgsql.
How should I change that?
Thank you very much.
Reagrds,
LCH
Frans de Wet wrote:
> You have to either uninstall the old postgres RPM before upgrading or remove
> all the old postgres executables out of the /usr/bin directory ... they are
> causing it ... had the same problem just a few days ago ...
>
> Frans
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of hoelc
> > Sent: Wednesday, February 10, 1999 5:30 AM
> > To: [EMAIL PROTECTED]
> > Subject: [ADMIN] having problem with postgresql-6.4.2
> >
> >
> > Hello,
> > I'm trying to install postgresql-6.4.2 on my RedHat Linux 5.0.
> > and got this error massage when creating database installation from
> > postgres superuser(postgres), with command ' $ initdb '
> >
> > :
> > { this is the end part of the massage, where I notice some error }
> > :
> > initdb:Creating template database in /var/lib/pgsql/data/template1
> > Running:Postgres -boot -C -F -D/var/lib/pgsql/data -Q tempalte1
> > syntax error 2305 : parse error
> > Creating global classes in /base
> > Running:postgres -boot -C -F -D/var/lib/pgsql/data -Q template1
> > Adding template1 database to pg_database...
> > Running:postgres -boot -C -F -D/var/lib/pgsql/data -Q template1
> > </tmp/creat.498
> > Too Large Allocation Request("!(0<(size) && (size)<=(0xfffffff)) :
> > size=0[0x0]", File:"mcxt.c", Line:232)
> > !(0<(size) &&(size)<=(0xfffffff)) (0)
> > initdb:Could not log template database
> > initdb:Cleaning up
> >
> > Please advise how should I solve this problem.
> > Thank you vey much.
> > Regards..... LCH
> >
> >
