Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 38

Why is Postgres service failing?

I'm setting up a ManageIQ appliance for development. When I updated the 'v2_key' encryption key to be same as production, my db connection croaked. Initially I got these...

Asked on 12/13/2020 by mike_butak

1 answer

What files of Mysql lib directory safe to be deleted and to be recreated with innodb_file_per_table settings?

I have brand new mysql 8 setup and installed on a centos 7. Unfortunately I forget to set innodb_file_per_table. I would like to dump the database and recreate with the...

Asked on 12/12/2020

0 answer

mysql workbench connection type tcp/ip over ssh with libpam-google-authenticator enabled

I'm attempting to connect to my MySQL Database using the Connection Method "Standard TCP/IP over SSH". I filled out all the SSH and MySQL connection details correctly, however I get...

Asked on 12/12/2020 by michelle

1 answer

Sync two sql server database(Active/Active) Mode

I have two sql server(SQL2016) Production-1 and Production-2 under one cluster with same database.I need real-time sync between both databases simultaneously like what ever changes in either A or B...

Asked on 12/11/2020 by Rai Micheal

3 answer

MySQL Shell dump utility - maximum possible chunk size?

The documentation https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html mentions that the min chunk size is 128kB. What is the maximum possible chunk size?...

Asked on 12/10/2020 by Mihir Rane

1 answer

I cant do a select by one of its parameters even if it exists in the database. Encoding issues? PostgreSQL

I have a postgresql database snapshot with the following structureid (integer / autoincrement)address (varchar)balance (integer)datetime (date) CREATE TABLE public.snapshots( id integer NOT...

Asked on 12/08/2020 by mouchin777

0 answer

How to fix SQL Agent Job using Windows Security after password change

I have some sql agent jobs that are using Windows NT Integrated Security to run (as specified in the Maintenance Plan's Manage Connections window)...eg. Translog backups. While logged in as...

Asked on 12/07/2020 by Chad Richardson

1 answer

Correlated subquery with common table expressions in SQLite

Yesterday I achieved a 500x performance boost after rewriting an EXISTS with IN. I did some investigation to find out why and finally came to the following example. Basically, we...

Asked on 12/07/2020 by nalzok

0 answer

Pushing or appending to JSON array in PostgreSQL 9.4

I have table where one of the fields is JSON array. I need to append received JSON array into that field without overriding existing values. Something like that:CREATE OR...

Asked on 12/07/2020 by genichm

3 answer

Have several 128 elements lists, need to obtain distance between them

Is storing them in a CUBE type field and then getting euclidean distance, (using <->) the only way? I can not save them as a list of...

Asked on 12/07/2020 by misterghost

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 38)

Ask a Question