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
46 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
52 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
61 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
59 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
83 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
21 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
75 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
234 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
177 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
151 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
28 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
42 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
64 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
123 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
27 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
57 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
54 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
139 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
271 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
358 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
253 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
122 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
347 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
92 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
31 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
40 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
170 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 ...
0
votes
1answer
72 views

Lots of connections to loopback, could be slowing us down

I'm trying to debug a sudden increase in our load average. I looked at this page to see if we were being DDoS'ed but the standout IP address was the loopback address: $ netstat -ntu | awk '{print ...
0
votes
0answers
49 views

Moved offices and now cannot connect remotely to postgres

Everything was working in my previous office. I've now moved to a new office, and cannot connect remotely to postgres. SSH works though. My IP is currently 70.90.155.138. Could not connect to ...
0
votes
0answers
47 views

Downgrade to postgis 1.5 and postgresql-9.2 on Ubuntu 13.10

I am having a hard time after having my Ubuntu upgraded. The main problem is that I have a postgis enabled database since postgresql 8.4. I have always updated the OS and databases, as soon as the ...
0
votes
1answer
10 views

PostgreSQL 9.2 segfaulting on corrupt files

After a server crash one or more of Postgres' files have been corrupted (at least, for now, I will assume it is due to the crash and not due to faulty hardware). The problem seems to be limited to ...
1
vote
1answer
205 views

Can't read files into postgres

We've just set up a postgres 9.3 server on a Windows 7 machine. If we try to copy data into a database from C:\dbfeeds\csv.csv we get the following error: ERROR: could not open file ...
1
vote
1answer
43 views

postgres: I can't see queries logged queries. Log files are empty

I am trying to master database queries optimization. And as a first step I need to log all queries (and their execution time to log files). My config file looks this way (I believe I have turned on ...
2
votes
0answers
93 views

Bugzilla extremely slow on EC2, RDS PostgreSQL

The Problem I have installed Bugzilla on an EC2 instance, using PostgreSQL RDS as my database. After entering a few dozen bugs, Bugzilla became unbelievable slow, and I get a lot of timeouts. ...
2
votes
0answers
396 views

Docker: Permission denied on folders added with ADD

I'm trying to configure a postgresql installation using docker. FROM ubuntu:13.10 ADD . /db # install postgres # ... RUN chown postgres:postgres /db -R && \ chmod 700 /db -R USER ...
1
vote
1answer
73 views

Postgres SSPI authentication on Windows

I'm trying to enable windows authentication for Postgresql 9.3 (Windows x64 not in domain, UAC is disabled, my account is local admin). The one click installer set the server running under ...
0
votes
1answer
193 views

Postfix with Pgsql support

I'm trying to find an alternative repo with postfix that has pgsql support on Cenots 6. I previously used CentAlt but since that seems to be dead now i'm trying to find an alternative. I would ...
0
votes
0answers
201 views

Database connection to postgresql refused for flask app under mod_wsgi when started by systemd

I'm having a weird problem where a flask application I am trying to run (https://github.com/pyfarm/pyfarm-master) under mod_wsgi under Apache under CentOS 7 cannot connect to a local postgresql server ...
1
vote
1answer
41 views

Postgresql: missing data after crash

I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet). Server: centos, Postgresql: 9.2.8 It looks like all my postgresql databases were reverted to the state ...
1
vote
2answers
72 views

How can I solve these connection-issues with pgadmin?

We have in our local network a server with a Postgres-Installation. Now, as some big inserts (needed days) were running, others had problems connecting via pgadmin. After opening the Server in pgadmin ...
0
votes
0answers
39 views

Is it possible to use pgFouine with a log_line_prefix other than '%t [%p]: [%l-1] '?

I have a postgres serverlog with this setting: log_line_prefix = '%t - %u - %d - %r - %p - ' I would like to analyze this log using pgFounine, but pgFouine seems to require this setting: ...
1
vote
1answer
47 views

PostgreSQL asynchronous cluster with partial synchronous commits

We`re planning a complete synchronous PG Cluster with 3 nodes but we asked ourselves if its possible to have an asynchronous cluster with partial synchronous commits. Normally you make your cluster ...
0
votes
0answers
71 views

Why postgres 9.3 table keeps losing the primary key and indexes?

In pg 9.3 database, table engine_configs keeps losing primary key (id) and indexes. Here is the table: For the table shown above, we just added the primary key again and it is showing integer in ...
0
votes
1answer
47 views

Different technologies for syncing with server

Well, I'm currently teaching DB in a course in University. Students had already gone through advanced programming (this includes torturing them through a whole semester with massive projects, they ...
3
votes
0answers
142 views

Using ZFS head node as database server?

I'm using a dual-head ZFS-backed NAS for high availability cluster shared storage, based on Nexenta's recommended architecture as seen here: The disks in 1 JBOD will store the database files for a ...
0
votes
0answers
17 views

Postgres 9.3 on Linux - Resource utilization - Multiple vs one service services

I'm consolidating multiple Linux boxes running Postgres into one box. Given the way Postgres handles resource utilization, would one single server service handling all the databases provide a much ...
3
votes
2answers
1k views

Postgresql read replication using an amazon postgresql RDS service as master

we currently are using amazon Postgresql 9.3 RDS as a master database for a gaming platform. We would like to create a read only replication to use for reporting and heavy queries. Yes, it seems ...
1
vote
1answer
310 views

Munin Postgres plugins: DBD::Pg not found

I'm trying to activate some of the Postgresql plugins for Munin. When I run munin-node-configure --suggest | grep postgres I get the following output: postgres_bgwriter | no | no [DBD::Pg ...