PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX ...

learn more… | top users | synonyms (1)

0
votes
1answer
74 views

How to install Postgres 9.3 parallel in Debian Squeeze

Debian 6 contains Postgres 9.1 installation installed from Debian backports in 5432 port How to install Postgres 9.3 also on this server. I found instructions in ...
0
votes
0answers
109 views

“bin/unpack200: not found” when installing TeamPostgreSQL

Running Ubuntu 14.04 64bit. I downloaded the 68MB .sh file from the project website. When I run the file with sudo I get the following output: ben@tardis:~$ sudo ./teampostgresql_ubuntu.sh Unpacking ...
0
votes
0answers
70 views

pgpool2 parallel mode: Non-superusers must provide a password in the connection string

I have two AWS RDS postgres nodes backing a parallel mode pgpool setup on EC2. After using pgbench to populate test tables, I get odd behavior from test queries. Any query that uses a function ...
0
votes
1answer
20 views

autocomplete is not working in postgreesql 8.4

I have installed postgresql 8.4.21 in my CentOS 5. But when I fire Select Query is it not showing me any completion if I press TAB key.. database=# select count is it any configuration in ...
2
votes
1answer
302 views

Postgresql 9.3 Log Shipping on a Hot Standby

My setup I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so ...
1
vote
1answer
180 views

Django: CONN_MAX_AGE persists connections, but doesn't reuse them with PostgreSQL

I've got a django setup are using Django 1.6.7 and Postgres 9.3 on Ubuntu 14.04 LTS. At any given time, the site gets about ~250 simultaneous connections to the PostgreSQL database, which is a Quad ...
0
votes
1answer
98 views

Connect with Java to Amazon EC2 instances

I have written a client-server application in Java and I want to run it on Amazon EC2 Ubuntu instacnes. The client runs on an EC2 instance and the server on one and the third EC2 instance is for ...
0
votes
2answers
114 views

postgreSQL archive process failed on

I upgraded a cluster from 8.3 to 8.4. Things seemed to be fine so I dropped the 8.3 cluster. Then noticed an error and found that the archive_command was still pointing to the 8.3 data directory ...
0
votes
0answers
106 views

Unable to proceed with Bucardo installation

I'm installing Bucardo to use it with PostgreSQL. My problem is, after I have created a process ID directory (something like /tmp/bucardo) and when I tried to proceed with the installation with the ...
0
votes
0answers
103 views

I Cannot Connect to PostgreSQL After Installing the Server App (OSX Mavericks)

(This is also posted in Ask Different.) I am running the latest version of Mavericks 10.9.5 on my Mac Mini Server. Before the upgrade to the latest version of the Server App 3.2.1 I was able to ...
0
votes
1answer
81 views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
0
votes
1answer
55 views

Password Manager Pro backend database MS SQL vs PostgreSQL [closed]

I'm looking to manage users passwords through the programme Password Manager Pro. Reading the documentation it explains that you can use ether your own MS SQL database or use their default PostgreSQL ...
0
votes
2answers
54 views

How do I update YUM repositories to get Postgres9.x version?

I need to install some Postgres9.1 libs, but "yum list" only shows 8.4 version. How to "update" yum repo list to get 9.1 version? My Linux version: # cat /etc/redhat-release Red Hat Enterprise ...
0
votes
1answer
70 views

how to query postgresql database via salt

I need to run a query on a postgresql database in a module I'm writing for Salt. It won't do much, just query a table for a value to determine what version of the software is installed. The docs have ...
0
votes
1answer
66 views

OpenShift allow permanent external access to PostgreSQL [closed]

I have an OpenShift gear with Nginx and PostgreSQL, and need to allow a Java applet (served from Nginx) direct access to the PG database. I've already tried to edit ...
1
vote
0answers
113 views

Changing kernel.shmmax and kernel.shmmal on ubuntu?

We have an Ubuntu server with 6GB of RAM. We are trying to install Postgres but it is advising us to increase the values for kernel.shmmax and kernel.shmmal. The server is solely a Postgres DB ...
0
votes
1answer
53 views

Daily postgresql cron error log file

I am getting these emails daily: /etc/cron.daily/logrotate: error: error accessing /var/log/postgresql: No such file or directory error: postgresql-common:1 glob failed for /var/log/postgresql/.log ...
0
votes
0answers
35 views

.pgpass other system user as in file

