I am attempting to make a backup & restore of a production Postgres server (9.6 Windows) for development testing. This server is standalone and does not need to do streaming replication.
I have used
.\pg_basebackup -Ft -Z -D D:\pgbackup\default -P -U postgres -Xf --checkpoint=fast
I am using
-Xf option since the database is quite large and I want to compress it. Using the option
-Xs from the standby server is too slow, and using this option on primary server requires the tablespaces to be empty.
After backup the tar files are extracted into base and each tablespace. I’ve created a recovery.conf with single entry
standby_mode = off
However on starting postgres I get the error
2021-06-17 10:39:27.211 CAT,,,4664,,60cb0a3f.1238,1,,2021-06-17 10:39:27 CAT,,0,FATAL,XX000,"could not connect to the primary server: FATAL: the database system is starting up
What is the correct procedure to create a standalone backup?
I am trying to come up with a strategy of keeping up with daily database update process using "standby" restore mode.
I am getting 24 log shipping files (for the previous day’s each hour transaction log files) from a third party’s FTP site. I would update these 24 files on a nightly run. I get these files originally in SQB file formats, and then I have a tool and script to convert these SQB files into BAK file format.
Now, I am trying to come up with a strategy of continuous back up plan.
Database does not have to be updated or modified, but just to be read. Do I restore each transactional log file as "standby" all the time and just leave them as "standby" mode?
I am planning to create a separate database to retrieve only necessary data from some tables from this "read-only" database.
I have one more question. If I accidentally run a script to restore this database as "NoRecovery or Recovery" mode, is there way to change the mode back to "Standby" by running a script or do I have to restore full bak file again as "Standby" (do the whole process again)?
Hello! After reinstalling GSA SER Projects cannot be restored from file *.ser. File size 600 Mb
Pls help. I had many projects in those file.
If a clockwork soul sorcerer is in a social situation and has disadvantage on a persuasion check, then uses Restore Balance, would anyone be able to see that?
I haven’t found any information on is it possible to restore a Oracle non-cdb 19.8 backup into a container-database PDB (still 19c) , or not. The method i have found is not suitable for my situation (convert non-cdb to pdb using DBMS_PDB.DESCRIBE – that seems to imply that the database type is converted + all data is copied during this operation, which is not the same as restoring from a backup). *Export/import/Golden Gate are not viable options for me.
Has anyone had a similar challenge and what was the best way to get a non-cdb to get into pdb form.
You channel positive energy to heal the living or damage the undead. If the target is a willing living creature, you restore 1d8 Hit Points.
Two Actions (somatic, verbal) The spell has a range of 30 feet. If you’re healing a living creature, increase the Hit Points restored by 8.
Heightened (+1) The amount of healing or damage increases by 1d8, and the extra healing for the 2-action version increases by 8.
I’m reading this as a two action heightened 2-nd level Heal restoring 2d8+16 Hit Points. Am I interpreting this correctly?
In the recently released preview of the Wild Magic Barbarian that will be in Tasha’s Cauldron of Everything (preview here), I noticed the 6th level feature ‘Bolstering Magic’. This feature has two applications. One acts as a Bless-type option, the second one reads:
Roll a d3. The creature [you’re touching] regains one expended spell slot, the level of which equals the number rolled or lower (the creature’s choice). Once a creature receives this benefit, that creature can’t receive it again until after a long rest.
Suppose this effect is used on a Warlock of level 7 or above, and for the sake of argument suppose we rolled a 3 on the d3. All of their spell slots are of spell level 4. What happens?
- Nothing, the Warlock doesn’t have the right type of spell slot to regain
- The Warlock has (expended) spell slots of Level 4 and higher, and now has a level 3 spell slot
- Something else happens, namely …
Made a mistake with mysql restore on the production site instead of the staging one. Can I use mysql general log to restore? It seems general log is all I have. I dont seem to have a binlog with MariaDB’s Aria storage engine.
What should I do now? Anyone has any experience using general log to recover the database?
One of the Lair Actions of a lich does the following:
The lich rolls a d8 and regains a spell slot of that level or lower. If it has no spent spell slots of that level or lower, nothing happens.
A lich decided to attack the party, using some of its spell slots in the process, and then retreat to its lair to recover and await the party.
If the party manage to find the lich’s lair within 8 hours (i.e. before the lich can long rest and recover its spell slots that way), would the above Lair Action have (likely1) restored all of the lich’s spent spell slots (excluding the 9th level spell slot, obviously)?
Or is there some reason this wouldn’t work, such as the Lair Actions only being "active" when there are enemies of the lich actually in the lair (i.e. during combat)?
1 I say "likely" because there’s a dice roll involved, so technically it could not roll the numbers it needs to actually recover all its spell slots, but let’s discount that possibility as I imagine an hour or so of rolling will almost definitely roll the numbers that it needs eventually.
Hi Guys, do you know how to recover the deleted projects? I deleted all of my projects and I don’t have any back up left. Please help 🙁