A widely-used open-source operating system that is particularly popular on servers.
0
votes
0answers
5 views
postgres service suddenly not working after the computer crashed while working
I've been working with postgres on a linux server for the last couple of months. Last week, half of our servers crashed and my one with them. I was in the middle of uploading data to the postgres ...
0
votes
0answers
31 views
Server doesn't listen
I try in Win7 by means of PGAdmin 3 to be connected to a host 192.168.1.8 with the virtual machine with linux. Already which time I receive the message
Server doesn't listen
The server doesn't accept ...
0
votes
0answers
44 views
Oracle 11gR2 DBCA installation failing with TNS Lost contact
I am getting below errors while running DBCA with silent install using response file
ORA-12547: TNS:lost contact
PRCR-1079 : Failed to start resource ora.ocl.db
It's a fresh installation and not ...
1
vote
1answer
28 views
Moving postgresql data directory
I moved postgresql's data directory by following the following steps:
Stop postgres
cp -a source_data_directory destination_data_directory
export PGDATA=destination_data_directory
Changing data ...
0
votes
0answers
24 views
change data directory postgres with database cluster [duplicate]
I have my present database cluster of postgres at /mnt/my_hard_drive which I want to change to /home/myfolder. I also want to move all my databases present in the present cluster to /home/myfolder. Is ...
1
vote
0answers
34 views
How to Change location of postgres cluster and database within the same machine? [duplicate]
I have my present database cluster of postgres at /mnt/my_hard_drive which I want to change to /home/myfolder. I also want to move all my databases present in the present cluster to /home/myfolder. Is ...
0
votes
0answers
46 views
How much RAM for a large database on a dedicated MySQL InnoDB server?
Hereunder my hardware config:
CPU: 1x Intel Xeon X3470 Quad core @ 2.93GHz
RAM: 4x 8GB DDR3
Disks: 2 x SATA 320GB for the system & 4 x SAS 300GB for the DB
I've upgraded from 12Gb to 32Gb and ...
3
votes
0answers
42 views
What happen when Postgresql tablespace is null?
I'm facing a DWH on postgresql with no DBA (I'm not one) so I turn to you with hope to figure this issue/s.
Long story short, when I check the disk usage per tablespace, I get different distribution ...
0
votes
1answer
88 views
createdb: could not connect to database postgres: FATAL: could not write init file
RedHat Enterprise Server 3.0 32 Bits
psql (PostgreSQL) 8.2.3
user: postgres
server is running:
/soft/postgres/8.2.3/bin/pg_ctl start
pg_ctl: another server may be running; trying to start server ...
0
votes
2answers
56 views
Can I find out what version of MySQL from the data files?
I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
1
vote
2answers
63 views
How to avoid lagging when enabling log-slave-updates?
Master:
48GB RAM
16-core
my.cnf: https://clbin.com/hlkUo
Slave:
64GB RAM
24-core
my.cnf: https://clbin.com/viLm0
Both are running 5.5.28.
For the incremental backup purpose, I need to enable ...
1
vote
0answers
49 views
mysqld dead but subsys locked
I'm executing the following command in a shell script and I'm executing this on an RHEL-6 server and MySQL version 5.1.47-
mysqld_safe --defaults-extra-file=/custom/path/of/my.cnf
The path of ...
0
votes
1answer
73 views
Database creation on Linux with dbca: “command not found”
I have installed an Oracle on my machine. When I open a session with VNCServer and type dbca, either as root or as oracle, I get these errors:
-bash : -dbca : Command Not found
Xlib: connection to ...
0
votes
1answer
106 views
mysqldump: Got error: 1017: Can't find file: 'drupal_install_test' (errno: 2) when using LOCK TABLES
I'm trying to backup a drupal site database but I'm having some issues. When I ran the following command:
mysqldump -uroot -p drupaSite > drupaSite.sql
I get the following error:
mysqldump: Got ...
2
votes
1answer
43 views
How can I automate copying DB2 table data between remote Servers?
I have two IBM DB2 servers at separate remote locations.
I need to copy data from several tables on one database on the first server to another database in the second server.
Previously I've used ...
0
votes
2answers
46 views
which process has created a load spike on my server last week?
O.S.:Linux
MYSQL server
we got a load spike last week.
how can I find the process that has created the load spike on my server last week.
0
votes
1answer
333 views
MySQL slave stuck in “Reading event from the relay log”?
5.5.28-log MySQL Community Server (GPL) by Remi
binlog-format=MIXED
My problem is similar to this question.
*************************** 2. row ***************************
Id: 973415
User: ...
1
vote
1answer
114 views
MySQL my.cnf won't take any effect
Update 7
As DerekDowney suggested, I tried to use
[mysqld]
init_connect=SET NAMES 'utf8'
But I could not get the desired result. My client side java programme still says both session and global ...
1
vote
1answer
49 views
clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
After a fresh PostgreSQL install (version 9.2) on my Ubuntu server 12.04, clusterdb utility stopped working. I used the same config files as I used with version 9.1.
Below is the actual command:
...
1
vote
1answer
30 views
How to implement security model?
I have installed Oracle 11g on fedora 14. I connected with SQL*Plus as 'SYS' and
created some tables, then created a user named "account" and a role, "payroll"
with the following privileges. I ...
1
vote
5answers
312 views
How to properly kill MySQL?
I have CentOS 64bit with CPanel installed and I use
service mysql stop
However, it keeps doing ..... for minutes and it never stops. It used to be instant. Any idea why it does that and how to fix? ...
0
votes
0answers
54 views
How to properly kill MySQL? [duplicate]
I have CentOS 64bit with CPanel installed and I use
service mysql stop
However, it keeps doing ..... for minutes and it never stops. It used to be instant. Any idea why it does that and how to fix? ...
0
votes
1answer
177 views
How to copy MySQL Database from Linux to Windows?
I would like to copy a MySQL database form Linux to Windows, from a little research I found this url http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html where the author says we ...
1
vote
0answers
37 views
How open oracle DB Linux (After installation)
I have just installed Oracle 11gR2 on my Linux Mint Distro (xfce). All worked fine, and I was able to acces to
https://localhost:1158/em [Erreur 102 (net::ERR_CONNECTION_REFUSED) ]
I rebooted my ...
1
vote
1answer
90 views
Is it okay to have different lower_case_table_names value on master and slave?
I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1.
I haven't started replication on the slave, but everything looks ...
0
votes
0answers
68 views
Migrating database from OSX to Linux
I followed the setup in below link, to setup mysql. Basically, I am have a master on OS X server and want to setup a linux slave.
Create a mysql slave database from master database
After I copied ...
2
votes
1answer
190 views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
0
votes
0answers
65 views
how to install zabbix agent in agent host which we are adding from server to monitor
following this site i have intsalled zabbix server and agent in centos 6.0
zabbix version :1.8.5
http://www.youtube.com/watch?v=sKfYm-3thRM
but i am unable to add agent that is how to add other ...
0
votes
2answers
207 views
Postgresql - Segmentation fault (core dumped)
I'm working on postgresql code (server side).
I installed a version from source code following the official tutorial:
http://www.postgresql.org/docs/8.4/interactive/install-short.html
I did same ...
0
votes
1answer
83 views
Does a standby slow down Oracle imp?
I have Oracle 10gR2 installed on Redhat Linux 5.4 on two servers (primary and physical standby).
When I import data into the primary server while the standby is started it takes too long to complete ...
