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.
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
Top 50 recent answers are included
Related Tags
linux × 963mysql × 332
oracle × 167
postgresql × 156
sql-server × 140
ubuntu × 85
mariadb × 48
oracle-11g-r2 × 44
mongodb × 41
windows × 41
installation × 41
sql-server-2017 × 40
replication × 39
centos × 39
innodb × 34
backup × 31
performance × 28
oracle-12c × 26
mysql-5.5 × 25
redhat × 24
db2 × 22
mysqldump × 21
restore × 20
configuration × 20
memory × 19