On many varieties of Linux PostgreSQL runs under a separate user account, so you have to do: to get any work done. That’s all well and good if you just want to type SQL in manually, but what if you have a migration written in a programming language (in my case, Node/Knex)? Is the common practice to some…
Tag: postgresql
LINUX GNU Create New user Postgres DB in Makefile
I’m new with Makefile. I need to automate create user for postgres terminal. I tried this example and it did not work for me: Neither @create user myusername; nor @/q works. When I ran make createuser and exit manually with q from postgres terminal, I receive this error: Answer When debugging makefiles,…
PostgreSQL 9.5 doesn’t start after reboot with systemd
I’m having a problem with PostgreSQL 9.5+173 on Ubuntu 16.04 and I happened to stumble across the following threads in my research that somewhat describes the behavior I’m seeing: https://www.postgresql.org/message-id/CAFyxdeT%2B%3Dx-d0oNbFPoe%2B4xnt0Qdfi%2BzAEn%2BrQmEK0AZbJFRtg%40mail.gmail.com h…
Postgres latency issues during memory compaction in Ubuntu Linux
We’ve recently upgraded our EC2 instance that hosts our Postgres database to an i2.8xlarge with 244GB of memory (this is to utilise the large amounts of ephemeral storage it comes with). Since upgrading, we’ve been having some issues with latency in Postgres that appear to be due to memory compact…
pg_upgrade oldbindir check fails
I’m trying to upgrade postgresql database from 9.1 to 9.4. I ran the 9.4 version of pg_upgrade as follows: I get: The folder exists, I set the permissions to 777, even gave the postgres user ownership of the directory structure, but I’m still getting the same error. Running in verbose mode does no…
Copy file from remote server to local server not working [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack …
Postgresql edit gone wrong on Ubuntu. Error every time I use sudo apt-get install
A few months back I edited the PostgreSQL version 8.2.19 source code in Ubuntu OS to change the algorithm of the buffer manager in it. I don’t remember what I exactly did but I did something wrong (clearly) so now whenever I try to install a new program, I get the following error (even after it installs…
PostgreSQL CSV import from command line
I’ve been using the psql Postgres terminal to import CSV files into tables using the following which works fine except that I have to be logged into the psql terminal to run it. I would like to know if anyone knows of a way to do a command similar to this from the Linux shell command line similar to how
How to check if a service that I don’t know the name of is running on Ubuntu
I do not know the service’s name, but would like to stop the service by checking its status. For example, if I want to check if the PostgreSQL service is running or not, but I don’t know the service’s name, then how could I check its status? I know the command to check the status if the serv…
PostgreSQL psql terminal command
I’m trying to get psql to format nicely and am following the docs here. Right now, whenever I do a query on tables with lots of columns, no matter how big I make my screen each line overflows into the next line and producing a whole screen of unreadable junk. The docs (link is above) say there’s a…