There was never a PostgreSQL version 9, but that is beside the point here. Most of the time, you won't have a problem with such an upgrade. But each major version of PostgreSQL introduced some incompatibilities, which are documented in the release notes of the base release (9.6, 10, 11, ...), so you cannot be certain. You should read through all these release notes to get an idea what problems you may encounter, but the important part is that you test your application thoroughly. A test is the only way to make sure you won't run into problems.

As user changing SQL like ALTER USER etc is replicated as a statement, to prevent the replication of those, use SET SQL_LOG_BIN=0 in the session where the SQL is executed. Sorry, replication filtering won't help. ref: https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#sql_log_bin .

/proc//fd/0 can only be read by the process owner and root. /proc//cmdline can be read by all users.

While I am happy to accept other answers in case mine is wrong, I just came up with this answer by visiting the WSL website and https://youtu.be/48k317kOxqg . While I expect to do more research into the differences between WSL and WSL2, the video states WSL gives developers the ability to communicate with Windows processes using AF Unix sockets, and that an application can be running in both a Linux process and a Windows process at the same time. I guess a lot has happened since 2015 :).

Neither 1024-bit DSA nor SHA-1 are considered acceptable algorithms to provide an adequate level of security nowadays. 1024-bit DSA has a security strength of about 80 bits, and SHA-1 collisions can be created for USD 45,000. That means crafting a collision is within the realm of possibility of a reasonably well-paid software engineer, in addition to most companies and governments. The present minimum level of security in most contexts is approximately 128 bits. To achieve that, you need a 256-bit elliptic curve key or a 3072-bit RSA or DSA key, and a 256-bit or longer hash should be used as well (in OpenPGP, that's SHA-2 or, soon, SHA-3). DSA and ECDSA also have the downside that they require a random value for every signature, and if this value is ever reused for a different message, the entire private key is leaked. Most implementations use the technique described in RFC 6979 to avoid this, but these attacks are part of the reason why RSA and EdDSA are often used instead. Note that https://github.blog/2021-09-01-improving-git-protocol-security-github/ in SSH, which is a different protocol, but with similar characteristics, as is https://www.openssh.com/releasenotes.html . Debian https://keyring.debian.org/ for OpenPGP and APT will not accept SHA-1 hashes or signatures. Responsible parties either have already moved away from SHA-1 and DSA or are actively doing so. The alternatives are already well supported and have good performance characteristics, so there's really no excuse not to.

Debian has never been able to control, in addition to the inability to manage the monitor ' s authorization, the HDMI monitor has not yet worked. It's possible to do the right thing, but I put Ubuntu - it's been smooth and well done, better than Windows 10, with the first launch of the screen, HDMI is as good as it works.

I don't know. https://wiki.debian.org/Xfce#Install_Xfce_in_an_already_installed_system the packages containing the word gnome In the name.And there and you, I think, use a little overloaded structures. https://www.debian.org/doc/manuals/aptitude/ch02s04s05.ru.html :$ sudo aptitude purge '~ignome' a to completely remove (purge() Remote packages (including configuration files), instead of:$ sudo aptitude purge $(dpkg --get-selections | grep deinstall | cut -f 1) It's much more elegant to write:$ sudo aptitude purge '~c' a With regard to " why " , we need to look at the specific situation: which packages were in your possession before the experiment, which were installed/designed during the experiment, which were left at the end of the experiment, and to explore the dependence which prevented some of the packages established from being removed when the package was removed.You have a package. п1, he's got addicts saying: п2 | п3 (i.e., p2 or p3) and to meet this dependency п2♪And here you are for the experiment. п4which according to which: п3. package, respectively п3 to be installed.You've got a four-pack set: п1♪ п2♪ п3 and п4♪Finally, you remove the package. п4waiting for the package. п3 It will be removed, because it was established as a relationship with п4♪But there was no such thing as, as I remember, the package. п3 No. Removed because he is one of the dependence of the package. п1♪and in order to make a " full bag in your head " , remember that the packages are linked not only to " simple dependence " , depends. (which may be variant: " packages1 or package2 or ... " ) but also recommends♪ suggests and conflicts. and when type packages are installed gnome (which, in fact, is a meta-packet, i.e., a mere set of addictions) thousands of packages can be installed in cross-dependent areas, forming (instead of packages previously) an “Adian” multiple row, which, after the removal of the “star” package (started package)gnome() Could be attributed to the unsatisfactory state of hundreds (thousands? millions?) of different ways, and only one of those means will turn you exactly the package that you had before the installation of the " old " .

listen 443 ssl; Port number 443, not 433

♪ /etc/network/interfaces Write.auto eth0 allow-hotplug eth0 iface eth0 inet static address 192.168.1.2 netmask 255.255.255.0 gateway 192.168.1.1 auto eth0:0 allow-hotplug eth0:0 iface eth0:0 inet static address 192.168.1.3 netmask 255.255.255.0 auto eth0:1 allow-hotplug eth0:1 iface eth0:1 inet static address 192.168.1.4 netmask 255.255.255.0 IP addresses are naturally mine, and then DNS and routing.

If the usual log of errors (by default) /var/log/nginx/error.logor referred to in the directive error_log necessary block server() It is not enough to include an adorable log, it has a lot of information. In particular, he's useful in getting confused with location♪ You need to add a sweet log. debug to the directive error_log, like:error_log /path/to/log debug; I don't think it's worth telling the beautiful documents. http://nginx.org/ru/docs/debugging_log.html You may also have this section of documentation nginx: http://nginx.org/ru/docs/http/ngx_http_core_module.html#location

open_basedir is stored in a website configuration with masses for a hosting and basedir site, and in a block configuration <Directory /home/admin/web/****> type parameterphp_admin_value open_basedir /home/admin/web/***/ Weight configurations generate in the user folder, e.g. admin user /home/admin/conf/web/httpd.conf It is possible to edit the specific configuration of a particular site, but when the user or WEB are reassembled from the panel, these rights can be wrapped out of the template. The best solution is to challenge your rights and then edit the configurations that lie here./usr/local/vesta/data/templates/web/ Important clarification, editing through SFTP by side editors in Windows can break the template, which is best done through mcedit, nano or other consultan editors.

megacli I'm tired. Try a more convenient tool (both team and output format) - storcli♪ Version 1.19.04 lies http://docs.avagotech.com/docs/1.19.04_StorCLI.zip ♪What would be the beginning ofrest, try to move the disk into a state? HotSpare such a team:storcli /c0/eX/sY add hotsparedrive If you know the X and Y numbers, do the team.storcli /c0/eall/sall show And look at your disk. UGood♪

Emacs takes files with expansion. .pllike Perl. How can you turn it on Prolog?Documents fragment from SWI-Prolog:Using the PceEmacs built-in editor...3.4.2.1 Edit modes...Using the proper extensionIf the file ends in .pl or the selected alternative (e.g. .pro) extension, Prolog mode is selected.Using #!/path/to/... /swiplIf the file is a Prolog Script file, starting with the line #!/path/to/swipl options, Prolog mode is selected regardless of the extension.Using -*- Prolog -*-If the above sequence appears in the first line of the file (inside a Prolog comment) Prolog mode is selected.Explicit selectionFinally, using File/Mode/Prolog you can switch to Prolog mode explicitly.Source: http://www.swi-prolog.org/pldoc/man?section=pceemacs

After contacting the VPS company, it was accidentally decided that the xmpp-servers would be critical and correct. /etc/resolv.conf♪ It was:nameserver 127.0.0.1 nameserver 1.2.3.4 nameserver 1.2.3.5 (where 1.2.3.4 and 1.2.3.5 - ip address dns serves) Changed to:nameserver 1.2.3.4 nameserver 1.2.3.5 nameserver 127.0.0.1 And ejabberd immediately became successful with other servers:2016-09-18 15:16:08.784 [info] <0.455.0>@ejabberd_s2s:new_connection:456 New s2s connection started <0.462.0> 2016-09-18 15:16:08.785 [info] <0.462.0>@ejabberd_s2s_out:log_s2s_out:1315 Trying to open s2s connection: myserver.ru -> gmail.com with TLS=true 2016-09-18 15:16:09.516 [info] <0.449.0>@ejabberd_listener:accept:313 (#Port<0.6902>) Accepted connection ::FFFF:74.125.113.32:53716 -> ::FFFF:1.2.3.6:5269 2016-09-18 15:16:09.775 [info] <0.462.0>@ejabberd_s2s_out:wait_for_validation:434 Connection established: myserver.ru -> gmail.com with TLS=false 2016-09-18 15:16:30.178 [info] <0.472.0>@ejabberd_s2s_out:wait_for_validation:510 wait for validation: myserver.ru -> gmail.com (closed)

First of all, a screamed scruple to the program. dovecot I don't have anything to do with it. of All Demons whose starting-point crypts are in the catalogue (known as the standards) https://ru.wikipedia.org/wiki/Linux_Standard_Base It's a catalogue. /etc/init.dNot /usr/local/etc/rc.das in the example.For one demon, the full analog of your scruple will be:# /etc/init.d/dovecot status >/dev/null || /etc/init.d/dovecot start Second, he's just launching demons, starting-story violets with a parameter. status and, when called with this parameter, returning the result &quot; not zero &quot; , that is, launching Unemployed demons.If you have a program dovecot It really stops work, it's gonna work, and if, as you've written, the "wearing" program, as I understand, is still running, but it's not responding to online queries, it's not gonna help if you need to check the process(s) and his ability to work.The most appropriate answer, in my view, is to identify and address the reasons for &quot; dependency &quot; rather than to correct their consequences.

# Добавляем поддержку 32 бит sudo dpkg --add-architecture i386 # Обновляем список пакетов sudo apt update # Устанавливаем 32-битную версию пакета sudo apt install default-jre:i386

If you're working on a local car under windows 10 and you want to connect to another car with putty, the key should be in your car.To that end, there's a pageant (putty agent) in the set of putty, which will be quietly rolled into and be there.The program putty can pull the key on the remote car, so every time you get involved in the remote car, it'll start ssh-agent and give him the key to the windows 10.Check the installation Allow agent forwarding in putty on Connection-SSH-Auth And in fact, all the right programs under the windows can make an agent forwarding, like winscp: Now, if you're connected to some kind of minix machine, putty's gonna pull the keys to this car.There are more advanced diagrams when you connect from one car to another and try to connect to three, and there's no key left for the other (if there's a suspicion that the car is compromised).Details can be read at the end of this article: https://habrahabr.ru/post/122445/ Actually, with the right shape of the Forwarding, there's no difference, if you sit on the windows of the car or on the linux, it's gonna be about the same.Since it's not clear whether you need to go further with the Linux Machine, I'll just leave you a mention, if you want from windows 10 to throw the key in the linux machine and keep the copying out of it, then read about the construction. ~/.ssh/config Permit:Host * ForwardAgent yes

You need to form and execute a type team. wget -O имя_н урл_н:$ cat файл | while read n l; do wget -O $n $l; done In order to verify the correctness to avoid the actual downloading, insert echo between do and wget - teams will just be on the screen:$ cat файл | while read n l; do echo wget -O $n $l; done

Officially supported by the Debian team, the way the packages are randomly updated is https://wiki.debian.org/ru/Backports ♪ It collects packages of more new versions that are compiled in the old distributive environment. Let's consider your distributive jessie. You need to add or comment. /etc/apt/sources.list line:deb http://httpredir.debian.org/debian jessie-backports main contrib non-free After this method apt-get update There will be no change in the system updates, and old packages will continue to be offered. But if you need a new one, you can put it in a release:# apt-get -t jessie-backports install nginx Going to service. https://packages.debian.org/search?keywords=nginx&searchon=names&suite=all&section=all at this point, in the backports for jessie, the version of nginx is not the new one, 1.9.10.

At least we should try to get in. .bashrc♪UPD: Every version ruby has its gem. 1.9.1 must have been misplaced. gem environment will provide information on the ruby-related version.The way to solve the problem is to remove the package and download the ruby-lang.org, and to collect it. Then I'll put it. rvm (if there is a need for an old version ruby).