postgresql – logical worker replication says the publication does not exist, however this seems to actually exist?

I’m trying to setup logical replication between two database instances.

I’ve created a publication on the main db, and a subscription on the replica. Specifically:

on main db:

create publication chris for all tables; 

on replica db:

CREATE SUBSCRIPTION chris
    CONNECTION 'host=localhost port=5540 dbname=finder connect_timeout=10'
    PUBLICATION chris;

However for some reason the replica does not seem to be recognizing the publication (essentially ERROR: could not receive data from WAL stream: ERROR: publication "chris" does not exist) (logs from the replica):

Oct 20 18:18:31 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289): 2020-10-20 18:18:31.013 GMT (289) LOG:  background worker "logical replication worker" (PID 3035) exited with exit code 1
Oct 20 18:18:36 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289): 2020-10-20 18:18:36.020 GMT (3036) LOG:  logical replication apply worker for subscription "chris" has started
Oct 20 18:18:36 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289): 2020-10-20 18:18:36.022 GMT (3036) ERROR:  could not receive data from WAL stream: ERROR:  publication "chris" does not exist
Oct 20 18:18:36 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289):         CONTEXT:  slot "chris", output plugin "pgoutput", in the change callback, associated LSN 0/6BA6EC8
Oct 20 18:18:36 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289): 2020-10-20 18:18:36.023 GMT (289) LOG:  background worker "logical replication worker" (PID 3036) exited with exit code 1
Oct 20 18:18:41 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289): 2020-10-20 18:18:41.030 GMT (3039) LOG:  logical replication apply worker for subscription "chris" has started
Oct 20 18:18:41 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289): 2020-10-20 18:18:41.033 GMT (3039) ERROR:  could not receive data from WAL stream: ERROR:  publication "chris" does not exist
Oct 20 18:18:41 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289):         CONTEXT:  slot "chris", output plugin "pgoutput", in the change callback, associated LSN 0/6BA6EC8
Oct 20 18:18:41 test2 8y7qb8wz8ps875yrvpmg9c1zsffls4hy-unit-script-postgresql-start(289): 2020-10-20 18:18:41.034 GMT (289) LOG:  background worker "logical replication worker" (PID 3039) exited with exit code 1

The main db’s logs strangely seems to also be showing the same error (ERROR: publication "chris" does not exist):

Oct 20 18:22:56 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:22:56.545 GMT (514) CONTEXT:  slot "chris", output plugin "pgoutput", in the change callback, associated LSN >
Oct 20 18:23:01 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:01.555 GMT (515) LOG:  starting logical decoding for slot "chris"
Oct 20 18:23:01 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:01.555 GMT (515) DETAIL:  Streaming transactions committing after 0/6BA6E60, reading WAL from 0/6BA6E28.
Oct 20 18:23:01 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:01.555 GMT (515) LOG:  logical decoding found consistent point at 0/6BA6E28
Oct 20 18:23:01 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:01.555 GMT (515) DETAIL:  There are no running transactions.
Oct 20 18:23:01 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:01.556 GMT (515) ERROR:  publication "chris" does not exist
Oct 20 18:23:01 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:01.556 GMT (515) CONTEXT:  slot "chris", output plugin "pgoutput", in the change callback, associated LSN >
Oct 20 18:23:06 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:06.566 GMT (518) LOG:  starting logical decoding for slot "chris"
Oct 20 18:23:06 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:06.566 GMT (518) DETAIL:  Streaming transactions committing after 0/6BA6E60, reading WAL from 0/6BA6E28.
Oct 20 18:23:06 pgtestpublic 22rj0nr8pn1k0r3q8q6pxixp6hn2zi4i-unit-script-postgresql-start(260): 2020-10-20 18:23:06.566 GMT (518) LOG:  logical decoding found consistent point at 0/6BA6E28

However I do see the correct expected output from:

select * from pg_catalog.pg_publication;
select * from pg_catalog.pg_publication;

on the main database.

What could I investigate further? And what may likely be the cause of the error?

certification – Is reading ISO 27000 official publication sufficient to prepare for exam?

I was at the ISO/IEC 27001 official web page. I saw a the publication for the norm. It’s about 23 pages. So I was wondering if studying those 23 pages would prepare me enough, lets say at 80%, to passe exams for foundation, lead auditor or lead implementer exams ?

vampire the masquerade – What’s the publication history for the Kiasyd Bloodline?

The Kiasyd are a Lasombra Bloodline with Fae blood in them, which makes them a rather interesting take of vampire in general. However, trying to figure out the background for them is a little complicated, since bloodlines are not in the standard books for the 2nd edition and even the Revised edition doesn’t even mention them in the core book.

