Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [unix]

43 questions
22
votes
1 answer

What limits the number of connections?

As per https://devcenter.heroku.com/articles/heroku-postgres-legacy-plans the connection limit is 500 As per https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server "Generally, PostgreSQL on good hardware can support a few hundred…
Neil McGuigan
  • 7,653
  • 3
  • 36
  • 52
11
votes
3 answers

Execute system commands in postgresql

My requirement is to execute a system command like (ls) or C program when a trigger executes. Is there any way to create a trigger function to solve this problem.
mohangraj
  • 273
  • 1
  • 2
  • 7
5
votes
1 answer

Does the mysql parameter "max_connections" apply for unix socket connections?

The documentation does not specify if max_connections apply only to TCP connections. The way it is said, it looks like it does apply for any kind of connection, but I'd like to be sure because otherwise, I could use it when the "Too many…
Totor
  • 183
  • 1
  • 7
5
votes
2 answers

How do you find home information for Oracle RAC on Unix?

Need help finding Oracle home path corresponding to a database instance in RAC environment. I am aware of few of the ways to achieve the same. Listing them below to avoid the same answers. /etc/oratab This file is not mandatory and hence may not…
user1787572
5
votes
2 answers

Perl vs Ksh for Unix Database Administration

I realize this is a somewhat more subjective question, but I am looking to the community for guidance. Our company is fairly new to having DBAs. We used to use DB2 for i on the IBM's iSeries servers, so there really wasn't a need for a DBA (at least…
Chris Aldrich
  • 4,846
  • 5
  • 29
  • 54
4
votes
1 answer

Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

It's months that I'm trying to solve a performance issue with PostgreSQL. SYSTEM CONFIGURATION Our deployment machine is a Dell PowerEdge T420 with a Perc H710 RAID controller configured in this way: VD0: two 15k SAS disks (ext4, OS partition, WAL…
pietrop
  • 656
  • 1
  • 5
  • 12
4
votes
2 answers

How to check if Oracle DB process is running in Unix and where Oracle DB is installed

I am new to Unix and trying to find out a command that checks if Oracle DB is installed in my Unix box. I came across commands ps -ef|grep smon and ps -ef|grep pmon in net. But which is the correct command that I can use. Also how to find out the…
chaitanya
2
votes
1 answer

Amazon RDS - Can't connect to MySQL database server?

So I've been working on this issue for a while now, and I'll explain what I'm trying to do. I'm trying to connect to a MySQL database server, hosted by Amazon Web Services in the Amazon RDS service. The database is up and running, and I've created a…
Jake Byman
  • 121
  • 1
  • 4
2
votes
2 answers

Oracle's UTL_FILE when connected locally or through listener has different behaviour

We have a procedure which creates a CSV file with UTL_FILE. (env is Oracle 11.2.0.1 and RHEL 6.4) Until now, we were storing that CSV file into system oracle (the oracle owner) user home (/home/oracle/csv/). It works fine, but now we're required to…
vegatripy
  • 659
  • 1
  • 7
  • 17
2
votes
4 answers

Shell: How to time a script running in SQLPlus and kill it after x amount of minutes?

I have a little tool which automatically runs a series of SQL scripts when and outputs to .XLS when an appropriate request is made. However, some SQL scripts need to be ran on a live database, and I don't want them to run for over 5 minutes. Is…
cardybean
  • 123
  • 4
2
votes
1 answer

Question about Oracle's interpretation of "host cpu utilization" in v$sysmetric view

I am studying the v$sysmetric view from Oracle and trying to understand what is Oracle's interpretation of "Host CPU Utilization" It says in the metric_unit as % busy/(idle + busy), but what is busy? Is that the sum of usr + sys time? I tried…
tytchong
  • 33
  • 5
2
votes
1 answer

How to insert multiple IP addresses in a pg_hba.conf file via unix shell script?

I need to write some IP addresses to the pg_hba.conf file of my Postgresql, in order to allow remote access from those IP to my machine. I have the following code in shell script to do that for a single IP address #!/bin/bash ######## PostgreSQL…
suvrat
  • 47
  • 6
2
votes
1 answer

Compute Leap Seconds

I use PostgreSQL 11 and have two columns. One is unix timestamp which is not aware of leap seconds and an utc timestamp which is aware of leap seconds. Is there a way either to find the number of leap seconds between an unix timestamp (without leap…
nali
  • 196
  • 9
2
votes
2 answers

I want to change oracle "homedir" how to do?

A good link as answer is ok. I want to change "homedir" or "basedir" of oracle db from /oracle to /var/oracle. How to do? I have set the oracle unix variables($ORACLE_HOME,$ORACLE_BASE) with the new path,but db doesn't start. So i reset them to old…
elbarna
  • 177
  • 4
  • 13
2
votes
1 answer

How to use a variable date when running a db2 command in a shell script?

I need to use a date variable in a select, like bellow, but I'm getting this error: Expected tokens may include: "". SQLSTATE=42601 How can use these variables in a shell script? day0_T1=`TZ=CST+12 date +"%Y-%m-%d %T"` day0_T0=`TZ=CST+24 date…
tiago
  • 21
  • 1
1
2 3