i have a working script with a working .pgpass file. Now i want to run the script as root with the same(copy) .pgpass file. I copied the file in the $HOME directory from root. And changed permission ...
0
votes
1answer
45 views

pg_createcluster ssl cert behaviour different for 9.1 and 9.3 on Debian Squeeze

I think i found a bug in pg_createcluster when creating a 9.3 cluster. At first, my configuration: Debian Squeeze with PostgreSQL 9.1 from squeeze-backports and PostgreSQL 9.3 from apt.postgresql.org ...
1
vote
0answers
19 views

psql: How to include comments in \d output

In PostgreSQL it is possible to add comments to table columns. These will appear in the psql output from the "extended describe" \d+ command, however they will not appear in the standard \d output. ...
2
votes
2answers
106 views

How to minimize bandwidth in frequent postgres backup scenario?

I'm looking to make very frequent backup (every hour) of postgres data on several VMs (say 20-50) towards the same archive server. Here are more data if needed: Ideally, the system should support ...
0
votes
1answer
57 views

How to correctly run PostgreSQL on Fedora

I decided to to run PostgreSQL on my Fedora 20, so I did sudo yum install postgresql-server.x86_64 postgresql-libs.x86_64 postgresql.x86_64 Now if I do postgres -D /var/lib/pgsql/data under ...
1
vote
1answer
54 views

Databbase file structure on disk [closed]

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most ...
1
vote
1answer
65 views

CentOS / PostgreSQL. How to keep connections open?

I would like to keep connections open on PostgreSQL for N time. I am not having problems keeping PostgreSQL itself open. The issue is that when the connection is idle for a few minutes, the ...
19
votes
2answers
1k views

Customer wants open postgresql port, how to make that secure?

So, this is the situation. It seems, we need to have an open tcp port 5432 for the world, where a customer has access to his postgresql database. Because obvious reasons, we can't say just "no", only ...
0
votes
0answers
75 views

pg_top does not show any postgres processes

postgres/postgresql is running but pg_top (pg_top -d postgres -U postgres) does not show any processes top: 1283 postgres 20 0 235m 5392 5204 S 2 0.0 881:17.41 postgres pg_top: last pid: 23462; load ...
1
vote
1answer
103 views

Postgresql failed to start server (startserver.vbs) on Windows Server 2008 R2 Enterprise (64b)

Trying to install postgresql in a Windows Server R2 Entreprise (64b) I get this: Iniciando el servidor de bases de datos... Executing cscript //NoLogo ...
1
vote
1answer
27 views

Most efficient way to upgrade postgresql 9.0.1 to latest minor version

What is the most efficient way to upgrade postgresql to the latest minor version when I'm running an operating system (Fedora Core 10) that's too old to be supported by official RPM releases? I have ...
0
votes
0answers
101 views

`rake db:migrate RAILS_ENV=production` gives error

When I run the command: rake db:migrate RAILS_ENV=production I get the following error: rake aborted! PG::ConnectionBad: could not connect to server: Connection refused Is the server running ...
2
votes
1answer
286 views

Cannot stop service (PostgreSQL) in Ubuntu 14.04 minimal OpenVZ

I'm trying to stop PostgreSQL but this results in a weird error about /proc/: root@dw0wanydbpv14fred:~# service postgresql stop * Stopping PostgreSQL 9.3 database server * Error: /proc must be ...
-2
votes
1answer
186 views

Why am I getting this 404 error trying to install postgresql 8.2 on centos 6?

Im trying to install postgresql 8.2 on centos 6 but when i add the repo for it and do a yum upgrade or try to install the package i get the following error yum upgrade Failed to set locale, ...
0
votes
1answer
192 views

Stop postgresql container

I have a question about stop database container. I have a docker image that runs postgresql. When I create a container with this image: sudo docker run --name db -d asg1612/postgresql it run ...
0
votes
1answer
31 views

A more complex PostgreSQL query log

There are some laws in my country that require me (as a service provider) to have a log which explains which person did what action. Now I know that PostgreSQL has a query log, but I was wondering if ...
0
votes
2answers
48 views

PostgreSQL password issue with psql

I'm trying to setup PostgreSQL onto a CentOS (that I connect through SSH). I need to unzip a package (so not downloading through yum or rpm): ...
0
votes
1answer
78 views

Corosync and Pacemaker deployment

