Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I am starting a new project within GCP and I am trying to choose a right tool for storing bank transactions:I don't need transactions, these will be basically write-only, no...
Asked on 09/18/2020 by Vojtěch
0 answerHi I've downloaded the file mysql-server_8.0.21-1ubuntu20.04_amd64.deb-bundle.tar from mysql site.I've extracted it to see below list of deb fileslibmysqlclient21_8.0.21-1ubuntu20.04_amd64.deblibmysqlclient-dev_8.0.21-1ubuntu20.04_amd64.debmysql-client_8.0.21-1ubuntu20.04_amd64.debmysql-common_8.0.21-1ubuntu20.04_amd64.debmysql-community-client_8.0.21-1ubuntu20.04_amd64.debmysql-community-client-core_8.0.21-1ubuntu20.04_amd64.debmysql-community-server_8.0.21-1ubuntu20.04_amd64.debmysql-community-server-core_8.0.21-1ubuntu20.04_amd64.debmysql-community-server-debug_8.0.21-1ubuntu20.04_amd64.debmysql-community-test_8.0.21-1ubuntu20.04_amd64.debmysql-community-test-debug_8.0.21-1ubuntu20.04_amd64.debmysql-server_8.0.21-1ubuntu20.04_amd64.debmysql-testsuite_8.0.21-1ubuntu20.04_amd64.debUsing mysql to build a web project. I want to understandwhat...
Asked on 09/13/2020 by Ajeetkumar
1 answerI have two tables with identical structures: Table1 and Table2id INT PRIMARY KEY, a TINYINT, b TINYINT, c TINYINT Table1 is actively being used by queries from...
Asked on 09/11/2020 by Phil W.
2 answerI join listings_tail table and materialised view cals_reviewed_wide_scaled on listing_id column of type integer. The table has around 1,5 billion rows and 2 mln unique listing ids. The MV has...
Asked on 09/11/2020 by Dmitriy Grankin
1 answercreate table CustomerTypes(CustomerTypeID int primary key identity(1,1),CustomerType varchar(11));insert into CustomerTypes(CustomerTypeID,CustomerTypeselect 1, 'Regular' union allselect 2, 'Business'create table Customers(ContactID int primary key identity(1,1),CustomerTypeID int references CustomerTypes(CustomerTypeID),FirstName varchar(25)not null,LastName varchar(25)not null,DOB...
Asked on 09/10/2020 by juclart ngouedi
1 answerI am using the following query answered by Marcello Miorelli. This query serves the purpose for normal backups but fails to determine the actual backup size of all the...
Asked on 09/08/2020 by l.lijith
1 answerI cannot run a "pg_upgradecluster" because there are problems with pg_dumpall. I have set the encoding to UTF8 everywhere on the server but pg_dumpall always uses"SET client_encoding = 'LATIN1';". Where...
Asked on 09/05/2020 by Thomas R.
0 answerI have following objects:(Rooms) which are (available in a certain period of time [in days]).During the time of availability they can be (booked) by (users). There are basically...
Asked on 09/05/2020 by empedokles
1 answerI believe my MongoDB did not have a clean shutdown. I am able to restart it in a new location which doesn't have all of my collections. If I try...
Asked on 09/02/2020 by Jay Gupta
3 answerI have multiple dump files and want to restore them with single command. something like thispg_restore -h localhost -p 5432 -U postgres -d gl_election...
Asked on 09/02/2020 by Irakli Ugulava
1 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP