Questions tagged [database-administration]

Questions about how to install, configure or tune the configuration of any database package.

Filter by
Sorted by
Tagged with
1 vote
1 answer
7k views

PostgreSQL getting error during pg_restore using pgadmin pg_restore: [archiver (db)] could not execute query: ERROR: role does not exist

I am trying to restore a database from one schema to another schema in PostgreSQL using pgadmin backup and restore utility. The backup is successful for the database A but when I try to do the restore ...
1 vote
1 answer
2k views

MariaDB: Should I configure the db-server using "/etc/my.cnf" or a file in "/etc/my.cnf.d"?

I am trying to configure MariaDB on a machine with Fedora 37: Workstation as its operating system. I expected to use /etc/my.cnf to configure the ports and such, however, the file contained an include ...
2 votes
1 answer
3k views

Is there any way to export MySQL Workbench 8 connections by shell commands?

I need to add some shell commands to my backup script to take a backup of defined MySQL connections in the Workbench. MySQL workbench allows this in its GUI: menu bar > Tools > Configuration >...
1 vote
2 answers
16k views

Postgres restoring replication, timeline conflict

I have a postgres database (version 9.4) with streaming replication (master, slave configuration). Lets call master db A and slave db B. The server running A failed and we had to do a switchover, ...
0 votes
1 answer
437 views

postgresql does no restart after changing postgres.conf or pg_hba.conf. This incident happened while i was trying to setup the postgresql BDR

I am not able to login to postgresql after restarting postgresql DB after configuring pg_hba.conf and postgresql.conf file. The snapshot of the error is attached for referral postgresql.conf / pg_hba....
4 votes
4 answers
1k views

Why is Hadoop not a Data Warehouse?

What are functional reasons why Hadoop cannot be a Data Warehouse On several sites one can see statements that a Hadoop cluster is not a replacement of a traditional data warehouse. However, I can't ...
0 votes
1 answer
804 views

MS Access form doesn't reflect recent data updates in Split Database's FrontEnd Forms

I have a front end and a backend to my access database. The VBA code, forms, queries etc are on the frontend and tables on the backend. The backend is on a server, about 5 different users are using ...
1 vote
3 answers
6k views

How to downgrade MS SQL Server 2019 Enterprise (evaluation) to Standard (purchased)?

SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message: I entered the activation code that is ...
0 votes
1 answer
805 views

Physical to Virtual Migration using Disk2vhd utility

We are currently in plan of migrating physical to virtual servers for both DB & App servers. Currently we are with SQL Server 2014 AOAG System. Databases are FileStream enabled. Currently we have ...
0 votes
1 answer
129 views

SQL Server file is in Is_media_read_only mode and can't apply TDE as a result

We have a database that we restored to a server and have been read/writing to that database for quite some time. We are now trying to apply TDE to that database and it will not allow us because it ...
0 votes
1 answer
87 views

MDSplus configuration: How to Change the Start Shot Number in an MDSplus tree?

When creating a new MDSplus tree, it's possible (or perhaps even required) to specify the smallest shot number for which data can be stored in the tree. Shot numbers are just index values identifying ...
1 vote
1 answer
311 views

Database Reverse engineering wizard Fails

I am using Visio 2019, trying to reverse engineer a Azure SQL server. I have successfully created multiple User data sources to use in the wizard using both our DB-admin user and my admin azure ...
0 votes
1 answer
384 views

Removing cluster node from always on cluster

I have an alwaysOn configuration for SqlServer 2012 that is installed in two node windows cluster. We had a disk failure on the second node, and there is no way to recover it, so I should run a new ...
1 vote
0 answers
67 views

Talend ETL tutorial [closed]

I need a good tutorial on how to use Talend ETL tool to automatically apply ETL process once new files are added to the directory. eg. (using file watcher). Any useful tutorial on talend is also ...
0 votes
1 answer
367 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
0 votes
1 answer
37 views

Link two fields in one table to one field in a second table, and create qry in Access

I am not sure if this is possible to do in Access; I have been googling forums and have not found a solution yet that works... Essentially there are a list of patients who provide multiple blood ...
0 votes
0 answers
148 views

Can you store encrypted passwords in ConnectWise Manage or will they always be plain text?

Title pretty much says it all. I need to store passwords for devices and configurations but I want them to be stored securely and encrypted. Can this be done with ConnectWise Manage?
1 vote
0 answers
82 views

How to connect to a PostgreSQL database?

