Rocky 8 upgrade to 3.0.78-1 import DB error

88 views
Skip to first unread message

Craig K

unread,
Aug 23, 2023, 1:33:00 PM8/23/23
to QUADStor VTL
uninstalled 3.0.76-1 and tried to install 3.0.78-1

# rpm -ivh quadstor-vtl-ext-3.0.78.1-rhel.x86_64.rpm
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
usermod -G vtprocgrp apache > /dev/null 2>&1
Updating / installing...
   1:quadstor-vtl-ext-3.0.78.1-rhel   ################################# [100%]
Performing post install. Please wait...
Reading old database from /quadstorvtl/pgsql/data
pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster directory
Importing old database to /quadstorvtl/pgsqlsys/data
pg_ctl: directory "/quadstorvtl/pgsqlsys/data" is not a database cluster directory
ERROR: Cannot import old database!!!
warning: %post(quadstor-vtl-ext-3.0.78.1-rhel.x86_64) scriptlet failed, exit status 1

QUADStor VTL Support

unread,
Aug 23, 2023, 1:35:04 PM8/23/23
to quadst...@googlegroups.com
Hi,

There would be a /quadstorvtl/pgsqlsys/data/import.log. Please send that file.
Please also send /tmp/qstorpgdb.log and qstorpgdbpatch.log



--
You received this message because you are subscribed to the Google Groups "QUADStor VTL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to quadstor-vtl...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/quadstor-vtl/02b0354b-6bf0-43f6-a1d4-cf9fa9e6e2b7n%40googlegroups.com.

Craig K

unread,
Aug 23, 2023, 1:57:54 PM8/23/23
to QUADStor VTL
#cat /quadstorvtl/pgsqlsys/data/import.log
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.9985"?
qstorpgdbpatch.log
qstorpgdb.log

Craig K

unread,
Aug 23, 2023, 2:19:04 PM8/23/23
to QUADStor VTL
I was able to reinstall quadstor-vtl-ext-3.0.76.1-rhel.x86_64.rpm and get the system back up and running.  But I would still like to upgrade to the latest version.

QUADStor VTL Support

unread,
Aug 23, 2023, 2:19:50 PM8/23/23
to quadst...@googlegroups.com
Hi,

Please uninstall the package
rpm -e `rpm -qa | grep quadstor-vtl-ext`

Then remove /quadstorvtl/pgsqlsys/ directory
rm -rf /quadstorvtl/pgsqlsys/
rm /tmp/qstor*.log

Reinstall 3.0.78.1 and then send to us
/tmp/qstor*.log files
/var/log/audit.log

Please then manually start the database
/quadstorvtl/pgsqlsys/etc/pgsql start

Then send to us the output of the following command
ls -l /var/run/ | grep postgresql
ls -l /var/run/postgresql/

Also please send
/quadstorvtl/pgsqlsys/pg.log if it exists



Craig K

unread,
Aug 23, 2023, 2:33:38 PM8/23/23
to QUADStor VTL

That worked!   It installed without errors.  Thank you very much for helping me so quickly.
Reply all
Reply to author
Forward
0 new messages