Use /scripts/installpostgres without losing data

[Mic1]

In order to fix an issue with phpPgAdmin not properly recognizing databases, I have been able to run /scripts/installpostgres --force, however, this process removes the data from all the databases and they have to be manually restored. Is there a way to backup/restore them all at once or to prevent that data loss to begin with?

It's a CentOS system with postgres (PostgreSQL) 8.4.20

I tried something like the following:
Switch to the postgres user and run pg_dumpall -f fullpsqlbackup
Switch to root user and stop postgres then move the existing /var/lib/pgsql database out of the way.
setup a new pgsql directory with proper permissions and run /scripts/installpostgres --force
Run service postgresql initdb
Fix postgres
Switch to postgres user and run cat /var/lib/pgsql.bak/fullpsqlbak | psql then go back to root and run fixpostgres once more.

Unfortunately I don't know a whole lot about Postgres and this may not be the best way to go about it. If someone could provide some insight, it'd be much appreciated.

Thanks

 

[cPanelMichael]

In order to fix an issue with phpPgAdmin not properly recognizing databases, I have been able to run /scripts/installpostgres --force

Hello,

Have you tried resolving the issue without running that command? What's the specific issue you are encountering regarding the recognition of databases?

Thank you.

 

[Mic1]

I'm not sure precisely what causes it, but the issue is mentioned here: https://forums.cpanel.net/threads/postgres-automatically-creates-the-wrong-username.462771/

Reinstallation fixes it though I'd be happy to fix it without reinstallation if there's a better way.

 

[Mic1]

It looks like just running this directly also fixes it:
/usr/local/cpanel/bin/updatephppgadmin --force

Doing this prevents me from having to run installpostgres (which was resetting the password and making my formerly-created full backup not able to restore data).

 

[cPanelMichael]

Hello,

The following thread should help:

https://forums.cpanel.net/threads/backup-postgresql.240702/

Thank you.