ctrl S during boot
Enter the following lines at the command prompt pressing RETURN after each:
mount -uw /
Restore des binlogs:
mysqlbinlog –start-datetime=”2018-06-13 20:19:48″ –stop-datetime=”2018-06-18
16:51:00″ –database southpo_pm_dbname mysql-bin.001226
mysql-bin.001227 mysql-bin.001228 mysql-bin.001229 mysql-bin.001230
mysql-bin.001231 mysql-bin.001232 mysql-bin.001233 | mysql
sudo mkfs.ext4 -m 0 -F -E lazy_itable_init=0,lazy_journal_init=0,discard /dev/sdc
sudo mount -o discard,defaults /dev/sdc /mnt/back
SSH as admin (you should never have a problem here if you do set password for admin in the Control Panel > Users in DSM)
This will prompt you for a password use your admin password
Now you’ll be SSH in as Root
Type this, it will set the password of your choosing to the root account.
synouser –setpw root [PASSWORD]
some-boring-process is running in your current bash session:
ctrl-zto give you the bash prompt
disown -h %1(substitute the actual job number there).
or use screen or tmux
dirvish-change-expire.pl –vault srsouthp06 –expire=”+90 days”
parted -s /dev/sda set 1 lvm on
UPDATE `accounts_cstm` ca, recovery re SET ca.accounttypetwo_c = ‘Project Owner’ WHERE re.ID = ca.id_c;
SELECT * FROM `accounts_cstm` WHERE `accounttypetwo_c` LIKE ‘Proj%’
PGTune calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration. It isn’t a silver bullet for the optimization settings of PostgreSQL. Many settings depend not only on the hardware configuration, but also on the size of the database, the number of clients and the complexity of queries, so that optimally configure the database can only be given all these parameters.