When and where was the Kiasyd Bloodline introduced as a sub-splat and in which books it appears subsequently till the 20th Anniversary Edition? Note that novels are out of the scope of this question.

Afaik, it has not yet appeared in 5th edition, but to future-proof, this edition is specifically cut.

wordpress – Does changing the publication dates of the posts on my recipes website penalize me on the SEO?

I have a website about recipes made with WordPress. I recently gave a new fresh look to my website by changing the theme and I also started to improve the pictures of the recipes to make them look nicer than before.

I am using the SmartMag theme, which orders the posts on my website on categories and then on chronological order. However, since I am updating the pictures of my recipes one at a time, sometimes it happens that the recipe for which I update the thumbnail picture is not shown in the homepage, because there are newer recipes that take its place in that category. I was therefore thinking to change the publication date of these updated posts, so that they would be shown on the homepage.

Is this strategy, however, going to penalize me from a SEO point of view? Note that I am only updating the pictures, so the rest of the article would remain unchanged. Therefore, I wouldn’t want to create a whole new post. Moreover, since my website is about recipes and not e.g. news, in theory there should be nothing wrong about changing the publication date, or am I missing something here?

soft question – Can the place of publication be harmful to one’s reputation?

What can be said about publishing mathematical papers on e.g. viXra if the motivation is its low barriers and lack of experience with publishing papers and the idea behind it is to build up a reputation, provided the content of the publication suffices that purpose.

Can that way of getting a foot into the door of publishing be recommended or would it be better to resort to polishing door knobs at arXiv to get an endorsement?

Personal experience or that of someone you know would of course also be interesting to me.

How can I show a publication on Facebook?

I hide a post on Facebook. I want to show it. How do I hide a post on Facebook?

Unique article of 500 words for your blog for $ 5

Unique 500 word article for your blog

Welcome to my article-based content service.

Here I will provide you with a 500+ word article related to the niche for your blog post or review article. My offer will give you 100% plagiarism free articles. Before starting the work I will

1 consult related topics
2 100% research of your keyword.
3 Try to include all kinds of information for your niche
4 full job
5 fast and reliable jobs
6 100% money back guarantee
7 No spam
8 No generator was used
9 error free grammar

You will receive me at any time for any reason. I will answer you as soon as possible.

Ask me I am giving you a 100% money back guarantee if the work is not correct.

Click on the order button.

for any questions
pass me at any time
Customer service 24 hours a day, 7 days a week ……………………..

.

What is SEO? What are the important types of SEO methods? …

Basically, there are two types of SEO techniques: on and off the page.

On the seo page it refers to the process that is followed on the website itself. Some of the tasks involved are:

Keyword research
Meta tags and title
Meta description
Robots.txt file
Sitemap generation
Content development
Image optimization

Off-page refers to creating links and promoting your website on search engines. Some of the most effective off-page activities are:

Guest Post
Presentation of the article
Press release
Social bookmarks
Classified Ads
Infographics presentation

.

javascript – View with GET and POST. Update field data before publication

I am starting to venture into MVC. I need to do a GET and POST in the same VIEW. If the user chooses a date, I have to update the fields (GET), only when I click save, POST.

I saw some places where it is easier to update the model in a partial view, I did, but without success.

View:

@model RevenueViewModel



Partial view:

@model RevenueViewModel

@using (Html.BeginForm("Arr", "Home", FormMethod.Post))
{
    

Data:

@(Html.DevExtreme().DateBoxFor(m => m.renevue_date) .ID("dat") .Type(DateBoxType.Date) .DisplayFormat("dd/MM/yyyy") .Width("250px") .OnValueChanged("refreshData") )

@(Html.DevExtreme().NumberBoxFor(m => m.Dep1Valor)
}

Model:

public partial class RevenueViewModel
{
    public DateTime revenue_date { get; set; }
    public decimal Dep1Valor { get; set; }

}

Controller:

public async Task ARRAsync(string date)
{
    if (string.IsNullOrEmpty(date))
        date = new DateTime(2020, 4, 1).ToShortDateString();

    var result = await apiService.getRevenueByDate(date);

    return View(result);
}

(HttpPost)
public IActionResult ARR(RevenueViewModel model)
{
    //Salva os dados
    return RedirectToAction("Home", "ARR", new { date = model.revenue_date });
}

It does GET and POST, however in GET it doesn't bring updated data. And in POST, it does not include the date in the model to be able to save and return the same View.

Any ideas to help?

Vlw

How to delete 'No Comments' on the publication pages

I am trying to remove the "No comment" on each of my posting pages. It is located at the top of the page, next to the publication date. Here is an example page with it. Here is an example (https://brothasonline.com/black-magik-cambatta-pardon-me-music-video/)

No (NO) trying to delete comments on the pages.