I'm currently working on a deployment architecture for a Postgres HA 1 Master/ 1 Slave scenario. After reading lots and lots of documentation I've decided to start using Pacemaker in conjunction with ...
1
vote
1answer
179 views

PostgreSQL user authentication against PAM

I am trying to set up authentication via PAM for PostgreSQL 9.3. I already managed to get this working on an Ubuntu 12.04 server, but I am unable to get this working on a Centos-6 install. The ...
0
votes
0answers
33 views

PostgreSQL replicate data have different time

I'm notice that when I replicate data between 2 server with different time zone, the time data in PostgreSQL is shifted when I load it to a client (in my case, a Rails console). I thought all ...
0
votes
1answer
75 views

Multiple Postgres Servers (one writer, multiple reader) with Shared Disk

Here's the scenario: One shard disk (Gluster) Multiple Postgres servers Requirements: Use the shared disk to store the database files Use a configuration which provide maximum efficiency ...
0
votes
1answer
56 views

Unaccent for postgresql 9.0.8 (over RHEL6)

I need to install the unaccent extension in a postgresql server 9.0.8 running over a RHEL6 box which doesn't have the contrib package. So I need to install postgresql-crontrib first. Facts: Server ...
0
votes
1answer
166 views

Weblogic security store on PostgreSQL

I am trying to port a Weblogic environment from Oracle to PostgreSQL. When I configure a domain with the security store on PostgreSQL, it fails to start. Weblogic 12c, Java 7, PostgreSQL 9.3.4 here ...
1
vote
1answer
484 views

PostgreSQL failed to start, pg_log shows nothing, what to do?

I've just setup PostgreSQL (9.3) as a replication to another server. When I started it with service postgresql-9.3 start, it reported [FAILED] without any further explanation. I don't see any thing ...
3
votes
1answer
545 views

psycopg2 not found by django after installing in virtualenv

I want to use postgresql with django so did the following: sudo apt-get install libpq-dev python-dev sudo apt-get update workon myenv sudo pip install psycopg2 And after configuring my settings.py ...
1
vote
1answer
2k views

Connect to RDS from EC2 instance — both inside VPC

I have a VPC with two private subnets (two were required to get an RDS instance set up). I have a security group for this VPC, let's call it vpc-sg. vpc-sg allows TCP access on port 22 from my home ...
-3
votes
1answer
366 views

Psql uses .pgpass file however pg_dump does not, and it also does not connect using the correct password [closed]

Using the following command: % pg_dump -h postgres.cs.host.ca -p 5433 -n _cscf_subscription -Fc -f ~/old.dump odyssey_prod Password: pg_dump: [archiver (db)] connection to database "cs-rsub" failed: ...
3
votes
1answer
124 views

`psql` expanded mode equivalency for `mysql`

Am frustated by things like: 0:33:1407402356:root@ahost:~# echo 'use wordpress_3_6_1; select * from wp_posts;' | mysql -u mysqluser -pmysqlpasswdord | wc -l -L 42 40585 SQL query results being ...
0
votes
0answers
386 views

java.lang.ClassNotFoundException: org.postgres.Driver when starting PuppetDB

When I start puppetdb I am getting the following error: cat /var/log/puppetdb/puppetdb.log 2014-08-06 11:29:50,558 ERROR [main] [utils.logging] Uncaught exception java.lang.ClassNotFoundException: ...
0
votes
1answer
157 views

Which package to upgrade psql client?

I have updated my Postgres install from 8.4 to 9.3. Now when I log onto the server with the initial command sudo -u postgres psql template1 I get the following error psql (8.4.18, server ...
0
votes
2answers
32 views

OpenNMS installation failure

I am willing to use OpenNMS to monitor my network. Monitoring it fully from the router to the nodes from a computer will be connecting the network as node not as administrator and that computer using ...
0
votes
0answers
48 views

Bucardo status does not feel if the slave is down

I am using bucardo as third party to postgresql replication between two sites. everything ok except buacrdo status <sync_name>. I have a Master-slave sync on master server. when I poweroff the ...
0
votes
0answers
207 views

Remove pgdg-centos92-9.2-6.noarch.rpm or enable for install PostgreSQL in CentOS 6.5

I'm trying to install PostgreSQL 9.2.6 in CentOS 6.5 and I doing as follow: Install PostgreSQL 9.2 repository rpm -Uvh ...