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

0
votes
0answers
30 views

Apache PostreSQL database server only

I was wondering if it's possible to use apache to make a postgresql database available for connections from the web without using a website to interface with the database. Instead of having a webpage ...
23
votes
1answer
31k views

Command to list PostgreSQL user accounts?

There are createuser & dropuser commands: createuser - define a new PostgreSQL user account dropuser - remove a PostgreSQL user account Is there a corresponding way to list the user accounts? ...
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
22 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 ...
1
vote
0answers
55 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
33 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
23 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 ...
0
votes
1answer
88 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 ...
1
vote
0answers
21 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
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
36 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
184 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....
0
votes
1answer
70 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
12 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
57 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
45 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
701 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
89 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
37 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
74 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
76 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
57 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
20 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
57 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
62 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
634 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
55 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
68 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
207 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
29 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
23 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
162 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
114 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
54 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
16 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
45 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
58 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
37 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
394 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
36 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
96 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 ...
2
votes
2answers
530 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
30 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
4k 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
33 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 = '*...