New answers tagged linux
0
votes
Syntax error on query submitted to the Linux C library
I'm very sorry,
the problem was in my LOG1 macro :(
Anyway, thanks to White Owl to confirm that there is not limit inside the driver.
- 101
1
vote
How can I get a list of locales in PostgreSQL?
PostgreSQL uses locales from either the C library or the ICU library. If you want to use C library locales, as your question suggests, you can look at
SELECT collname FROM pg_collation WHERE ...
- 42.6k
3
votes
Accepted
How can I get a list of locales in PostgreSQL?
Postgres uses locales provided by the underlying OS. The manual:
PostgreSQL uses the standard ISO C and POSIX locale facilities provided by the server operating system.
To see all available locales, ...
- 167k
3
votes
Accepted
psql \set an environment variable from the existing shell environment
psql version 15 provides the \getenv metacommand to do this efficiently:
\getenv psql_var env_var
Gets the value of the environment variable env_var and assigns it to the psql variable
psql_var. If ...
- 29.8k
2
votes
Accepted
Does the order in which vms are shutdown impact the postgresql replication environment?
You can shutdown and restart primary and standby in any order you want; that won't cause a problem.
However, you could get into trouble if you keep the standby server down while data modifications ...
- 42.6k
3
votes
Accepted
SQL Server on LInux - OpenRowSet function only has access to files in /var/opt/mssql directory?
From here:
the /proc directory is NOT a real File System, in the sense of the term. It is a Virtual File System. Contained within the procfs are information about processes and other system ...
- 69.1k
0
votes
Unable to use data pump utility in Oracle to import data to another server
Data Pump runs on the database server and a Data Pump dumpfile import expects the dumpfile to be accessible on the database server, and not on the remote location where you started impdp. This is not ...
- 39.5k
Top 50 recent answers are included