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.
0
votes
1answer
24 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
36 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
1answer
201 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
...
0
votes
1answer
59 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
63 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 ...
1
vote
2answers
256 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
285 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
35 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
173 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
148 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
290 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
753 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
89 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
193 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
224 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
544 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
298 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
273 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 ...
