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
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 ...
4
votes
1answer
4k 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. ...
2
votes
1answer
3k 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 ...
2
votes
0answers
241 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
494 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
742 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 ...
3
votes
2answers
4k 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)?
2
votes
2answers
5k 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 ...
2
votes
1answer
4k 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 ...
2
votes
2answers
9k 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 fails: ...
8
votes
5answers
21k 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
2k 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
83 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
1k 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
238 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
660 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
4answers
3k views

Choosing Linux Distro for PostgreSQL

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 looking at documentation, it appears that Debian ...
2
votes
2answers
210 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
518 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
652 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
2k 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
596 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
665 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
1k 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 ...