Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
0
votes
0 answers

Why can some users connect to a DB and others can't?

I have a geospatial database that one of my users needs to connect to. Whenever he tries to connect from his workstation he gets an invalid connection/connection refused error. He is not able to connect to it from any other workstation. There are…
Kyle
  • 1
  • 1
0
votes
1 answer

SQL SSMS on development - clear ldf files

Working on building a big SQL Server database, I noticed my C drive is running out of space when running heavy SQL queries. The following folder size is over 150GB, log.ldf files reach over 50GB. C:\Program Files\Microsoft SQL…
r.tom
  • 1
  • 1
0
votes
2 answers

DB2 users and groups

Just want to know everyone's experience and take on managing users/authentication on a multi-node db2 cluster with users groups. I have 17 apps in production (project based company, only 2 online apps), and some 30 users with 7 groups. prodsel -…
Arun Srini
  • 43
  • 6
0
votes
1 answer

Database server setup guide

Is there a good guide to setting up database servers, specifically MSSQL 2008 on Windows Server 2008, in a large organisation? I'm sure I'm able to collect all the information I need myself, but if there's a well known guide, it would be nice to…
christianlinnell
  • 275
  • 1
  • 6
  • 18
0
votes
1 answer

selinux context for multiple databases

I have a directory /media/databases under which I want to hold 3 different databases : mariadb, postgresql and neo4j. My issue is that I already have configured postgresql selinux context and the server won't start unless the /media/databases…
John Doe
  • 125
  • 1
  • 7
0
votes
0 answers

Is PostgreSQL Continuous Archiving and PITR what we need?

We have a billing database that uses a PostgreSQL backend, and our billing manager has insisted that we do backups hourly, because of how much work we'd lose from daily backups. My inexperience at managing databases larger than a bunch of Wordpress…
Ernie
  • 5,352
  • 6
  • 31
  • 37
0
votes
1 answer

Oracle 12c schema restore using impdp from a different server

I have created 2 EC2 instances in AWS. One acts as DB Server and one acts as client. Oracle 12c DB instance is installed on DB server and Oracle 12c instant client on client server. I have created a schema, added some tables and data in it and…
nirmalraj17
  • 203
  • 4
  • 13
0
votes
3 answers

Giving permission 777 to folders/files Cons?

I am trying to understand how giving 777 permission to folders or files works. I did some research and understand that 777 permission is not the best when it comes for security. Referring to Web application directories/files. I do understand first…
CodeDoctor
  • 9
  • 4
0
votes
1 answer

Transfer PostgreSQL database to Google Cloud Platform (GCP) when directory structure is different

I have an on-prem SUSE 12 sp3 VM with PostgreSQL 10 database that is about 45GB. I also have a Google Cloud Platform (GCP) image/instance of a SUSE 12 sp3 server with PostgreSQL 10 database, with no db data in it yet. The GCP directory structure and…
mountainclimber11
  • 131
  • 1
  • 9
0
votes
1 answer

How to debug a SQL script containing INSERT statements with failing subqueries?

I have three tables in my database: tbl_object, tbl_tag adn tbl_object_tag_xref. tbl_object and tbl_tag only have the two columns id and name. tbl_object_tag_xref matches objects to tags and vice versa, having the columns id, tbl_object_id and…
Michael Palm
  • 3
  • 1
0
votes
0 answers

Migrating MariaDB cannot find files anymore

I had to reset my dedicated server, so i backuped the whole /var/lib/mysql directory (stored in OVH Backup Storage). Today on my clean dedicated, i reinstalled mariadb and so putted the whole /var/lib/mysql directory of the backup into…
user406214
0
votes
1 answer

connections to postgresql at particular time frame

How can i find the connections made/utilized to my PostgreSQL at a particular given time frame ? In the PostgreSQL logs i am getting JSTERROR: canceling statement due to user request Sar logs : MEM AM kbmemfree kbmemused %memused kbbuffers …
Alex
  • 1
0
votes
1 answer

Staging & Production Sharing the Same Database server?

I am currently trying to setup a staging environment for our live website. (Magento e-com site Here is our current setup: One droplet for Prod Web Server (Apache, PHP, etc.) One droplet for Prod Database Server (MySQL) One droplet for staging web…
SynthCat
  • 3
  • 2
0
votes
1 answer

corosync + pacemaker + percona agent in production

We are planning on implementing HA using pacemaker Corosync and Percona agent on mysql 5.7.1 with GTID. I googled for quiet a while and realized there isn't enough information. I was wondering if any one uses a similar stack for HA or if anyone…
nwarriorch
  • 13
  • 3
0
votes
1 answer

Database server vs NAS for data files

Regarding costs and maintenance speed/simplicity in case of hardwar failures, does it make any sense to keep SQL data files on a NAS server, separate from the SQL Server instance? Our app stores large amounts of measurements (time-series) from many…
vgru
  • 1,287
  • 2
  • 17
  • 25
1 2 3
…
19 20