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

2
votes
1answer
16 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 ...
0
votes
0answers
23 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 ...
0
votes
0answers
30 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
27 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: ...
1
vote
2answers
25 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
17 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
27 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 ...
1
vote
0answers
13 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
19 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 ...
1
vote
1answer
108 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
4answers
951 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 ...
1
vote
1answer
22 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 = ...
0
votes
2answers
164 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
26 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
67 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 ...
1
vote
1answer
29 views

PostgreSQL: too many connections for role “rep” on slave server

I tried to setup "master - 2 slaves" configuration by article on digitalocean ...
0
votes
0answers
18 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 ...
1
vote
1answer
36 views

PostgreSQL Accessible to Web Application

I have a server with PostgreSQL installed and there are scripts that are constantly modifying data in the database. PostgreSQL is running on it's default port 5432. I would like to be able to connect ...
1
vote
1answer
42 views

how to update postgres.conf path after relocating it from data directory

I'm installing a Postgresql-9.4 HA environment in RHEL 7, when I initialize postgres db - it creates a data directory and within the data directory goes postgresql.conf & pg_hba.conf files. Here, ...
2
votes
1answer
53 views

Stop a process from running on startup without removing it

Just for the heck of it I was running pgrep postgres and got a ton of results: postgres 1882 1 0 10:06 ? 00:00:00 /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c ...
0
votes
1answer
38 views

Couldn't connect to the primary server: postgresql HA installation

Trying to install Postgresql-9.4 High Availability (HA) in RHEL7, using three nodes. In all three nodes, installed postgresql, updated postgresql.conf and pg_hba.conf files accordingly. After ...
0
votes
1answer
40 views

Psql: Not a directory

I found my psql folder typing : $ which psql /usr/bin/psql But when I Tried get in I got this: where I am: root@localhost:/usr/bin# $ cd psql -bash: cd: psql: Not a directory I can see the ...
0
votes
3answers
124 views

Where my PostgreSQL database backup is stored after run pg_dump?

Login as a pgsql user Typed the following command: $ su - pgsql Get list of database(s) to backup: $ psql -l I choosed users database Type the following command $ pg_dump users > ...
1
vote
1answer
489 views

Couldn't find postgresql.conf & pg_hba.conf files in my postgresql installation

Following all the instructions from UNIXMEN, installed postgresql-9.4 in CentOS 6.4. Everything went well, started the service and could access pgsql screen. But when I try to configure the ...
0
votes
0answers
27 views

I have error in postgresql service

Today I would like to test my metasploit. So, first I run service postgresql start, so here problems: root@localhost:/# service postgresql start [....] Starting PostgreSQL 9.1 database server: main ...
0
votes
1answer
160 views

ufw won't allow connections to port 5432

I've installed Postgresql 9.4 on Ubuntu Trusty from the PGDG ppa. I've created a database and set it listen-addresses to '*'. I've made an entry in the pg_hba.conf file. I can connect locally with no ...
2
votes
1answer
209 views

What does exit code 130 mean for postgres command?

When attempting to start PostgreSQL server using the /usr/pgsql-9.2/bin/postgres command I get an exit value code of 130. However I could not find any documentation for the exit codes of this ...
0
votes
1answer
48 views

.sh script error issues

I have a sh script with which I connect to postgres DB and execute a psql command. The script is as shown below: /opt/postgres/9.2/bin/psql pcwh -U pcwhuser << EOF \i ...
1
vote
1answer
49 views

File/directory not being deleted?

Please see the screenshot. The image on the left says existing x installation found at /opt/x The image on the right shows the terminal where I attempt to delete the same directory. The terminal on ...
0
votes
1answer
279 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 ...
4
votes
1answer
111 views

unable to connect to forwarded port over ssh

I have two servers. Server 1 has access to an Oracle instance on a server I have permission to hit but not login to via SSH. I would like to use SSH port forwarding to connect from server 2 to server ...
0
votes
2answers
51 views

Is there an easy foolproof way to translate commands from Ubuntu to Debian, and vice-versa?

