Questions tagged [environment-variables]
The environment-variables tag has no summary.
29 questions
0
votes
1
answer
543
views
Environment variable $PGUSER does NOT take effect with Postgresql client?
For many years I have used to use the environment variable $PGUSER when I work with client tools such as psql/pg_dump/pg_restore.
Recently I build up a new PG13 server, the env var $PGUSER does NOT ...
- 413
-2
votes
1
answer
30
views
Online docs has incorrect JVM flag unsafe_aggressive_sstable_expiration for TimeWindowCompactionStrategy
I was installing the unsafe_aggressive_sstable_expiration and found out that there is a mistake in the documentation. The documentation told us that we needed to enable in the jvm -Dcassandra....
0
votes
0
answers
31
views
Environment Variables and MS Machine Learning Services
My apologies in advance if this is a naive or obvious question, but I am relatively new to this sort of thing. Here is my basic set up and dilemma:
I have an ETL process that starts with an API call ...
- 1
4
votes
1
answer
3k
views
psql \set an environment variable from the existing shell environment
I want to set up a psql variable from an existing shell environment variable that I can use in later psql commands.
I found the \set meta-command, but I'm not able to make it use an existing ...
- 434
1
vote
1
answer
290
views
My subdirectories under $ORACLE_HOME are missing
Im using oracle 11g. I cannot access the software products since they are missing. When I cd to $ORACLE_HOME, there are no files under it. They are missing. I cannot access the sqlplus. What to do in ...
- 11
1
vote
2
answers
330
views
how to find out if I am in azure or not?
I am talking about sql server here.
I can connect to azure.
I can also manage permissions.
But while doing some automation, I need to know if I am in azure or normal sql.
how can I achieve that?
I ...
- 17.3k
1
vote
2
answers
1k
views
PostgreSQL-Patroni-Cluster: Installing oracle_fdw, dependency problem
For Oracle to PostgreSQL migrations we're currently looking into ora2pg. However, the performance using either writes to file or direct read from Oracle and write to PostgreSQL have both been very ...
- 227
0
votes
2
answers
2k
views
Store LDAP bind credentials in environment variables for pg_hba.conf
I am working on setting up LDAP authentication for a PostgreSQL database and have added the following in my pg_hba.conf file:
# TYPE DATABASE USER ADDRESS METHOD
host all all ...
- 105
2
votes
1
answer
526
views
Environment variables in Postgres C extension
I cannot get environment variable in my PostgreSQL C extension code.
For example, this function always returns 111:
#include "postgres.h"
#include "fmgr.h"
#include <stdlib.h>...
- 35
2
votes
1
answer
128
views
Identifying elements in SSIS package built in MS Visual Studio 2008
I recognize that these are variables, but I am not sure how to add these elements to the package (or how they are added to begin with), what effect that have or even how to manipulate them. No right ...
- 75
0
votes
2
answers
2k
views
Scripts for setting the environment for Oracle Database Multitenant
When working on shared database servers with several Oracle Container Databases installed in different homes and different versions it can be hard to find the pdb you are looking for quickly. We used ...
- 1,078
0
votes
0
answers
1k
views
Bash Script Can't Connect to Azure Postgres using ENV Vars - "The Username should be in <username@hostname> format"
I have a bash script that exports ENV vars to use in connecting to an Azure Postgres DB (mydb.postgres.database.azure.com). For the user portion of that specifically it looks like this:
export PGUSER=&...
- 137
1
vote
1
answer
1k
views
Mysql - which cnf file to update
I have mysql 8 running on a ubuntu 20.4 server. I want to apply some setting to optimize the database so that it uses less ram for a web application. typically switching of the performance_schema.
...
- 155
2
votes
1
answer
5k
views
Variable to select database in SQL query
If I want use a variable in the FROM clause of a SQL query I need to use dynamic SQL. Which might be a pain if the query is long and complex.
There are few different ways of running a query from a ...
- 6,318
1
vote
1
answer
544
views
Mysql row-based binary logging behaving different in some versions of mysql (rows grouping)
Mysql row-based binary logging seems to have a different behaviour when grouping rows changes in some versions of mysql.
Let's assume the following statement update three rows:
UPDATE table_name ...
- 109