Questions tagged [postgresql]

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.

Filter by
Sorted by
Tagged with
0
votes
1answer
971 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 ...
4
votes
1answer
3k views

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

I tried to setup "master - 2 slaves" configuration by article on digitalocean (https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-...
0
votes
0answers
36 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
157 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
1k 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, ...
3
votes
1answer
876 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
749 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
584 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 folder ...
0
votes
4answers
11k 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 > users.dump....
26
votes
2answers
66k 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 phpPgAdmin,...
1
vote
1answer
5k 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 ...
3
votes
1answer
2k 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 command....
0
votes
1answer
84 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 /opt/emms/emsam/tmp/...
1
vote
2answers
768 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 ...
14
votes
3answers
29k 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 ....
5
votes
1answer
989 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
63 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 ...
3
votes
2answers
993 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?
1
vote
0answers
294 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
3answers
3k 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
3k 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
8k 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 ...
88
votes
4answers
224k 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? ...
1
vote
2answers
391 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....
1
vote
2answers
3k 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
2answers
40k 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
730 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
1answer
415 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
2k 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: '...
13
votes
1answer
1k 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 /...
0
votes
1answer
273 views

DB Synchronization between main and DR site

I hope I am asking this question in the correct section. I have an environment setup for my application which consists of master / slave Postgresql databases. The master and slave are being ...
2
votes
1answer
514 views

Command-line editing and wrapping

When entering long queries into the command-line psql, my terminal[1] is not wrapping the input line correctly. Additional charactes wrap back to the left of the screen, but on the same line as the ...
1
vote
2answers
2k 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.....
1
vote
0answers
2k views

Postgresql 9.1 - Kali Linux

I started to read this book : http://www.amazon.fr/Metasploit-The-Penetration-Testers-Guide/dp/159327288X And I have some trouble with postgresql 9.1 (in Kali Linux). When I start msfconsole, I ...
1
vote
0answers
604 views

PostgreSQL installation error in debian

I'm trying to install PgSql in the system with following specs: Distributor ID: Debian Description: Debian GNU/Linux 7.1 Release: 7.1 x86_64 But I am getting an error like this The ...
2
votes
1answer
5k 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/...
1
vote
1answer
14k views

Server Not accepting TCP/IP Connections

I have a Wt application running in a CentOS server machine(Machine A) in the port number 9798. Application is up and I could view the web page with the URL, http://localhost:9798 But application is ...
1
vote
0answers
290 views

Add Solaris utf-8 support for Postgresql

I need to use utf-8, but "locale -a" produces: C POSIX iso_8859_1 the os is: SunOS cteraportal 5.11 NexentaOS_134f i86pc i386 i86pc Solaris Additional info: root@cteraportal:~# dpkg -l locales ...
2
votes
3answers
3k 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 ...
9
votes
2answers
7k views

What network protocols does a Postgres database server use?

I have a postgres 9.1 server running on the default port 5432 on an Ubuntu 12.04 cloud server. I want to open up the port, so I can make remote queries -- but I have to open the port on IP tables, ...
2
votes
1answer
1k 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 ...
1
vote
1answer
2k views

Adding Postgres bins to PATH: should I `export`? [duplicate]

I'm on a Mac, but this seems like a UNIX/Linux question. I just installed Postgres.app, and the documentation says to add the /bin directory that ships with Postgres.app to your PATH by adding the ...
2
votes
1answer
1k 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 ...
2
votes
3answers
12k views

CentOS 5: My Postgresql server version is different with my psql client. What should I do?

I installed PostgreSQL 9.1 in CentOS 5 x86_64 VPS, with these following commands: I specified which Postgresql version I'd like to install, so I choose 9.1 because I want to equate between ...
3
votes
2answers
5k views

Incremental backup of postgresql database

We run a database server running PostgreSQL with database size of around 130GB growing at a rate of 500MB per day. We use HP Data Protector software to take backups of the database. The issue here is ...
1
vote
3answers
3k views

Installing PostgreSQL 9.0 on RHEL 6.4 (How to get Yum to Include a version of OpenSSL I built from source)

I receive the following errors from yum install postgresql90-server: Error: Package: postgresql90-9.0.15-1PGDG.rhel6.x86_64 (pgdg90) Requires: libssl.so.10(libssl.so.10)(64bit) Error: Package: ...
4
votes
2answers
4k views

Logic behind Postgres binary installation path on Debian

It appears that the Postgresql installation is split into three folder locations on Debian: Configuration: /etc/postgresql Binaries: /usr/lib/postgresql Data: /var/lib/postgresql I ...
6
votes
3answers
1k views

Passwords for newly created users?

I am fairly new to Linux and I have question regarding users. When I use the useradd command I don't specify a password. I must use the passwd command afterwards. Does this mean that the user is ...
1
vote
1answer
215 views

how to configure postgresql to log in remotely and locally

In order to be able to connect to my postgresql database from another machine, I had to configure my postgresql.conf file like so: #-------------------------------------------------------------------...
3
votes
1answer
2k views

Is it possible to import vmail folder from old iRedMail to new iRedMail installation?

Basically, what I did: Copied vmail folder to my local machine. Reinstalled my VPS. Installed iRedMail again. Created same users on the same domain. Question is - can I somehow copy over my old ...