On Tue, Sep 27, 2022 at 09:47:16AM +0530, Rupinder Singh wrote: > 1. is it mandatory to create a system user named 'dspace' ? if it's related > to some permissions issue to /build or /dspace folder, why can't we grant > permissions to the existing user and do our work with just that? I just > cant understand this step.
The 'dspace' user is not necessary. What is necessary is that Tomcat has read/write access to DSpace's installed files and directories. I think that this user was invented for the case that you are installing Tomcat from source, solely to run DSpace, so it needs an account to run it. I always install Tomcat from the distro's package manager, and that process creates an account to run it. So I use that account (typically something like 'tomcat') to own the installed DSpace files. > 2. I don't remember setting any particular password for postgres sql, > because while running 'psql' commands, it asks for password for postgres > user. and I don't have that. do I need to reset the default password to > something of my choice, to perform backup /restore and other tasks on > postgres CLI. (I'm asking because, MySQL has this kind of mechanism). You can backup and restore *the DSpace database* using the password that you have configured as 'db.password'. But that won't give you access to the system tables which should also be backed up. Yes, you need to have control of PostgreSQL. It should be running in its own account. If you can 'su' to that account, then you can use 'psql' without knowing any passwords. If you don't have the password for the PostgreSQL superuser's OS account, but you do have the root password, you can do this in two stages: 1. 'su' and give the root password. You are now root, and can 'su' to any other account without a password. 2. 'su postgres'. You are now the DBMS superuser. You can set a password on the OS account, if you wish. You can use 'psql' to access any database in the cluster, without a password. You can set the password for the DBMS superuser role. (The OS user might have a different name in your system. 'postgres' is what the Gentoo Linux package for PostgreSQL installs.) -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street Indianapolis, IN 46202 317-274-0749 www.ulib.iupui.edu -- 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 Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/YzLo7K6mJ9JigxJw%40IUPUI.Edu.
signature.asc
Description: PGP signature
