Skip to main content

Questions tagged [ubuntu]

Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.

Filter by
Sorted by
Tagged with
1 vote
0 answers
916 views

Getting error as "ERROR: permission denied for schema public" while executing a sql script in Postgres sql

I am using ubuntu 18.04 and running postgres sql in a docker container running on port 5432 on a VM powered by GCP. First of all I entered sudo -u postgres psql to enter into the database as ...
Talib's user avatar
  • 11
5 votes
3 answers
1k views

Differences in PostgreSQL 14 collation behavior on Linux and Mac

I have PostgreSQL installed on my Mac and Ubuntu Server as shown below: atsweb=# select version(); version ...
Christian Alis's user avatar
1 vote
1 answer
113 views

How can i solve Statement failed problem?

I am trying to connect FDB file on Ubuntu. ubuntu@me:/opt/firebird/bin$ sudo ./isql Use CONNECT or CREATE DATABASE to specify a database No entry for terminal type "xterm-256color"; using ...
sunShine's user avatar
0 votes
1 answer
4k views

PostgreSQL directories explained

I almost 'randomly' dig into some of the classical PostgreSQL installation folders on Ubuntu 22.04.1 and I was naively wondering what exactly are the following different postgres directories intended ...
s.k's user avatar
  • 372
1 vote
1 answer
130 views

Backing-up Postgresql data when only root login is available (Ubuntu)

I have a Ubuntu-based workstation with several boot issues that prevent any user login - only logging in as "root" works. Before formatting the Ubuntu partition to perform a clean ...
Louis15's user avatar
  • 113
0 votes
0 answers
3k views

Sequelize and Mysql throw connect ETIMEDOUT error

Hello everyone this is my first time here but I'm a quite desperate with this situation, I hope you can help me. I have a nodejs server with express and sequelize. When I was in development enviroment ...
Gamaliel Castro's user avatar
0 votes
1 answer
136 views

CRONTAB fail to work

I have cronjob suddenly fail to work. I have pgdump to execute the following command: pg_dump -h 127.0.0.1 -Fc --dbname=postgresql://postgres:[email protected]:5432/db_XP -f /b ...
padjee's user avatar
  • 187
2 votes
1 answer
163 views

MySQL suddenly blocks access from particular IP

I'm using MySQL 5.7.40 on Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0 x86_64) I didn't make any changes since weeks. My websites are on another server. So it's a remote connection. Since some hours ago my ...
David's user avatar
  • 121
0 votes
0 answers
82 views

mariadbd 10.5.18 seems to stop working

I've got a three node galera cluster (mariadb 10.5.18, ubuntu 20.04.5 LTS) with a haproxy as loadbalancer in front of it. Normally, there are up to 80 tcp based connection from a java application, ...
Mrk's user avatar
  • 1
2 votes
1 answer
5k views

Which command to use to restart postgresql 12 service

I am about to restart postgresql 12 service running on Ubuntu 18. First, I check it's status : sudo service postgresql status. Its says : postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/...
padjee's user avatar
  • 187
0 votes
1 answer
452 views

How to install MySQL on Ubuntu 22.04LTS?

I want to install the latest version of MySQL on my Ubuntu 22.04.01 LTS desktop, then try to use it as a local database, but I have been confused because there are a lot of different files here: https:...
best_of_man's user avatar
11 votes
1 answer
18k views

What does PostgreSQL Status active (exited) mean?

I have PostgreSQL with PostGIS intalled on Ubuntu 22.04. I can access the PostGIS-Layers from QGIS and work with them. When i check the status of PostgreSQL with: sudo systemctl status postgresql it ...
fsg's user avatar
  • 213
-1 votes
1 answer
3k views

Postgres server uses all of RAM and SWAP

The Postgres Server Uses all of 120GB RAM and all SWAP! Is there anything wrong? How can I fix this? This is postgres config shared_buffers = 30GB work_mem = 24MB # It's limited for the ...
rostamiani's user avatar
0 votes
0 answers
2k views

MySQL 8: Problems when granting privileges on new user

