Alexander Coxon

pg_dumpall apparently has a -globals option that's supposed to backup everything, but the help for pg_dumpall shows a -g, --globals-only dump only

You can dump the whole PostgreSQL cluster with pg_dumpall. That's all the databases and all the globals for a single cluster. From the command line on the server, I'd do something like this. (Mine's listening on port 5433, not on the default port.) You may or may not need the --clean option. $ pg_dumpall -U postgres…

SQL Server

Answered Jul 2, 2024 · 9.5K Views Read answer →

What's the system wide way to get java_home Ubuntu?

The accepted solution byuser13742 assumes that the server definitely has Java installed. In case you're adding this to a centralized script for many servers it will give some errors like: dirname: missing operand Try 'dirname --help' for more information. To avoid that and only set JAVA_HOME Ubuntu if the server has a…

Java

Answered Oct 10, 2022 · 1.1K Views Read answer →

I reset my password at test. Salesforce login, why am I unable to access it now?

You can't use test.salesforce login to a Scratch Org. They are not Sandboxes. Use the URL for the scratch org (e.g. random-name-1234.my.salesforce.com). Using force:org:open should bring you back to the org, and you'll want to bookmark that URL for later access.

Salesforce

Answered Sep 23, 2022 · 1.7K Views Read answer →

How do I report with a Salesforce relative dates range?

You can use two filters for Salesforce relative dates, such as "Created Date greater or equal Jan 1, 2022 AND Created Date less or equal Feb 28, 2022", or you can use a relative date filter, such as "Created Date equals NEXT 2 MONTHS" or "Created Date equals THIS MONTH, NEXT MONTH".

Salesforce

Answered Sep 23, 2022 · 1.2K Views Read answer →

How to query ApexLog raw body?

It's in Apex Log, but you can't query/filter the log itself, only the exposed metadata (e.g. status or request). You would necessarily need to download each one using the preferred API (/objects/Apex Log/{id}/Body). This limitation exists because you can't filter on the logs. You also cannot search (SOSL) on Apex Log,…

Salesforce

Answered Sep 22, 2022 · 3.7K Views Read answer →

How does a password manager like keepass key file be used to increase the security?

In addition to acting as "something you have", the option to use a KeePass Key File allows for more flexibility in the other two factors ("something you know" and "something you are") without having to explicitly implement such behaviour in the application. Example 1: "Something you know" could be run through a custom…

SQL Server

Answered Dec 29, 2021 · 1.6K Views Read answer →

Can a phone be tracked without a sim card, especially with the involvement of authorities like the police?

To know the answer of - can a phone be tracked without a sim card, you must understand that a SIM identifies you with your network operator; it is necessary to be able to receive calls and to bill you for calls you make. Without a SIM, a phone is mostly useless as a phone, but it can still make emergency calls (in…

SQL Server

Answered Dec 23, 2021 · 2.0K Views Read answer →

Are there any malware test Sites to test web reputation similar to EICAR?

Unfortunately, Google Safe Browsing doesn't recognize "malware.wicar.org" of http://wicar.org/ as a malicious site. Instead, you can use http://www.ianfette.org/ which is, I guess, the Google Safe Browsing test site. Just in case you are wondering, Ian Fette, is a software engineer at Google.List Malware test Sites to…

SQL Server

Answered Dec 10, 2021 · 2.7K Views Read answer →

What is a self-signed certificate in the certificate chain? Why is my OpenSSL complaining about it?

First, it is quite correct for a TLS/SSL server to send the intermediate aka chain cert(s) but not the root cert; see rfc 5246 sec 7.4.2 or the slightly more verbose version in rfc 8446 sec 4.4.2. As Z.T. mostly correctly commented, -verify is the default for s_client (you don't need to specify it) and if you don't…

SQL Server

Answered Dec 2, 2021 · 3.7K Views Read answer →

git login command line-login to github from command line with multiple accounts

Git login command should be as shown below: username:password@github.com/ in the URL in the git push command

Python

Answered Jul 5, 2021 · 2.6K Views Read answer →

What are the Pros and cons of row-level security Microsoft SQL Server

Here are the Pros and Cons for SQL server row-level security: Pros Row-level security (RLS) reduces your application development complexity. Without RLS, you'd generally create filters with your queries or through ORM, or pass on filtering criteria to your procs. Once you have RLS in place, user1 sees what you desire…

SQL Server

Answered Apr 24, 2021 · 1.6K Views Read answer →

importerror no module named django core management

The default color scheme in ggplot2 i.e., scale_color_hue picks evenly spaced hues around the hcl (Hue-Chroma-Luminance) color wheel starting from 15.You can emulate ggplot default colors using the following function: gg_color

Data Science

Answered Apr 20, 2021 · 1.2K Views Read answer →