simplechan In other words, I installed a message board named simplechan, but I can not log in to a site dedicated to the administrator. Because you need a password to get there. I do not know the password. I entered in psql as follows In “simplechan/sql/create_table_query.sql” it was drawn as foll…
Tag: postgresql
bash list postgresql databases over ssh connection
I am doing some work on a remote Postgresql database. When I log into the server this command works on bash: $ psql -c “l” Remote login over ssh is possible using: But why doesn’t it work from this command? This is working, also “psql -l” but I don’t understand why I have t…
PostgreSQL COPY FROM STDIN not working, but FROM PATH works
In PostgreSQL I previously created a table like so: The idea is to import multiple csv files into this table. My approach is to use COPY … FROM STDIN instead of COPY … FROM ‘/path/to/file’, as I want to be able to cat from the shell multiple csv files and pipe them to the sql script. T…
psql – Mac trying to connect postgreSQL in Ubuntu system installed in a virtual machine in remote server
Apologize in front, maybe the situation here is a bit complicated. I searched everywhere online but couldn’t find a perfect solution, plus I have tried almost all the solutions mentioned in other posts. Situation: So I have a postgreSQL database installed in a Ubuntu system. The system is actually a vir…
Including a date/time in a file name dumped from psql
I’m planning on running a .sh script that will run periodically through cron on linux. I’m running postgres 8.4 on centos. My script will have something like this in it: I know there are other ways to dump tables into csv files but this is the only one I could use without admin rights. My problem …
Create PostgreSQL Database on another Server using Django
I have a working local environment using Django 1.11 with a PostgreSQL 10 database running on Linux Mint. I am trying to take a copy of this environment and install it on two Ubuntu 16.04 development servers: one for the web server and the other for the SQL server. The problem is running Django with the Ubunt…
psql: could not connect to server: No such file or directory “Centos7”
Not able to access psql database. Below is the error while accessing database: I also tried to look for postmaster.pid but didn’t find it Answer Your server is down or at least not where your psql command thinks it is. You can search your system for postgres.conf which should tell you what port it’…
how to find documentation for Postgres Linux packages?
There are PostgreSQL binaries in yum package except for server and client. I can assume the purpose of binaries, but I want to check it in documents. How can I find the documents for them? Answer or (old RHEL/CentOS) If you have downloaded the RPMs:
Schedule a function that belongs to an R package
I’m trying to build an R package whose goal is to run a series of analyses by taking input data and writing output data to an external database (PostgreSQL). Specifically, I need a set of operations to be scheduled to run on a daily basis. Therefore, I have written some bash scripts with R code (using t…
Tired of creating /run/postgresql and setting read and execute writes after every reboot
I’m running Arch Linux, I installed PostgreSQL as any other arch package. I’m running postgres with a local database located in my user directory. (postgres -D /home/user/data/) When I do so, I get the error FATAL: could not create lock file “/run/postgresql/.s.PGSQL.5432.lock”: No suc…