Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
0
votes
1 answer

CouchDB administrator password reset

I have an install of couchDB, and somewhere along the line, a malformed request via CURL has my admin accound with a password that I don't know. Short of setting up another Couch server, then replicating to it and vice versa after a reinstall, is…
spuy767
  • 203
  • 3
  • 4
  • 11
0
votes
3 answers

MySQl, Postgresql replication comparison

One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag. How does Postgresql handle replication? Does it (or add-on such as slony-I) allow multi-threaded slaves? In general, what are the pros and…
Continuation
  • 3,080
  • 5
  • 30
  • 38
0
votes
1 answer

Why won't Postgres start after stopping it?

Postgres was running just fine (I have created a database using template0). Then, I used: $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop --mode=smart to stop Postgres and it stopped without a fuss. Then, I used: $…
orokusaki
  • 2,763
  • 4
  • 32
  • 43
0
votes
1 answer

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event monitors? I'm currently using DB2 9.7 but am…
Jason Axelson
  • 334
  • 1
  • 5
  • 17
0
votes
1 answer

Get permissions in fixed or user-defined server roles in SQL Server 2012

I'd like to know how to get a list of permissions that belong to fixed and/or user-defined server roles in SQL Server 2012. In previous versions there was an sproc sp_srvrolepermission but this is deprecated in 2012 and it returns only permissions…
rwwilden
  • 369
  • 1
  • 5
  • 13
0
votes
2 answers

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one (R1) is used by an application which do day-to-day…
Switch
  • 159
  • 10
0
votes
2 answers

MariaDB set maximum database size to 1 GB

I'm using MariaDB on my hosting. I would like to limit database size to 1 GB. How to do this properly in /etc/my.cnf ?
Spacedust
  • 568
  • 5
  • 13
  • 28
0
votes
2 answers

PostgreSQL, automate REINDEX, Windows environment

I have a couple of PostgreSQL tables (9.1) which are inserted to / deleted from often. Over time they suffer from index bloating even though the autovacuum is configured and runs regularly. I'm thinking about automating the REINDEX on these…
Evgeny
  • 213
  • 2
  • 6
0
votes
1 answer

Replicate from slaves to master and viceversa

I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 table3 MySQL DB (slave1) table1 table2 …
ReynierPM
  • 710
  • 5
  • 14
  • 30
0
votes
1 answer

Configuring MySQL logging for an audited environment such as SOX

How do you configure MySQL users and logging to satisfy SOX auditors? For example, if you need to log queries and the source of the query for later review by an internal SOX controls group. Is there an easy way to distinguish queries generated by an…
Kieran Tully
  • 152
  • 1
  • 8
0
votes
1 answer

How do I install a previous version of Postgresql in debian?

I am running debian squeeze. I want to install a previous version of postgresql. The current version in the postgres debian repository for 9.0 is 9.0.12. I specifically need to get 9.0.8. How can I get version 9.0.8 installed on my machine?
slappyjam
  • 75
  • 6
0
votes
1 answer

Native Postgresql 9.2 Streaming Replication

I'm trying to build up native postgresql 9.2 streaming replication in the Amazon cloud. According to documentation, I've set up everything correctly - but at the slave I get these logs: 2013-02-04 13:18:01.315 GMT LOG: streaming replication…
Hoelli
  • 43
  • 2
  • 8
0
votes
1 answer

Backup and bz2 large mysql datefile with innobackupex in the background

I'm using the following command to backup a large running mysql database (~500GB). innobackupex --user=user --password=***** --stream=tar ./db-backup | bzip2 - > backup.tar.bz2 Since the backup process takes more than 24 hours, I want to run the…
Mohsen
  • 103
  • 2
0
votes
1 answer

DB Migration switching from MySQL

I currently have a massive MySQL Data but would like to move over to Cassandra nosql. How hard of a move over would this be? I've not found any examples yet on this being done. It is possible right.
Linda Thomas
  • 21
  • 1
  • 2
0
votes
1 answer

All users can read SSAS all Cubes

I found that all my domainusers can read the cubes in my Microsoft Analasys Services. I have no roles specifying that. Neither the domain admins nor the local admins contain any group that would contain unwanted users. The serveradmin role does not…
kcode
  • 1,825
  • 4
  • 19
  • 21
1 2 3
…
19 20