I'm using a fresh installation of MySQL 8.0.31 on Ubuntu 22.04.1, and I've been following the instructions in an article by Digital Ocean. I created a new user: CREATE USER 'sammy'@'localhost' ...
Wayne Smallman's user avatar
0 votes
0 answers
336 views

Understanding memory situation for tuning a PostgreSQL database on Ubuntu 22.04.1 LTS

I'm trying to better understand my performance / tuning options for a PostgreSQL database. System: Ubuntu 22.04.1 LTS aarch64, 80 cores, 256 GB RAM PostgreSQL 15 Right now, the shared buffer size is ...
Ralf's user avatar
  • 101
3 votes
1 answer
1k views

How to find out why MySQL crashed?

My DB crashed today and this is what I see in /var/log/mysql/error.log: 2022-11-14T16:55:20.879027Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as ...
Mahdi's user avatar
  • 133
1 vote
0 answers
6k views

How to install postgis on Postgres 15?

i do not find a postgis package for postgres 15 on ubuntu. There are tons of blog posts out there showing all the same line: sudo apt install postgis postgresql-x-postgis-3 x stand for the postgresql ...
Richard's user avatar
  • 11
0 votes
0 answers
157 views

Unable to connect to sql server on Ubuntu after MySQLAlchemy connection

Context: I have installed mysql-server on Ubuntu and was able to setup password for root account and also created a few accounts with all privileges. I was able to connect to any user or the root user ...
Rookie_Coder2318's user avatar
0 votes
1 answer
2k views

postgresql received fast shutdown request in ubuntu

I'm working on deploying my flask application on nginx and gunicorn and for a while I've been able to access the site on my mobile device but a couple of days ago it abruptly stopped. The logs showed ...
Dancun Gerald's user avatar
0 votes
1 answer
4k views

MariaDB 10.6 join query 10 times slower than 10.3

I have two VPS servers (LEMP) running Wordpress sites. Specs: Old 4GB RAM Ubuntu 18.04 MariaDB 10.3 New 8GB RAM Ubuntu 22.04 MariaDB 10.6 I migrated a site and found that it was around 10 times ...
mattf10's user avatar
0 votes
1 answer
1k views

pg_dump can not create directory after increase directory space

I recently run pg_dump to backup database using this command using user postgres : time pg_dump -j 4 -Fd -Z 3 db_profile -f /backup-nfs/ Previously, the size of backup-nfs was 100 G. The pg_dump ...
padjee's user avatar
  • 187
1 vote
1 answer
1k views

I cannot find the configuration files on PostgreSQL 14.5 on Ubuntu 22.04 LTS!

I read tutorial https://tecadmin.net/postgresql-allow-remote-connections/ . But in reality, I don't see this file. This is my case: I did not see file pg_hba.conf and postgres.conf . How to allow ...
Vy Do's user avatar
  • 209
0 votes
2 answers
6k views

How to set password for PostgreSQL 14.5 on Ubuntu 22.04.1 LTS?

I follow a tutorial at https://www.digitalocean.com/community/tutorials/how-to-install-postgresql-on-ubuntu-22-04-quickstart . I buy a Virtual Private Server (VPC) what use Ubuntu 22.04 LTS , 4 GB RAM,...
Vy Do's user avatar
  • 209
-1 votes
1 answer
194 views

How to upgrade from psql 9.5 to 12 with short downtime and no corruption

We have two databases in two different servers with PostgreSQL 9.5 One database size is 800GB and the other is 1.8 TB. What would be the most efficient and safe way of upgrading both clusters from ...
blad0506's user avatar
0 votes
0 answers
290 views

Cannot install MySQL 8 in the Ubuntu container

I would like to install Mysql in my Ubuntu container. The reason is my app inside the container needs mysql command to run mysql -u root -p -h "mysql server IP address". But I received this ...
ITnewbie's user avatar
  • 111
0 votes
1 answer
12k views

could not write to file "pg_wal/xlogtemp.2399" no space left on device

