Why would anyone ever want to dump/restore if you can just use pg_upgrade?


pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/reload typically required for major version upgrades, e.g., from 9.5.8 to 9.6.4 or from 10.7 to 11.2.

Source: https://www.postgresql.org/docs/12/pgupgrade.html

My related questions:

  1. So if there’s this nice, sleek pg_upgrade tool to do this in a much nicer and quicker way, why would anyone ever want to go through the whole dump/restore ordeal? I never knew about the existence of this until recently, and now I feel "something" for wasting so much time and effort when I could’ve just done a simple command.
  2. I’m not sure why they call it "dump/reload" here. Isn’t it "dump/restore"?

Is there a tool to calculate row size and which columns would go in_row_data? [closed]

I just watched a course about how MS SQL tables are stored on the disk and a big portion of that were the IN_ROW_DATA and etc., explaining how fixed-width columns are always in teh IN_ROW_DATA and if any other overflow they get put in the OUT_ROW_DATA and etc.

The lector showed a visual aid of how you can calculate which columns would end in the IN_ROW_DATA when deisgning the table (assuming you knew what you were doing and the data it’s going to store) is there some tool or website that can show similar information before the table is created?

I was thinking of a tool/site where I enter what columns I am thinking of making and it tell me based on that how many would be in the IN_ROW, how many in the OUT_ROW, how many bites a row could take, etc.

What would you tell about HTML 5/JavaScript browser gamedev to somebody who has been in a coma since 2014? [closed]

In 2014, I last attempted to make a browser game with HTML 5 and JS. That’s now 7 years ago. But it feels like 7 weeks, tops.

If this has been the the difference between 1994 and 2001 (instead of between 2014 and 2021), it would’ve felt like two different eras of human history. I have a feeling that not much has changed in the last seven years, however, but please prove me wrong.

One of the major issues I remember having was how bad HTML 5 Audio was. In order to get panning and volume changes, we were forced to rely on an Adobe Flash hack, which essentially made our games require Flash even though they were HTML 5-based except for simply outputting the sound. I assume that this is no longer the case.

To make it clear, I’m talking about "raw" coding in HTML 5 Canvas with plain JavaScript. I’m not talking about using some framework/library to hold my hand. And this is not because I’m such a masterful coder or anything, but simply because I found it more confusing to use any of the existing gamedev libraries at the time, and I suspect this is still the same. Keep in mind that I cannot afford to pay a single dollar, so any payware library (which may be great) is out of the question right from the very start.

Sorry if this is considered "too broad", but what should I know about the current "landscape", and have there been major/fundamental changes in the HTML 5 APIs, Canvas performance, etc.? Since 99.99% of all browsers now use Chrome under the hood, it feels like the "web" is now to be considered "Chrome" in practice. I mean, I don’t even have a Chromium-based browser installed at all. I only have Pale Moon (Firefox fork). I probably will download and test my stuff in NW.js, though, which is using Chromium.

I probably should mention that I was never able to figure out how to use WebGL, and that library (Three.js?) was so badly documented/designed that I could never figure out how to use it. Is the "good old" HTML 5 Canvas still not hardware-accelerated?

Would a custom table make more sense than a CPT in this case?

I am building a "multi vendor" type plugin to extend Woocommerce. There will be two types of new user roles: Vendor, and Non-Profit Org.

Vendors can list their products on the site, and users can choose at the checkout page which "Non-Profit Organization" they would like to donate part of their purchase to.

Ultimately, I would like the site owner to be able to have a curated list of all transactions, meaning how much is going to the Non Profit, how much goes to the Vendor. Preferably in chosen increments (monthly, daily, by individual order).

What’s got me stuck is figuring out how to let the "Vendor" and "Non Profit Org" accounts VIEW their respective transactions as well.

I don’t know if I should make two custom post types (Vendor Orders, Non Profit Orders) and just list extra info as Post Meta, as well as finding out a way to make sure ONLY the user assigned to the role can view orders for that role (in other words, one non profit can’t see records of another non profit).

Or, I am wondering if it makes more sense to create a custom table, which lists all valuable information (amount going to vendor, amount going to non profit, etc…) and just write custom queries to list the information based on the current user ID.

Would re-seeding the InstanceID column of sys.jobhistory table create issues?

I have two Production servers, one active, one passive. On the active server, application specific jobs are enabled and run all the time. Jobs on the passive server do not run.

On a regular schedule, we fail over between the servers to test our fail over process. Once done, we remain on the "new" server until the next scheduled fail over.

We have a custom service built that logs job statuses to splunk utilizing the InstanceID from sys.jobhistory. Problem is, when we fail over, the InstanceID on the passive node is MUCH smaller than the active one, and the service is checking for "max(InstanceID)" to know what record in history to begin pulling data from. My questions is around reseeding the identity column in sys.jobhistory as part of the fail over process to be max(id) from prod server + 1. In theory this should work, but I’m concerned with any potential issues.

How would I implement this in Raylib?

I am the developer of an upcoming 2d/3dRPG. I have a simple scene setup where there is a bridge over some acid and a cave entrance-like thing that I want to change the level with. I have used C and C++ in the past, and considered state machines, but I actually have no idea how to do this in raylib. plus I heard it’s only that good for transitioning from a title to a game or something, not loading levels on collision. also, the acid has to destroy the player.

any sort of help is appreciated. I also posted another question but no one seems to either see it, or answer it, and I posted it like 2 days ago.

Hi, would anybody know what the file name must be for adding html code to a child theme. for example, must the file be custom.php or custom.js

function my_scripts_method() { wp_enqueue_script(       'custom-script',       get_stylesheet_directory_uri() . "/js/custom_script.js        array( 'query' ),'',true );           } add_action( 'wp_enqueue_scripts', 'my_custom_script.js' ); 

Ive tried putting this code in functions.php and header.php to call the javascript. doesn’t work

The countdown javascript animation is in a file named custom_script.js in a folder named js, which is in the child theme folder named wpbdemo. The animation also had css and html, but that is working I think, as the countdown template is showing, its just not doing any movement. So, I think its the javascript code not working. The css is in style.css file and the html is in footer.php.

is postgresql identify would be continue in new version of PostgreSQL

Now I am use serial to generate table primary key in PostgreSQL 13, but today I found the ID jumps and not continue, it will waste many ids, I read the docs and found PostgreSQL add indentify as a SQL standard primary key generate. And the identify is continue? What should I do get a continue primary key id in PostgreSQL 13? I search from internet and recommand to use identify in new version of PostgreSQL but no one tell me the ID is continue.

enter image description here

Installing Fluent Forms + Formidable Forms in the same website, would it affect loadspeed significantly?

I have some functional needs that would only be satisfied by using both plugins at once (since neither of them has all functionalities I need, but just some/half of these functionalities). I am thinking about installing both plugins instead. I do not mind about incurring in extra costs or about how to integrate both (I am already covered regarding those two issues). What I am concerned about is page loadspeed…..

Do you think having both plugins (which do the same) at once would impact load speed significantly? Would you recommend me to install both given my situation? Would it be worth it?

Also, can pls someone explain me how would they impact load speed? (through adding more js and css, through ajax calls, etc?)

Thank you in advance !!!!