If I want to work between Ubuntu and Debian or switch to one or the other, would there be a good way to know what commands will work on both? I have set up Debian with sudo (i.e. by not choosing a ...
1
vote
2answers
92 views

Simulate PostgreSQL query timeout

I would like to test the behaviour of a program which executes queries to a PostgreSQL server in case of a query timeout. How could I simulate that?
0
votes
0answers
13 views

How to make roundcube work with pgsql?

roundcube & pgsql are running on different containers docker run --name to-postgres --expose 5342 -e POSTGRES_USER=roundcube -e POSTGRES_PASSWORD=roundcube -d postgres Now how shall I install ...
0
votes
0answers
126 views

can't run pgadmin3 on fedora22

i installed postgresql and pgadmin. when i try running pgadmin this is what i get: Warning: Mismatch between the program and library build versions detected. The library used 2.8 (no ...
0
votes
0answers
221 views

problem installing postgresql (opengeo) on fedora 22

I'm following the directions found at http://suite.opengeo.org/4.1/installation/redhat/install.html i created gedit /etc/yum.repos.d/OpenGeo.repo with the following text: [opengeo] name=opengeo ...
2
votes
2answers
348 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 ...
2
votes
1answer
2k views

Postgresql wont start after reboot. Kali linux Raspberry Pi 2 [duplicate]

I have been trying for days to get postgresql to work and it did briefly before a restart. How to I set the correct permissions? This is the error I get when I try to start the service after a reboot. ...
3
votes
3answers
4k views

How to solve the problem of PostgreSQL service doesn't start?

This is about Metasploit Framework. root@kali:~# service postgresql start [....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log ...
1
vote
0answers
256 views

GitLab install: psql error “role ”git“ does not exist” [closed]

I'm new to Unix administration. I have a virtual machine with FreeBSD 10.1 and I would like to install GitLab. I used this guide to install it, but on step 4 it doesn't work: ...
11
votes
1answer
11k 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? ...
0
votes
2answers
151 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 ...
0
votes
2answers
1k views

Centos 7 - Trying to install postgresql (from postgresql.org)

I am trying to install Socorro service on fresh Centos 7 (installed on Amazon ec2). I am following the instructions from the official documentation - Socorro. I installed the PostgreSQL 9.3 RPM ...
0
votes
0answers
321 views

Why does PostgreSQL 9.4 on CentOS7 not run via the `systemd` service file on boot?

As root, if I change to the postgres user with su -l postgres then run /usr/pgsql-9.4/bin/pg_ctl start -D ${PGDATA} -s -w -t 300, PostgreSQL starts successfully. As root, if I run systemctl start ...
0
votes
2answers
5k views

Shell script to execute psql command [closed]

I want to make an automated script to make a database user and password in Postgresql and also import some databases. When i execute my script bellow it stops somewhere and when i log out (CTRL+D or ...
0
votes
2answers
188 views

How to connect to PostgreSQL 9 from Drupal 7?

I want to connect to PostgreSQL 9 from Drupal 7. to install drupal files using the following steps. wget http://ftp.drupal.org/files/projects/drupal-7.15.tar.gz tar zxvf drupal-7.15.tar.gz ...
0
votes
0answers
570 views

Centos 7, Postgresql 9.4 Failed to Read Permission Data Directory in mounted Partition

I've a problem with start PostgreSQL 9.4 on Centos 7 Server. Because the partition /var/lib/pgsql/9.4/data/ (which contains PostgreSQL data is full) so I want to change to another partition. ...
0
votes
1answer
124 views

Centos & PostgreSQL - cannot create database cluster

I have a server with CentOS 6. I installed on it postgreSQL 9.4, but didn't tell my mate and he installed 8.4 which included in CentOS by default. So we removed (service remove postgresql) both of ...
1
vote
2answers
293 views

pgbouncer startup problem

I followed the steps from http://www.guguncube.com/1692/pgbouncer-installation-and-configuration-in-ubuntu for pgbouncer setup. When I start pgbouncer, I get the error Cannot open logfile: ...
10
votes
1answer
448 views

Why does `postgres` require a shell?

In my Debian Wheezy systems, I noticed that the postgres user 'postgres', the "PostgreSQL administrator", uses /bin/bash as shell. However, I cannot figure out why this is needed. Changing this to ...