PostgreSQL failed to start

[rembrandt]

Hello,

Since a few days (weeks maybe) on two of my servers running PSA 7.5.x and Red Hat 7.3 PostgreSQL isn´t running anymore, rendering Spamassassin useless.

When i want to start it from the commanline it simply says: [failed[ and when i log in to PlesK and try to start it i get this:

Unable to update database parameters: Unable to change database login:
Unable to change administrator's login: Error while execute pg_manage:
Unable to start PostgreSQL. 1

Reinstalling the packages won´t help either...

Packagelist:
postgresql-7.2.4-5.73
postgresql-server-7.2.4-5.73
php-pgsql-4.3.10-0

Has anyone experienced the same problem adn found a solution for this problem?

Best regards.

 

[hardweb]

spamassassin is not related to postgresql... What do you get when you try to restart pgsql from command line?

 

[rembrandt]

commandline

Hy Hardweb,

From my original post:

When i want to start it from the commanline it simply says: [failed]

so i do:

/etc/init.d/postgresql start

then i get:

Starting postgresql service: [FAILED]

And there is there isn´t any more inforamtion given, not 1 logfile will give me any leads on what could be wrong.

Best regards

 

[rembrandt]

found the solution

After an extensive search i´ve found the solution: upgrade to the latest version available for RedHet 7.3.

First, backup the data:

tar -zcvf pgsql-7-2-backup.tar.gz /var/lib/pgsql

then get the packages you need from the PostgresQL website. You need these packages:

postgresql-7.3.4-2PGDG.i386.rpm
postgresql-devel-7.3.4-2PGDG.i386.rpm
postgresql-libs-7.3.4-2PGDG.i386.rpm
postgresql-server-7.3.4-2PGDG.i386.rpm

Then install the packages:

rpm -Uvh ./*rpm

after that, remove the old data:

rm -rf /var/lib/pgsql/data/*

and then start PostgresQL:

/etc/init.d/postgresql start

The Log in to PlesK to set the administrative user en password and presto! you´re up-and-running again.