New answers tagged

0

The following command has solved my problem sudo -u mongodb mongod --dbpath /var/lib/mongodb The -u mongodb after sudo runs the mongod with mongodb user. So,I don't have to change owner of folder /var/lib/mongodb to mongodb. Now, Mongodb Server is running as Service and also mongod instance.


1

you can set up master - slave replication using pgpool, master-master is not supported. To set up active - active replication you will need to use tool like SymmetricDS. Cheers!


1

Install it from PostgreSQL's own apt repository, adapted from these instructions. sudo apt-get install curl ca-certificates gnupg curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' sudo apt-get update ...


0

I had this problem in my MacOs please make sure that you entered your hostname correctly on your /etc/hosts file to do that> hostname command shows the "real hostname of your mac" and the the line below to /etc/hosts 127.0.0.1 your_host_name.local


1

If you make sure that there is no query running on the database currently that may be using a temporary file, it is safe to remove these leftovers.


0

MySQL does not offer a way to split the processing of a single query across multiple threads. Instead, I recommend to implement parallelism in the application layer. MySQL will happily process separate SELECT statements in parallel. If you have an auto-increment ID, you can subdivide the table into N parts by using SELECT ... WHERE id % N = 0. Use N ...


0

Actually here is a solution that worked for me: https://techierg.blogspot.com/2019/06/ubuntu-1804-mysql-this-installation-of.html Quote: Briefly, the solution is Edit the file /var/lib/dpkg/info/mysql-server-5.7.postinst sudo nano /var/lib/dpkg/info/mysql-server-5.7.postinst At line # 370, comment out the echo ALTER statement which would like ...


3

I came to a solution, if anyone is interested: For any reason, firebird ODBC 64-bits driver downloaded from oficial site comes with SQLLEN = 4 bytes. After some help, I managed to compile driver from source code, and the result seems to work with 8 bytes SQLLEN. In the compile proccess, I had a BUILD_DRIVER_VERSION error, modifying line 139 (...


0

The default is 0 (atleast) for Ubuntu / CentOS. If you change this on an running server with databases / tables, it may corrupt the files. Refer https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html in the paragraph "Meaning" of "0". Since you did not post your error message, I am assuming that you already have tables with index files and ...


Top 50 recent answers are included