Questions tagged [unix]
The unix tag has no summary.
47 questions
0 votes
0 answers
512 views
How to solve cp: cannot stat 00000002.history: No such file or directory/LOG: invalid primary checkpoint record during PITR?
I have tried to recover a database, using the Point-in-Time Recovery method, through the postgresql.conf file, setting the recovery_target_time parameter at a specific time in past, but I cannot start ...
0 votes
0 answers
56 views
Why does removing `skip-grant-tables` cause resource conflict error for mysqld?
After hours of searching, I have managed to narrow a mysqld issue down to a point, which I cannot find reason for. I am attempting to launch multiple instances of mysqld on my Ubuntu server. When ...
- 21
1 vote
1 answer
810 views
Convert column with unix timestamp from UTC to a different time zone
Good afternoon, I have a column within one of my tables that is stamped with a UNIX timestamp. I would like to have the return in my current timezone, PST. I have the following query and the below ...
- 13
1 vote
0 answers
208 views
Critically high website CPU usage very sudden, persistent upon reboots [closed]
Quick summary. Wordpress community website, large userbase. Has caching for guests (WP Super Cache). Always operates around load of 1-2, or 5-6 at peak hours CPU. As of 4pm EST on Feb 15, the CPU load ...
- 111
0 votes
2 answers
300 views
Command line command to read Oracle Database export Success Message In log File
We have several oracle 19c servers with daily exports. I would like to find a way to run a command to read the export log file to find the success message for the day. e.g. I would like to putty into ...
- 1
0 votes
1 answer
1k views
Help required to find correct MongoDB size
Please help me to find correct MongoDB size. db version v3.4.10 I have also executed below command to check if there are any ghost file. The below command output is zero. lsof | grep deleted | grep ...
1 vote
0 answers
614 views
Independently checking if PostgreSQL server and client are installed
How can I independently determine whether the PostgreSQL server and client are installed in the Unix-based system? I believe running psql --version checks only for the PostgreSQL client. Is postgres --...
- 115
1 vote
1 answer
54 views
Mysql 8 which linux / Unix Distro would have better performance (2021 topic) [closed]
I want to setup a mysql 8 with MyRocks engine and BUILD from source with my custom parameters. Is there any recommendation on which linux / unix distro would have better performances ? CentOS stream ...
- 113
1 vote
0 answers
35 views
UNIX timestamp using for storing logs
Would it be feasible to use UNIX timestamp as a primary key to store log records/analytics data of users? Will there be inconsistencies if a RDBMS is used to store log data?
1 vote
3 answers
476 views
count duplicate records and select first 2
I have troubling issue where I want to only select the first 2 chunks of every dbspace created. query used: SELECT a.dbsnum, b.chknum, a.name, b.fname FROM sysdbspaces a, syschunks b where a.dbsnum = ...
0 votes
1 answer
341 views
How can I list all the tablespaces without getting into each instance?
I got around 98 instances in a single AIX server. I need to list all the tablespaces, their path and usage. Is there a way I can do that without getting into each instance, connecting into the ...
- 1
0 votes
0 answers
575 views
Import table data using multiple sql file in psql
Local Machine(l1): Windows 10 psql Remote Machine(R1): linux EDB(postgres) On my local I have 1000+ sql script containing insert statement . psql is also installed locally . I need to run this sql ...
- 35
-2 votes
1 answer
2k views
How to resolve error "SQL0104N" when running "db2 prune logfile prior to" command?
I wrote an script to delete transaction log files in db2. I need to delete all the files prior to the active log file.I wrote this code as .sh file db2 connect to DWHDB db2 get db cfg | grep '/...
2 votes
1 answer
991 views
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 ...
- 67
0 votes
2 answers
88 views
Fetching wrong results on comparing a variable with 0 in unix
I have the following code in unix #!/bin/bash user=$1 username=$user'%' DB_name=$2 userpwd=$4 export PGPASSWORD=$3 psql -h localhost -U postgres -d $DB_name -At -c "SELECT COUNT(*) AS ...
- 67