Re: Problems in restoring backups

[Tom Obrien]

Hi all,

I succefully insinstalled Dspace 7.6 on Ubuntu 22 and I am in the process of migration database from 5.3 to 7.6. However I have encountered the following challenge: 

sudo psql -f dspace.bak dspace
[sudo] password for library:
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  role "root" does not exist

Kindly assist.

Tom

[Mumanyi, Bravismore]

Hi Tom

Switch to postgreSQL user, usually "postgres" before issuing psql command.

Avoid running this as root.

Regards

---

From: dspac...@googlegroups.com <dspac...@googlegroups.com> on behalf of Tom Obrien <tobr...@gmail.com>
Sent: 11 June 2024 11:53
To: dspace-tech <dspac...@googlegroups.com>; dspace-tech <dspac...@lists.sourceforge.net>
Subject: [dspace-tech] Re: Problems in restoring backups

 

--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CAE%2B4i98QV_8GeosDFak_JziKc0RQZp9gLVBziP1mJUVLBFyX_A%40mail.gmail.com.

CAUTION -EXTERNAL SENDER: Please be careful when opening links and attachments. UNAM Directorate: Information & Communication Technology Services (DICTS)