PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.
2
votes
0answers
54 views
Postgres Vulnerability through public schema?
On Debian 8.5, I'm finding weird processes and files in /tmp:
file "cool" is owned by root, group=postgres<br>
file "Injection.sh", "zeroteam.so", "zteam"
Why do those file exist? How can I ...
1
vote
0answers
42 views
Trouble using postgres sql in ubuntu 16.04
I am running Ubuntu 16.04 operating system and have recently installed postgres using the instructions given in https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-...
1
vote
1answer
108 views
Failed to start PostgreSQL database server. — all of the sudden [closed]
All of the sudden postgresql has broken down:
$ sudo systemctl status postgresql
● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; ...
1
vote
1answer
22 views
What does the parenthesized number in the “command” column mean for postgres processes?
When I execute
ps aux | grep postgres
or top | grep postgres
I get all my postgres processes with some information, the last column (command) has the following structure:
postgres: username db ...
1
vote
2answers
26 views
Installing Postgres App on Linux Mint
I've been put on a web app project that is built using Ruby on Rails and uses PostgreSQL for the database. All the other developers on the team have Macs so they just installed Postgres app to set up ...
0
votes
1answer
63 views
Installation of postgresql on linux mint 17.1 (problem with apt-get update)
I have a linux mint system 17.1 and I want to install postgresql.
Now in trying to update the packages, I type: sudo apt-get update and here are the error messages I get:
W: Unable to recover ...
2
votes
1answer
35 views
Why zsh behaves as less when querying a (postgresql) database?
Context
zsh shell,
oh-my-zsh framework,
no special zsh's configuration about postgresql.
Trouble
I noticed an annoying behavior: when querying the database, e.g.:
SELECT * FROM mytable ;
it ...
0
votes
0answers
12 views
How to get PostgreSQL 9.4 dbconn from MATLAB in Debian 8.5?
I can assess psql, create tables and insert into tables, but I cannot get my client applications use the database.
Test code in Matlab
close all; clear all; clc;
input = '123';
%/etc/postgresql/...
0
votes
1answer
24 views
How to run PostgreSQL as daemontools service?
svscanboot was ran and added to autostart
added script from article http://thedjbway.b0llix.net/services/postgresql.html to /service/postgres/run and change mode a+x,root owner
Add service: svc -u /...
1
vote
0answers
76 views
Use Letsencrypt certificates for Postgresql
I have successfully configured Letsencrypt for my NGINX webserver on Debian 8 Jessie.
Now I have installed Postgresql 9.4 and want to use the LE certificates (in /etc/letsencrypt/live/mydomain/com/......
0
votes
0answers
48 views
PostgreSQL/PostGIS installation failed in CentOS 7
I have been struggling to install PostgreSQL and PostGIS on my Redhat Linux based CentOS 7 (x64) machine and so far I am still running into problems. I used this step by step tutorial to install ...
1
vote
0answers
51 views
How to Enable pg_stat_statements module in postgresql(9.4)
I have installed postgres database of version 9.4.1 through source code method ( not by rpm installation) so left out the option of installing postgresql-contrib,
Now i need to enable the module ...
1
vote
0answers
13 views
How can I import cvs file into a PostgreSQL based on condition
I have cvs file that contains records for all the provinces (chm, mk ...).
file.cvs:
time,language,province,longitude,latitude
number en chm number number
number en mk number number
...
1
vote
2answers
294 views
sudo yum install postgresql doesn't work on CentOS 7?
I'm trying to install PostgreSQL on CentOS 7 (by following this guide to install Discourse) but when I give this command:
sudo yum install postgresql91-server.x86_64 postgresql91-contrib.x86_64 ...
3
votes
1answer
49 views
Encrypt postgresql database
I am reading the postgresql database documentation, but I can't found nothing about encrypting the database files to prevent someone to see the data without the database password. There is some way to ...
0
votes
1answer
30 views
migrate running on Virtual Box PostgreSql instance to another machine
I have a PostgreSql instance that Run on Virtual Box at the Physical Machine A
This instance is collecting real-time data, so any downtime is undesirable.
I want to move this instance to the ...
0
votes
1answer
289 views
How to change the path of shared libraries shown by ldd?
I am trying to make the postgis extension work on my system and it always spits out "$libdir/postgis2.2" no such file or directory error. For my curiosity I executed "ldd postgis-2.2.so" and it spits ...
0
votes
1answer
75 views
How to use sqlformat tool with pgAdmin
I am trying to add external SQL formatting utility to pgAdmin.
There is an option available in pgAdmin3 in Preferences -> Query tool -> Query editor called external formatting utility
I set up ...
1
vote
2answers
58 views
How to log PostgreSQL table data changes into syslog?
I have a program which uses these tables, and I want to add some additional functionality to its logging without modifying the program.
groups
------
id bigint not null
name character varying(100) ...
0
votes
1answer
81 views
Clean up conflicting postgresql installations
I have a little development box which I upgraded to Debian 8.5 (to have a current apache and postgres which better match the productive servers). Now I have both Postgres 9.1 (old) and 9.4 (which I'd ...
0
votes
1answer
422 views
Unable to start posgtresql, the reason isn't clear
I've installed postgresql by pacman. Now I'm trying to run it:
$ sudo systemctl start postgresql
Job for postgresql.service failed because the control process exited with error code.
See "...
0
votes
1answer
56 views
Is there any way to Install postgres from Binary in linux machine irrespective of Linux build(Debian/CentOS/others)
I am trying to install postgres on different machine using ansible. Currently I am using postgres source to install on a partical location.
Its taking too much time. Is their a way to run postgres by ...
1
vote
0answers
27 views
Not able to install postgresql in Ubuntu 14.04
I tried many times installing postgresql in Ubuntu 14.04 without success.
I keep getting the following error:
Can't exec "/tmp/postgresql-common.config.WJ3dGb": Permission denied at /usr/share/...
1
vote
0answers
126 views
postgresql auth against samba active directory
I've recently set up a new Samba4 Active Directory to handle centralized authentication for my small office network. On this server is also a postgresql-9.5 instance, and I'm trying to have it ...
0
votes
1answer
103 views
What's the fastest way to install Postgresql on Wind River 7.0?
I'm new to bare-bones Linux systems and need to install postgres on a wind river Linux distribution. My plan was to install yum and then use yum to install the postgres rpm.
I've tried to install ...
0
votes
1answer
14 views
1 VM host 2 PostgreSQL Databases
I'm very new to postsql. Here is my situation.
There is an existing postsql running on my VM on port 1234 pointing to a database name : db1.
Now, I want to add db2, will I need re-configure another ...
0
votes
1answer
124 views
Failed to start PostgreSQL 9.5 with systemctl - SELinux
I've installed PG 9.5 (/usr/pgsql-9.5/) and when I start it manually with postgres -D it has no problems, but if I try to use systemctl I get an error. By looking to journalctl -xen output, I see:
/...
0
votes
0answers
76 views
Debian 8 crashes once every few days
I'm running Debian 8 on Linode 32 GB and once every few days the system crashes. This server is being used in productions and I need to find a solution ASAP
The only server running on Debian is ...
2
votes
1answer
270 views
backup file locally in shell script
This is my crontab:
crontab -e
30 5 * * * sh /home/donato/Documents/pg_bak.sh
Every day at 5:30am I want to execute a shell script I created called pg_bak.sh.
This is the contents of the shell ...
0
votes
2answers
80 views
Delete rows from postgres database contain string/sentence [closed]
I would like to know how to delete entire rows in a postgres table that contain a particular string in the title column. So if the string is:
it is a sunny day
How can I issue a command in postgres ...
2
votes
1answer
2k views
“psql: could not connect to server: No such file or directory”
Actually, I installed PostgreSQL 9.4 (with postGIS extension), and when installed, everything used to work fine.
As said on many tuts, I've set the /data folder, checked configuration files, and so ...
0
votes
1answer
158 views
Using regexp_replace to replace single quotes around string but not within words e.g. can't
I'm using the below code from a bash script to replace single quotes from my title column in a postgres database with spaces.
psql -U postgres -d my_database -c "UPDATE my_table SET title = ...
0
votes
1answer
271 views
Install PostgreSQL 9.5 CentOS 7
I'm trying to install PostgreSQL 9.5 on CentOS 7.
I've searched online and to get access to the 9.5 RPMs it requires installation of pgdg95 via the following command:
sudo rpm -ivh http://yum....
0
votes
1answer
316 views
syntax error: unterminated quoted string when using regexp_replace in bash script
I've added some code to the end of a bash script I am using. The code shown here is intended to copy a csv into my postgres table, and then remove brackets, quotes and double quotes from the title ...
0
votes
0answers
45 views
Upgrading postgresql to 9.3 on a CentOS 7 machine
I've recently rented a machine, with CentOS 7, to use for a Nominatim server. I've managed to correctly install Nominatim on the machine, with the instructions from the site, it works correctly, but ...
1
vote
1answer
149 views
How can I install PostgreSQL and PostGIS on Ubuntu 14.04 and enable remote access over the internet?
I would like to install PostgreSQL and PostGIS on my Ubuntu 14.04 virtual private server that is hosted in a remote datacenter.
How can I enable remote access on them?
2
votes
1answer
113 views
Ways to restrict remote user to only access a remote database
I want to be able to setup a remote user that can update a PostgreSQL database on a production server.
I have two machines, one is a local server that I use as a command and control system, named ...
3
votes
1answer
139 views
Copy csv data while simultaneously filling serial column
I've created my first postgres table and i'm trying to work out how to copy a .csv file into the table, whilst simultaneously generating a serial number number in column 1 (ID) which starts at number ...
1
vote
1answer
185 views
Chroot Postgresql Error
Currently I'm trying to create the first PostgreSQL 9.5 cluster on Linux deploy android 5.0.2, and it seems to be a shared memory error.
FATAL: could not create shared memory segment: Function not ...
1
vote
1answer
538 views
SSH access asking for password in local network but public
I have a problem when ssh to another server.
I created ssh-key and copied it to other server.
-bash-4.2$ whoami
postgres
-bash-4.2$ ssh-keygen
Generating public/private rsa key pair.
Enter file in ...
0
votes
0answers
33 views
How to move a postgresql backup dump to an other server with a script?
I have on a ubuntu 14.04 Server some Backup Files from a PostgreSQL Database. How Can I move this with a daily backup script to an other server?
I need a script that moves my files in path /example/...
1
vote
1answer
40 views
Postgresql error after upgrading database
We recently upgraded POSTGRESQL to 9.4.4 and now when my application tries to run a query I am getting this error.
LOGS:
2016-03-15 16:34:51 ERROR http-nio-8282-exec-2:FeedRestController:224 - org....
1
vote
2answers
1k views
How do you stop posgresql on centos 7?
How does one stop a Postgresql instance, 9.2, on CentOS 7.
I found nothing under /etc/init.d/ nor a ctl program.
1
vote
1answer
263 views
How to debug an Out of memory crash
Recently one of my CentOS6 server crashed because of an Out of memory Error:
It seems to be related to the postgres database used by java web-applications (deployed on tomcat). But I cannot find ...
0
votes
1answer
59 views
Issue with dropping table which contains special char in tablename. (Linux&Postgres)
I am facing issue with DROP table command in Linux (backend : Postgres). I have a table named "prabhu2016-02-08--2016-02-15". when I drop this table using below commend i am receiving error....
ERROR:...
0
votes
0answers
19 views
How to configure sympa with plesk root access using mysql usename admin@localhost?
I'm trying to use MySql, but username is admin@localhost. It was root but plesk changes it to admin. I also tried PostgreSQL but after it asks for the root password there is another request to access ...
0
votes
1answer
68 views
failure at starting on postgresql
I installed a postgresql database on Redhat 7.1 and I decided to move the database on a ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting ...
2
votes
1answer
56 views
Mount a large squashfs in a way that allows random writes (to a separate filesystem)?
I just received a few-dozen-gigabyte squashfs that contains a PostgreSQL database. In order to be able to conveniently query it, I need to have a write access, which makes it complicated. Is there a ...
1
vote
0answers
34 views
What is the equivalent to this apt-get when installing PostgreSQL extension for acoustid?
On bitbucket, it says to install the extension using sudo apt-get install postgresql-9.X-acoustid.
but I'm running on CentOS... when I replace apt-get with yum:
$ sudo apt-get install postgresql-9.X-...
0
votes
0answers
674 views
Pg_dump does not work in Cron
I have the command below and run it succesfully:
/usr/lib/postgresql/9.1/bin/pg_dump -U dspace --format=c --file=/dspacebkp/dspace_db_$(/bin/date +\%m\%d\%Y)_uncompressed dspace
I can see my new ...
