For our restore performance in PostgreSQL, we used pg_dump with the default plain format (which worked okay). But then we started to get time / space improvements when using pg_dump -Fc | gzip -9 -c > However, when we tried to create the database anew, the restore took almost half a day to...

How can I add accumulative sum for 12 month started from JAN to DEC. If data in JAN is zero, then accumulative sum from FEB to JAN. If data in FEB is zero, then accumulative sum from MAR to FEB and so.

We have a SQL Server database that contains our most recent data. We need to replicate the content into several other servers. But for some reason, we can't use the replicate / sync function to sync to other SQL Server instances. What would be the best way to do this? Thank you!

I have realized after 2 yrs of being hacked that I have always had a desire to work with computers. It was because of the continuous hacking I decided it would be in security. I have been a nurse for 30 yrs. I'm not unhappy with my career; it's that I believe I can help the health field and others...

We currently have a dedicated server that has a MongoDB database around 10GB. We need to do daily backups but we can't have downtime. Would it be possible to use a replica on a single disk (with two instances of MongoDB that's running on different ports) and just take the second one offline /...

We have letterhead loaded in drawer 4 and 2 on the printer. I have the IBMi printer file set up to go to drawer 4. When it runs out of paper in drawer 4 we would like it to automatically go to drawer 2, The printer is set to do that but since I specified drawer 4 on the IBMi, it will not do that. I...

I view AutoCAD drawings via Windows file view. In AutoCAD v12, the thumbnails have a white background. In AutoCAD v15 the background is black. Is there a setting to save an AutoCAD v15 thumbnail with a white background?

anyone can help me some times in lotus notes whenever user try to login in lotus notes the error comes unknow erroe from icc i have done all the related things like copy another copy of icc file it work for some time but after restart the system same error is coming . i also reinstall the lotus...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy