postgresql – backup using gzip slow

We are currently backing up some schemas in Postgres using this command:

pg_dump -h localhost -n test_schema mydb | gzip > /data1/backup/test_chema.dmp.gz

And we are getting a rate of 50 Megabytes per minute, which is pretty slow, we think this could be improved.

Disk seems to be OK so is CPU.

Any thoughts on how this can get improved?

: GSA SEO & Marketing Forum ::.

can some one tell what i should do i create a email and i test it work great receive  msg  from websites that GSA register.
and 0 articles with all or my campaign is 0 article only the redirection here pictures and the 304 redirection  link only no comment no article and the stupid phpinfo exploit that’s not exploit at all her is the list >> 
plz help 

Selling Other – Powerful Affiliate Software for Sale ($12.900 Package Going for $2800). INSANE Savings for You!


I’m selling my license of Post Affiliate Pro. I have a professional license that I no longer need. This is now known as Elite @

You can buy this on cloud for approximately $200/mo but why keep paying for cloud and never really own it when you can buy it from me and keep forever.

I also have more perks such as greatly reduced updating fees of only $199/y compared to almost $900/y that it normally costs. These are optional but would have to be performed at least once after taking over. I will subtract that from the final price.

In addition to that, you will also get a small desktop app that can connect with the website and monitor all activity where the package is installed.

This is for anyone who wants to start or already has and would like to upgrade their own affiliate program. Anyone who wants to make money by re-selling or leasing to a third party. And anyone who just wants to buy something valuable @ an insane discount to later decide what to do with.

My price is $2800. I took $200 off for the update that would need to be done.

Upon buying you will get a URL to login with an email/password combo and your job is to change the login details and buy the $200 update which will give you 12 months of extended downloads for all newest updates. That’s all.

Installing and configuring is very easy, even I did it with no prior knowledge long ago. Also, you don’t have to update every year but it’s recommended if there’s any big security fixes or upcoming features that you want.

Alternatively, and I don’t know why you’d do this if you can host it yourself, the company has offered me to trade in my license for a discounted cloud option, so if you want to do that, you can negotiate with them and get a more affordable cloud solution. Just letting you know that it’s possible in case that you don’t know how to host it yourself.

To buy this from me, Escrow or PayPal is fine. You can pay directly here on DP and get a feedback from me as well. You must have a valid linked PayPal account on the forum for this to work. Go to your account’s settings and set it up.

I don’t need this anymore so that’s why I’m selling it cheap. This is not something that sells often, so if you’re reading this, it means it’s still up for grabs. Deal of the day for one lucky buyer!

All the best,


Google Updates and SERP Changes – July 2020

WebmasterWorld’s monthly look at Google’s SERPs changes.

google sheets – Is there a way to filter for a row that matches AND the row above it?

Perhaps not an ideal solution, but I guess you can create a new column and fill it with something like


(assuming the value to filter on is in column A) and filter on that column. Afterwards, you can hide or minimize its width.

command line – Combining two dual-mono wav files into one stereo wav file

Well, I have batch files for converting dual-mono files to mono, and two mono files to a stereo file but would rather do in in one step if possible. Here’s my present batch file:

/ffmpeg -i Track07_ST.wav -c:a pcm_s24le -ac 1 TRACK07.WAV
/ffmpeg -i Track08_ST.wav -c:a pcm_s24le -ac 1 TRACK08.WAV
ren Track08_ST.wav TRACK08_STo.wav
/ffmpeg -i Track07.wav -i Track08.wav -filter_complex “[0:a][1:a]join=inputs=2:channel_layout=stereo[a]” -map “[a]” -c:a pcm_s24le TRACK08_ST.WAV
del Track07.wav
del Track08.wav


web server – How properly manage several webapps on one domain nginx

as in title I’m trying to setup several webapps (nextcloud, roundcube) on one domain, let’s say, without using cname subdomains. I installed webapps in default location /usr/share/webapps/ and I want this directory to be also my webroot server. How can I achieve effect like this: -> /usr/share/webapps/index.html -> /usr/share/webapps/nextcloud/ -> /usr/share/webapps/roundcube/

using (if possible) several nginx configurations file? For example, nginx config for nextcloud contains few server blocks while roundcube config from archwiki (server is running Arch Linux) is all written in one location block. How should look nginx configuration to make all this working and with option to easily add new webapps?

Camera dropped and the lens is now bent to one side and cannot zoom in and out

It’s already broken, there’s very little you can do to make it better or worse.

Time for a new lens. The cost of repair would be significantly higher than a replacement lens.
You can get those for $£€ 40 on eBay [even less if you’re willing to wait out an auction], because so many people get them as part of the kit, then immediately want something better.

matrices – Gradient of kernel cost function

I am trying to understand the gradient of this cost function from this paper matrixCompletion:

$$ L = K_{XD}Z + frac{1}{2}Z^TK_{DD}Z + frac{alpha}{2}Tr(K_{DD})$$

where $K_{XY}=exp(-frac{|X-Y|^2}{sigma^2})$ is the RFB kernel matrix, D and Z are two matrices.

The gradient of L w.r.t D is given by :

$$nabla_{D} L = frac{1}{sigma^2} (XQ_1 −DGamma_1) + frac{2}{sigma^2} (DQ_2 −DGamma_2),$$

where $Q_1 = -Z^T odot K_{XD}$, $Q_2 = 1/2(ZZ^T + alpha I_r)odot KDD$, $Gamma_1 = diag(1^T_nQ_1)$, and $Gamma_2 = diag(1^T_rQ_2)$, with $1_n in mathbb{R}^n$ and $1_r in mathbb{R}^r$.

Thank you in advance for any help to understand how this formula has been obtained.

php – is_user_logged_in returns false when I access certain pages

I’m working on a single page application built with WordPress and Vue.js, I used add_rewrite_rule to redirect all sub-pages of projects/ to index.php. Only logged-in users can access the application. If a user isn’t logged-in a redirect to wp-login.php will be returned.

Here’s the code I used in functions.php to achieve what I mentioned above:

// Redirect users who are not logged-in
add_action('template_redirect', function () {

    // Front end only and allow access to ajax functions
    if (is_admin() || wp_doing_ajax()) {

    // Redirect all pages to the login page if user isn't logged in
    if (!is_user_logged_in()) {

// Remove all default WP template redirects/lookups
remove_action('template_redirect', 'redirect_canonical');

add_action('init', function () {
    // Redirect homepage or all requests that start with /projects to index.php so the Vue app
    // is loaded and 404s aren't thrown
    add_rewrite_rule('^projects((/.*)?)', 'index.php', 'top');

The issue is whenever I access any sub-page /projects/page/etc I do get redirected to wp-login.php even though I’m logged in! And the strange thing is this happens only on the production server, development and staging servers all work fine.

I used a var_dump(is_user_logged_in()) inside the callback of the template_redirect action and the result is false.