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.
10
votes
1answer
216 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
0answers
31 views
PgPool - Host Based Routing
I'm using pgpool to distribute my connections between my master and slave postgresql databases.
What I would like to know is if there is a feature where I can tell pgpooler to route connections ...
0
votes
1answer
22 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
61 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
0answers
940 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 ...
1
vote
0answers
299 views
Postgresql 9.1 - Kali Linux
I start to read this book : http://www.amazon.fr/Metasploit-The-Penetration-Testers-Guide/dp/159327288X
And i have some trouble in using postgresql 9.1 (in Kali Linux).
When i start msfconsole, i ...
1
vote
0answers
83 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 ...
1
vote
1answer
376 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 ...
0
votes
1answer
170 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 ...
1
vote
1answer
98 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 ...
1
vote
2answers
84 views
What network protocols do database servers 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, ...
1
vote
0answers
207 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 ...
0
votes
1answer
145 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 ...
0
votes
1answer
190 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 ...
0
votes
2answers
371 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 ...
1
vote
2answers
648 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
2answers
1k 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: ...
2
votes
2answers
143 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 ...
0
votes
0answers
212 views
Postgresql 9.3 with posgis extenstions not working after restart
I'm running Mint 16.
In pgAdmin it gives me this output.
An error has occurred:
ERROR: could not load library "/usr/lib/postgresql/9.3/lib/postgis-2.1.so": libjson.so.0: cannot open shared ...
6
votes
3answers
153 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
46 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:
...
2
votes
1answer
161 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 ...
4
votes
2answers
1k 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.
...
1
vote
1answer
599 views
How to write a Shell Script using the condition from a database
Consider this is the condition I need to check
select count(*) from nm.table1 where column1 =true;
Now it should come out of the db (PostgreSQL) and use IF THEN ELSE LOOP in the Unix
Something ...
1
vote
0answers
112 views
Postfix, postges courier-imap / relay reject error on gentoo
I followed a guide to put together a server https://wiki.gentoo.org/wiki/Complete_Virtual_Mail_Server it went smooth with no real headaches. First domain works like a champ but adding a second domain, ...
1
vote
0answers
135 views
Firewall config prevents hibernate connecting to postgres in CentOS6.3
I have an operating environment in CentOS 6.3 that has tomcat7 and postgres9.2 installed. There is just one web application deployed in tomcat that tries to establish a connection from localhost to ...
1
vote
1answer
102 views
Change default python distribution for postgres from the system's python (to Enthought Canopy)
On an RHEL6 system, I'd like my postGIS implementation (ie my postgres/postgresql databases) to use Enthought's Canopy distribution of python, rather than the built-in GNU's distribution. (This is ...
1
vote
1answer
152 views
How do I time how long my pg_restore takes in the command line?
I'm trying to track the amount of time the process takes for when I move around my data and upgrade my web app. From the command line, how would I track the amount of time elapsed from when the ...
1
vote
2answers
472 views
Saving all incoming messages into a database with Postfix?
Is there some plugin for Postfix that can allow you to save all incoming messages into a relational database (PostgreSQL)?
1
vote
2answers
3k views
Can't install PostgreSQL 9.2 on Linux Mint
I'm new with Linux systems. I tried to install PostgreSQL 9.2. I did the following:
sudo apt-get update
sudo apt-get -y install python-software-properties
sudo add-apt-repository ppa:pitti/postgresql
...
1
vote
1answer
1k views
Cant get remote access to PostgreSQL
There is PostgreSQL 9.2 in Debian. My /etc/postgresql/9.2/main/postgresql.conf file contains:
listen_addresses = '127.0.0.0, 212.49.109.137'
password_encryption = on
'212.49.109.137' is the IP of ...
1
vote
2answers
2k views
postgresql service start issues
I'm attempting to build a box via Fabric on Openstack. Part of the install involves installing and running PostgreSQL.
This command works fine:
$ sudo service postgresql initdb
This command ...
3
votes
5answers
3k 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 ...
1
vote
1answer
823 views
Install postgresql 9.2 on debian wheezy (on virtualbox)
I have virtualbox with Debian Wheezy. I'm trying to install Postgresql 9.2 on it. When I trying do it by this instruction i have next:
Reading package lists... Done
Building dependency tree
Reading ...
0
votes
1answer
45 views
How to restore the user postgres?
In the second answer in this thread is a warning about changing the UNIX password for "postgres".
I have already changed the password for "postgres".
How could I restore the initially state of the ...
3
votes
1answer
331 views
Upgrade Minor Version of Postgres in Debian using apt
I'm trying to move from 9.1.3 to 9.1.4. I thought all I had to do was "apt-get update" and "apt-get upgrade", but that didn't work. It did install some updates, but that was only for 9.1.3. Any ...
1
vote
2answers
188 views
How do I specify which version of a program to run?
Here's my situation: I have two versions of postgres installed, and with the two versions, come two different psql interactive terminals.
One is located at /usr/bin/psql, and starts when I run # ...
2
votes
1answer
449 views
Running a query without the OS cache
I want to emulate a client site who doesn't have much caching because they have so much I/O all the time. I want to run a SQL query on my machine (on my VM to be precise) with the same limitations ...
6
votes
3answers
1k views
Choosing Linux Distro for PostgreSQL
I'll begin by saying I'm a newbie sys admin.
I need a new PostgreSQL 9.1 machine. My go to distro is Debian (for no good reason other than it's what I first learned). However, when I started ...
1
vote
2answers
120 views
Find all postgresql and mysql databases on a system
Is there a way to find all postgresql and mysql databases on my system? (Perhaps using the find command).
0
votes
1answer
340 views
Postgres 9.0 linux command to windows command conversion [closed]
i am working on an application using delphi 7 as the front end and postgres 9.0 as the back end.
I have to upload images to the server so i use \lo_import and \lo_export for inserting images on the ...
1
vote
1answer
348 views
PostgreSQL on FreeBSD - 'Kerberos 5 authentication not supported'
I've been trying to get a FreeBSD machine to talk to a networked postgreSQL database. I assumed that the machine had kerberos installed, as it's what I use to log in, and I was told that FreeBSD has ...
1
vote
0answers
727 views
“No PostgreSQL user name specified” - possible concurrency issues?
For my dissertation I'm running the same cronjob on around 300 machines, which is:
10,25,40,55 * * * * /path/to/db_script.sh 1>/dev/null
This script gets some values from the system (whether ...
2
votes
1answer
402 views
/etc/rc.d/postgres start vs rc.d postgres start
What's the difference between those two commands?
/etc/rc.d/postgres start
and
rc.d postgres start
Aren't those interchangeable?
I tried starting PostgreSQL using the latter, but it only works ...
6
votes
3answers
366 views
How can I build and install PL/R as a non-privileged user?
There is a postgres instance, and I have the ability to build my own instance.
Using these instructions I ran:
USE_PGXS=1 make
which worked but then
USE_PGXS=1 make install
did not, with this ...
4
votes
1answer
519 views
How do I pg_upgrade my database on Arch Linux?
I was running postgres 8.4 on arch but now have 9 installed I want to use pg_upgrade to upgrade but I don't know what all the options I have to use are, and all the directories that I have to point it ...
