The posgresql file in /etc/rc.d/init.d/ should be replaced by his one I
attached for you ... the other does not work that well .. gives problems ...
the file also comes with the distribution ... think it is in a distribution
directory under the src directory when you unzip the postgresql-6.4.2.tar.gz
file or something .. hehe ... can't remember now ... ;-(
But ... the file I am sending you should work like a charm ... just remember
to be sure it is executable when you copy it into the directory by typing
chmod a+x postgresql
Hope this helps ...
See Ya
Frans
Oh .. a PS ... you will now be able to see any error reporting and stuff in
/var/log/messages ;-)
> -----Original Message-----
> From: hoelc [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 11, 1999 6:36 PM
> To: Frans de Wet
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] problem upgrading to postgresql-6.4.2
>
>
> 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
> > >
> > >
>
>
>
postgresql