I am generating dummy data with this query : INSERT INTO tbltest1 (id, kol1, kol2) SELECT generate_series(1,10000), substr(md5(random()::text), 1, 25), substr(md5(random()::text), 1, 45) FROM ...
padjee's user avatar
  • 187
3 votes
0 answers
1k views

Unable to locate package postgresql-server-dev-15 while installing PostgreSQL 15 using pdpg?

I am trying to upgrade PostgreSQL to version 15 but some packages from 14 seems to be missing. There was postgresql-server-dev-14 in PostgreSQL 14. Trying to upgrade, I tried: sudo apt install ...
tinlyx's user avatar
  • 3,610
0 votes
0 answers
675 views

MYSQL 8 | Ubuntu 20 | Failed to start error

Here is the error I get. Can't start MySQL server 8 on ubuntu 20. I haven't backed up my db so can't purge all data as well. I tried reinstalling MySQL, and didn't work. >/var/log/mysql/error.log ...
Rezasys's user avatar
2 votes
1 answer
14k views

ERROR 1045 (28000) & access denied for user 'root'@'localhost'

UBUNTU 22.04.1, mysql ver 8.0.30 (1) I get sudo apt install mysql-server then sudo mysql_secure_installation Get in loop this error for each complicated passwords I tried: (contained: '<>&(*...
mgae2m's user avatar
  • 161
0 votes
0 answers
242 views

Are there any unintended side effects of limiting a mongodb docker container's CPU or RAM?

It's easy to limit RAM and CPU usage for a docker container with the docker update -m command. We have limited RAM and CPU using docker update on multiple docker mongodb containers, particularly on an ...
J.E.C.'s user avatar
  • 101
0 votes
2 answers
3k views

How to upgrade Postgres minor version from 14.x to 14.4 in Ubuntu 20.04 LTS

In 2022-06-16 Postgres released an out-of-cycle version 14.4, which fixes possible corruption on indexes created with the concurrently option in versions 14.0 to 14.3. Needless to say, this is a very ...
sandre89's user avatar
  • 123
1 vote
0 answers
275 views

Which MariaDB-Galera Node Should I Start After Cluster Crushing or Failing?

Sometimes my 3-Node GaleraCluster fails and doesn't serve. When I check I see all of them are activated but two of them are not working, so I check log files I see one of them could not operate an ...
prenses_mahmut's user avatar
0 votes
1 answer
29 views

I accidentally obfuscated all my files when using oracle sql developer. Now I can't login into my system [ubuntu]

I clicked on the obfuscate button in my root directoty in oracle sql without knowing what it does. Then my system crashed and now no matter how many times I restart, i'm stuck at a login page. It ...
user1591566's user avatar
1 vote
1 answer
822 views

How to re-sync the Mysql replication if Master down

I have a very simple webapp infra: FE => BE => MySQL. I have set up MySQL master-slave replication successfully. If my MySQL master node is down, I can manually point the MySQL IP to the Slave ...
ITnewbie's user avatar
  • 111
5 votes
2 answers
7k views

How to free up hard drive space after deleting millions upon millions of records in mariadb

We have an application where we are receiving information seconds apart, we record this information in a table that we call events, which currently weighs 240 GB, this is the largest we have so far. ...
Blanca Rodriguez's user avatar
2 votes
0 answers
268 views

SELECT INTO OUTFILE giving OS errno 13

We recently migrated from MySQL5.6.51 to MySQL8.0.28 (Ubuntu 20.04.3 LTS) and we have started noticing some differences. One of the problems has been recreated using a sample database, with a table ...
Sandeep's user avatar
  • 265
4 votes
1 answer
13k views

ERROR: could not open extension control file "/usr/share/postgresql/13/extension/postgis.control": No such file or directory

Ubuntu 21.10 , PostgreSQL 13. I catch error ERROR: could not open extension control file "/usr/share/postgresql/13/extension/postgis.control": No such file or directory how to fix it?
Vy Do's user avatar
  • 209
2 votes
1 answer
5k views

MySQL 8 Replication

I've got this error message: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin....
user avatar
1 vote
2 answers
1k views

Problem importing a Dump on MariaDB (Ubuntu 20.04.4 LTS)

I am writing this post because I cannot import a dump on MariaDB (Version 15.1) using Ubuntu 20.04.4 LTS. I did this dump a few weeks ago and now trying to import it using the command mysql -u root -p ...
TurboProgram's user avatar
0 votes
2 answers
148 views

What can malicious postgres db user do to a linux server?

Suppose I created a db user with create role myuser login password 'xyz'; and allowed typical read and write db permissions. If a malicious user finds these login credentials (and has access to db), ...
sitems's user avatar
  • 103
1 vote
1 answer
448 views

Open SQL Server data in QGIS on Ubuntu

I am trying to connect to a SQL Server (MSSQL) database from QGIS on Ubuntu. As per the following link, I have created an odbc.ini file and the driver as per - https://learn.microsoft.com/en-us/sql/...
GeorgeC's user avatar
  • 115
1 vote
1 answer
769 views

Proper *smart* shutdown of PostgreSQL server for PGDG apt packages under Ubuntu/Debian?

I've installed PostgreSQL under Ubuntu 20.4 using the PGDG apt repository. Each time I stop the DB server, e.g., with sudo service postgresql stop, the log says 'received fast shutdown request', but I'...
cstork's user avatar
  • 125
0 votes
1 answer
788 views

Why does MySQL server queries freeze on high load of connections?

Hey there I have MySQL server with the next specs: x2 Intel Xeon XP Gold (64 cores total) 256GB of Ram 1Tb of SSD Nvme on Ubuntu 20.04 The mysql is configured with the next settings: [mysqld] port=...
user23634623's user avatar
3 votes
2 answers
812 views

Is there a way to install PostgreSQL using apt-get without it running initdb automatically?

I am trying to set up replication for PostgreSQL on Ubuntu 20.04 and for the stand-by node I just need to install the PostgreSQL-server and not run initdb. Cluster creation on the stand-by will be ...
UdIt Solanki's user avatar
1 vote
0 answers
1k views

Is it possible to update Mac mysqldump version to same version as what's available for Ubuntu?

I run the following command on Mac Big Sur mysqldump --column-statistics=0 -v -h my host -u myuser -P 3306 -pmypass mydb my_table > /tmp/dump.sql Which uses the following version of mysqldump … $ ...
Dave's user avatar
  • 713
0 votes
0 answers
179 views

Mysql resetted after upgrading from 80025 to 80027

I was with 8.0.25-0ubuntu0.20.04.1 (as the log say), and I made apt update && apt upgrade (specially to fix some issue with other packages). But, when upgrading, it said "Failed to ...
Elikill58's user avatar
  • 221
0 votes
1 answer
4k views

Problems with pg_upgradecluster

Friday I did an upgrade from PostgreSQL 13 to 14 with pg_upgradecluster (on Debian Buster). This worked so today I wanted to upgrade another server (Linux Mint 20.3 Cinnamon). This time it does not ...
Marco's user avatar
  • 3,710
-1 votes
1 answer
655 views

How to backup from MySQL Ubuntu to Synology NAS MariaDB

I am facing difficulties when setting up MariaDB on Synology NAS as slave to replicate my server on Ubuntu. But there are missing commands and files (my.cnf) in the installation. Need help on any ...
hweiu321's user avatar
0 votes
2 answers
158 views

Is there any faster methods to restore db other than mysql dump or export data

I have a db of 1.3 TB hosted in a ubuntu server. I want take backup of the db every week. I have searched in google and many articles which suggested mysql dump or db export. I wonder that is there ...
Ravi Teja RVN's user avatar
2 votes
1 answer
310 views

MySQL Dump on Ubuntu 20.04 returns 0 byte file and runs indefinitely. Works on Ubuntu 18.04

I am using identical configs on Ubuntu 20.04 as I was previously on 18.04; however, on 20.04 the CPU shoots up to 50% usage and the process runs indefinitely, and by indefinitely I mean it was running ...
JimmyBanks's user avatar

1
2
3 4 5
13