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.

learn more… | top users | synonyms

1
vote
0answers
12 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
27 views
+50

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 ...
1
vote
2answers
1k views

ERROR: Failed to build gem native extension on Arch (postgresql)

I can't install gem pg on Arch due to the error: Gem::Ext::BuildError: ERROR: Failed to build gem native extension. /home/alex/.rvm/rubies/ruby-2.1.1/bin/ruby extconf.rb checking for pg_config.....
0
votes
1answer
25 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 ...
1
vote
2answers
181 views

many missing dependencies , no links (centOS 7 , postgresql 9.3)

I am trying to install postgresql 9.3 on centOS 7 first , I needed to install libxml2 , and then I tried to install libxml2-devel /$ rpm -iUvh http://xmlsoft.org/sources/libxml2-devel-2.9.2-1....
5
votes
2answers
3k views

How to install PostgreSQL 9.3 in FreeBSD jail?

I configured virtual NICS using pf, and a jail for FreeBSD using qjail create pgsql-jail 192.168.0.3. When I tried to install PostgreSQL 9.3 using port collection, it shows strange message at first. ...
0
votes
1answer
57 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
1answer
10 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 ...
2
votes
1answer
50 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 ...
2
votes
1answer
3k views

Kali Linux Postgresql Error

I recently installed kali Linux and keep getting an error code starting metasploit this is the code [...] Starting PostgreSQL 9.1 database server: main [...] Error: could not exec /usr/lib/...
0
votes
0answers
34 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 ...
1
vote
3answers
656 views

Postgres: authenticate as postgres user in non-interactive script

I am writing a non-interactive script that needs to execute postgres commands. The script will only be run by root or a user with sudo permissions, and the postgres commands need to be executed as ...
0
votes
1answer
58 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
2answers
31 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
50 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
59 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
37 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
18 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
44 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
41 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 ...
1
vote
1answer
627 views

Passing escape sequences to shells within ansi-term in Emacs

In a regular terminal (e.g. iTerm2 on OS X) I can connect to a database, e.g. > psql .... and then, as I type my command in psql, e.g. $ select foo from bar I can move around (as I type psql ...
3
votes
1answer
41 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
48 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
148 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
27 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/...
0
votes
1answer
19 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....
5
votes
2answers
1k views

Systemd postgresql start script

I'm in the process of installing postgresql onto a second server Previously I installed postgresql and then used the supplied script ./contrib/start-scripts/linux Placed into the correct dir # cp ...
0
votes
2answers
97 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
93 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
51 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
15 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
39 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 ...
0
votes
1answer
49 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 ...
2
votes
1answer
32 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
31 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
327 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 ...
0
votes
0answers
35 views

Installing Ubuntu and PostgreSQL database on different drives

I just received a new root server with the following drives: Disk /dev/sda: 480 Gb Disk /dev/sdb: 480 Gb Disk /dev/sdc: 240 Gb This one: https://www.hetzner.de/de/hosting/produkte_rootserver/...
2
votes
2answers
80 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
0answers
53 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 ...
2
votes
2answers
485 views

Permanently change permissions of /var/run/postgresql

On Linux Mint 17.0 Cinnamon Edition, I want to use /var/run/postgresql as the unix_socket_directories option for all of my postgres databases. Whenever I run the command pg_ctl -D postgres-data -o '-...
0
votes
1answer
39 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 ...
0
votes
0answers
25 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 ...
1
vote
4answers
1k views

Releasing a deleted but open log file

my Debian server disk maxed out because of a large postgresql log file and while I have deleted it, it is still held by postgresql. When I restart postgresql I get an error as the disk is full and the ...
2
votes
1answer
3k 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 ...
1
vote
1answer
30 views

Basic Hosting Postgresql in Virtualbox + Ubuntu 14.04

I have configured Postgres to accept network connections from anywhere: In pg_hga.conf: host all all 0.0.0.0/0 md5 In postgresql.conf: listen_addresses = '*...
2
votes
1answer
851 views

cannot start PostgreSQL on OpenBSD 5.4 through rc.d

I've installed the postgresql-server package on OpenBSD 5.4 amd64, and I try starting it through its rc.d script, however, it doesn't look like it's running after that. opti# /etc/rc.d/postgresql ...
5
votes
5answers
12k views

pg_dump version mismatch on Debian

I'm running PostgreSQL on Debian Unstable/Sid. I've got the current versions (9.1) of postgresql, postgresql-client, postgresql-client-common (143) installed. The problem I'm having is trying to run ...
0
votes
2answers
1k views

No package pgadmin3 available

I'm running CentOS release 6.7 (Final) I'm trying to install sudo yum install pgadmin3 I keep getting Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process ...
0
votes
0answers
66 views

Cannot telnet to Postgresql Forwarded Port

I'm trying to portforward a PostgreSQL port using my DLINK ADSL Router. I have the following IP addresses. Public Internet IP 197.321.321.32 PostgreSQL 192.123.123.12:5432 (Port To ...
0
votes
1answer
191 views

PostgreSQL Remote Connection debugging

I'm having issues connecting to my PostgreSQL database from an online source. PostgreSQL seems to be setup up fine it is running on it's default port 5432 and the postgresql.conf has the following ...