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.
0
votes
0answers
5 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
18 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
25 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
24 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
23 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
132 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
36 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
22 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
131 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
48 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
44 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
62 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
173 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
43 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
26 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
88 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
80 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
112 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
64 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
173 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
58 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
449 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
125 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
228 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
165 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
38 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
105 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
90 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
98 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
149 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
386 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
30 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
34 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....
0
votes
2answers
561 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
186 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
18 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
0answers
57 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
47 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
599 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 ...
1
vote
0answers
42 views
Installing Ubuntu and PostgreSQL database on different drives
I just received a new root server (this one) with the following drives:
Disk /dev/sda: 480 Gb
Disk /dev/sdb: 480 Gb
Disk /dev/sdc: 240 Gb
Plus the 240Gb SSD.
Both sda and sdb are set up on RAID-1 ...
2
votes
2answers
164 views
how to split long psql command in bash script over several lines
I have a long psql command to execute within a bash shell script, and I am wondering what the correct way is to split it across several lines? The standard Unix script 'split line' backslash ...
0
votes
1answer
196 views
AWS linux - How could I install postgreSQL on amazon linux?
I'm really beginner.
I want to install postgreSQL on Amazon linux.
Please let me know what I should type in regular sequence.
I saw some of questions about installing postgreSQL on linux, but there ...
0
votes
1answer
48 views
How to run command after entering postgres
I am trying to execute ls after opening a new Guake tab and logging into postgres.
guake -n guake -e 'sudo -i -u postgres && ls'
The command successful opens a new tab then prompts me for my ...
0
votes
0answers
47 views
pgbouncer: connections not reused in session pooling
My pgbouncer.ini
pool_mode = session server_reset_query = DISCARD ALL max_client_conn =
100 default_pool_size = 20 min_pool_size=10 server_round_robin = 1
server_lifetime = 300
When i ...
0
votes
1answer
83 views
SUSE Linux Enterprise Server 11 (x86_64) install postgresql93 uninstallable providers
I'm trying to install postresql93 but I have a problem with package dependencies
Problem: postgresql93-9.3.5-2.1.14.x86_64 requires systemd, but this requirement cannot be provided uninstallable ...
7
votes
1answer
8k views
Install PostgreSQL client (psql) only on CentOS
Simple question, but no resources found about this. Is there any way to install only a PostgreSQL client, the terminal-based one, psql, on a CentOS7 system, without installing the complete PostgreSQL ...