I have a website written in Python / Django, and it is functioning well on a CentOS server (I wasn't one who set it up though). Now I want to set this website up locally on my Mac OS X or Linux system ...
0 votes
1 answer
2k views

What is the difference between DELTA & TOTAL columns in dba_hist_sqlstat Oracle?

I am using the following query to measure the performance improvement between two views SELECT PARSING_SCHEMA_NAME, SQL_TEXT, OPTIMIZER_COST, FETCHES_TOTAL, FETCHES_DELTA, ...
0 votes
1 answer
1k views

PostgreSQL 10 does not start after something

I'm handling a strange problem with one installation of PostgreSQL 10.4. One of the databases instances of PostgreSQL have stopped working after 7 months without issues. When this guy saw that the ...
1 vote
0 answers
132 views

How can I get call centre information from CallCenterAnywhere

Our organisation uses some software called CallCenterAnywhere to manage a customer services centre which it does well as far as I can tell, but we'd like to extract some information from it to present ...
1 vote
1 answer
51 views

What kind of tables would I need for the following person database made in MS Access 2003?

It's a database about actors and movies. I want fill it with their age too, so I can answer the queries: at what age they made their last movie. what is the average age when they made their movies? ...
5 votes
4 answers
11k views

Login to Oracle database without username and password

I want to login to a database by running an SQL file from a Unix script without supplying username and password (as root). Is this possible? The database is Oracle.
0 votes
3 answers
2k views

Is it possible extract/delete part of oracle data dump?

We have an Oracle 11g schema and data dump. As this dump is very large, I would like to extract only part of schema with data. Is this possible to achieve?
2 votes
1 answer
428 views

Database server for web browser [closed]

What is the most used database server for web browsers such as Chrome, Firefox, Opera, or Safari? Maybe I don't understand web browsers, but I am assuming they must have a database server the same way ...
1 vote
1 answer
4k views

Oracle SQLDeveloper locks up when using copy/paste

SQL Developer keeps locking up when I copy/paste text in a worksheet. It happens when I past into SQL Developer from itself or from another application and also when I past from Developer into ...
2 votes
2 answers
1k views

Oracle admin tool for mac os x [closed]

I'm looking for desktop admin tool similar to Navicat for Oracle in Mac os X. Navicat it's OK but it is quite buggy. Any other recommendations?
1 vote
2 answers
1k views

How to pull huge table (80 millions rows) from Oracle into SQL DB or SQL dump via VPN

I have the task to pull a huge table from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting which I access via Cisco VPN (Split tunneling is ...
2 votes
2 answers
16k views

How do I export the data from an Oracle SQL Developer query

How do I export the data from an Oracle SQL Developer query? I can create queries in it fine, but as to export?
1 vote
0 answers
752 views

check_oracle_health with OPS$Nagios account

I can login to my database via sqlplus with the OPS$ account, but i cannt seem to get it to work in with the nagios check_oracle_health. Im testing from the command line. nagios@servername:/usr/local/...
1 vote
0 answers
1k views

Installation of Oracle Database 11g Express Edition on Ubuntu 12.10

I intalled the Oracle database have followed this steps [link|http://meandmyubuntulinux.blogspot.in/2012/05/installing-oracle-11g-r2-express.html?showComment=1357195285714#c4393074524447658792] . 1....
2 votes
0 answers
356 views

How do I enable fully qualified column names in Query Builder in Toad for Oracle?

I've found several hits on google on how to do this in Toad for SQL, but I need the same for Toad for Oracle. (Toad v11). I'm building a large query where I combine several aliases of the same table (...
0 votes
0 answers
36 views

Why is the database tab not functional in Crystal Reports 9?

I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
0 votes
0 answers
23 views

Is there a way to Store a Query in View/Procedures?

I wrote an Oracle query and I run it manually from SQL Plus or SQL Developer. It has 2 parameters; start and end date/time. Is there a way to store this query in a view or procedures and run it ...
3 votes
1 answer
4k views

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY '...
1 vote
1 answer
3k views

how do I alter the structure of a table in SugarCRM CE?

How do I add fields to the opportunities table so that they propagate? From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...
0 votes
1 answer
330 views

Automatic update of cells on a second tab when they are merely a copy of the previous tab

I have 2 tabs in excel, part of the information on tab one is to be copied into tab 2. It works ok until I insert a new row into the tab 1 spreadsheet. That change to the cells does not reflect in the ...
1 vote
0 answers
62 views

Data security in server at home

I am a beginner linux user, and am planning on provisionally opening a game server on a machine I have at home. In addition to the possible DDoS attacks that may occur on this server (the server will ...
2 votes
1 answer
486 views

Simulating file corruption on Linux programmatically? (for DB durability testing)

Basically, I want to fwrite() n bytes and have < n bytes be written on the actual disk, or whatever other inconsistency artifacts could arise (like sectors being written out-of-order). I know I ...
0 votes
0 answers
267 views

Odoo 10 stock transfer under wrong company

The Scenario I am running Odoo 10 Community on a postgresql 9.4 database. I have multiple companies setup, including a parent company and two child companies. A PO was setup incorrectly in the ...
0 votes
1 answer
14k views

Restricting a user to access only his own tables in Oracle SQL Developer

I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, ...
0 votes
0 answers
74 views

What are the steps involved to share the credentials with multiple applications?

I have 2 scenarios here. app1 and app2 both belong to the same domain app1 and app2 both do not belong to the same domain. For both scenarios, I require the responsibilities of frontend and backend ...
-1 votes
1 answer
1k views

Do oracle database servers use a license key?

I installed oracle Linux and oracle database on a test server using the media on the OTN. I noticed that no key was required. My question is this: On a production environment at some point do I have ...
1 vote
2 answers
3k views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
0 votes
1 answer
1k views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
2 votes
2 answers
476 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
0 votes
1 answer
286 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
2 votes
1 answer
11k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
1 vote
0 answers
53 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
0 votes
1 answer
294 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...