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

Mongo exception: connect failed on reboot

I have Mongo installed on Ubuntu 16.04 machine, on VMWare. I start it using "mongo" command, last week there was no problem. But recently, it gives this error: MongoDB shell...

Asked on 02/12/2021 by jack jack

2 answer

PostgreSQL - How does multicolumn B-Tree index work with order by on 1st column and IN lookup for 2nd?

I created such table (similar to example from http://use-the-index-luke.com/sql/example-schema/postgresql/performance-testing-scalability )CREATE TABLE scale_data ( section NUMERIC NOT NULL, id1 NUMERIC...

Asked on 02/11/2021 by ALZ

2 answer

Postgres Minor Version Upgrade from 11.4 to 11.7

I am new to PostgreSQL database. I want to upgrade the PostgreSQL version from 11.4 to 11.7. what are the steps involved can anybody tell. It will be helpful if...

Asked on 02/10/2021 by Nihar

1 answer

How to get lsn(xid) numbers of transactions from WAL file?

I'm looking for a way of getting transactions from WAL files.Basically I need their LSN numbers.(ideally both transactions LSN numbers and WAL files first and last LSN numbers)...

Asked on 02/06/2021 by isxaker

1 answer

connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter...

Asked on 02/06/2021 by DavyGravy

1 answer

ORA-00205 error during the startup of physical standby database

Steps I have followed:-Created a physical standby database by using DUPLICATE TARGET DATABASE.Then checked the log gap between these two databases which was fine and in sync.After that standby database...

Asked on 02/06/2021 by Aritra

1 answer

For each row, find the next closest value in another table (Teradata)

I've seen a few close examples here but I'm not quite getting something close enough for me to noodle out a fix. I have events, where trucks come in and...

Asked on 02/05/2021 by Trives

1 answer

Problem Insert Data to connected tables postgresql

I have 2 existing tables: ‘projects’ and ‘units’.The two tables are connected through the project id. In the table 'projects' the column is called ‘id’ and generates every time a...

Asked on 02/05/2021 by Malks

1 answer

SQL Server Application paths to include in server backup?

I have an instance of SQL Server 2017 Standard installed on a physical server running Windows Server 2019. I'm currently working with our server administrator to configure the server backup,...

Asked on 02/04/2021 by John-Rock Bilodeau

1 answer

Mariadb/MyISAM: Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an

We have a db with around 150 tables in, of which about 30 or so are partitioned as such :ALTER TABLE `myTable` REORGANIZE PARTITION PFUTURE INTO (PARTITION P201910...

Asked on 02/04/2021 by FreudianSlip

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 30)

Ask a Question