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)

1
vote
1answer
25 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
27 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
13 views

Error installing postgres on Windows 8 [migrated]

I am using a Windows 8 laptop as my dev server. I am trying to install postgres on my laptop, but I get the following error: Unable to initialise db cluster Here is a video of my efforts ...
0
votes
0answers
8 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 ...
0
votes
0answers
13 views

How does MS SQL Server authenticate MSDTC connections when using SSPI? [migrated]

I'm trying to get SSPI authentication to play well with two-phase transactions via MSDTC, using PostgreSQL with psqlODBC. I can't figure out how it can work securely - so I'm hoping someone can ...
1
vote
1answer
18 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
30 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
31 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 ...
0
votes
0answers
22 views

Is there a way to test Postgresql connection from VMware Fusion on a Mac? [migrated]

I have some reasons to believe that VMware Fusion is not connecting to my postgresql database hosted on my Mac OS. Is there a way to test this connection from my Windows portion through VMware?
1
vote
1answer
18 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
15 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
7 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
20 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
22 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
42 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
64 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
12 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 ...
0
votes
1answer
110 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
42 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 ...
0
votes
1answer
39 views

What should the permissions be on for PostgreSQL /data files?

I installed Postgres 9.3 from the osX binary. When I attempted to restart using pg_ctl restart, I received the following error: $ pg_ctl restart pg_ctl: could not open PID file ...
1
vote
1answer
116 views

How can I set up an Amazon RDS for PostgreSQL database to act as a replica to a non-RDS PostgreSQL database?

I'm trying to set up an PostgreSQL database on Amazon RDS as a replica to another PostgreSQL database that lives on a regular server. Most of the instructions I've found online require shell access so ...
1
vote
1answer
150 views

Postgres - could not create any TCP/IP sockets

I'm running a rails app in development with postgresql 9.3. When I tried to start passenger server today, I got: PG::ConnectionBad - could not connect to server: Connection refused Is the server ...
0
votes
0answers
32 views

Deleting log files from an AWS RDS Postgres instance

How can I delete logs from an RDS Postgres instance? I just noticed that my instance is displaying the message, storage-full. I can find any descriptions of how to deleted the log files, which I think ...
0
votes
0answers
28 views

Bash Script issue : Discrepancy in output when executed via cron [duplicate]

I have written a bash script that writes date and database size of a DB to a text file. The script is executed via cron every week. There is some discrepancy in the output that is being generated . I ...
1
vote
1answer
57 views

Loading a big database dump into PostgreSQL using cat

I have a pair of very large (~17 GB) database dumps that I want to load into postgresql 9.3. After installing the database packages, learning more or less how to use them, and fiddling around a little ...
2
votes
1answer
99 views

32bit ODBC Postgres driver on Windows 2008 R2 x64

I'm trying to install the Postgres ODBC 32bit driver on a Windows 2008 R2 64bit machine. After installing it, with no errors, I go to the ODBC panel, the 32bit version under the /syswow64 folder and ...
0
votes
1answer
382 views

What's the difference between sudo su - postgres and sudo -u postgres?

PostgreSQL users peer authentication on unix sockets by default, where the unix user must be the same as the PostgreSQL user. So people frequently use su or sudo to become the postgres superuser. I ...
2
votes
2answers
65 views

simple script to backup PostgreSQL database

Hello I write simple batch script to backup postgeSQL databases, but I find one strange problem whether the pg_dump command can specify a password? There is batch script: REM script to backup ...
0
votes
0answers
11 views

How can I determine number of servers and configuration? [duplicate]

I am developing a GIS application which support for 20000(twenty thousand ) concurrent users/second. This application is used to find way in a very large shop center. My database is: PostgreSQL ...
0
votes
1answer
42 views

postgres stopped - how to restart?

my postgresql (9.3.4) was running on Ubuntu, and suddenly stopped tonight. When I try to stop it, logged in as postgres, I get ~$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop; pg_ctl: ...
2
votes
1answer
83 views

Why can't user login on Postgres

I have attempted to set up a read-only user in Postgres, but they are unable to log on. I am unsure the next step to take to solve the problem. When I try and log on as user XXXX I get an error - ...
1
vote
1answer
81 views

Postgresql replicas stuck in recovery (archive_command won't run on replicas)

We're currently running a master -> slave, slave, slave, slave set up using postgresql 9.2.8 with streaming and WAL-E/S3 for handling wal segments. Should all of the replicas currently be "in ...
0
votes
0answers
121 views

Joomla Extension Uninstall Causes 502 Bad Gateway

We have a VPS with some PHP websites hosted on our Ubuntu 12.04 LTS servers using NGINX. In a Joomla 3 site, when uninstalling an extension that errors out, the page shows an NGINX error page with a ...
0
votes
2answers
60 views

PostgreSQL fails to start — no clear reason

I have a server which was happily running PostgreSQL, until a crash this morning. Trying to restart Postgres, but it fails: sudo /etc/init.d/postgresql start Starting PostgreSQL 9.1 database ...
0
votes
1answer
476 views

issue in installing postgresql 9.3.4 on Windows server 2003 x64

Hello i really did all what i know to install the PostgreSQL 9.3.4 on my windows 2003 server x64, but i'm always stopped with this error : please see the error : http://oi57.tinypic.com/s4tb8i.jpg I ...
0
votes
1answer
23 views

What do the return codes mean for pg_archivecleanup?

I'm trying to run pg_archivecleanup from our DR Postgres server (Windows), but I am getting return code 2. I am guessing that the issue may be permissions since I can run the command myself and it ...
1
vote
1answer
194 views

PostgreSQL master constantly demoted by pacemaker with repmgr

I'm in the process of setting up a PostgreSQL 9.2.8 cluster made of 2 nodes, one master, and one slave. I use streaming replication and repmgr 2.0. My platform is RHEL 6.3. Master and slave can be ...
0
votes
1answer
189 views

Cannot set postgres user password

Trying to install PostgreSQL with Ruby on Rails with Nginx on CentOS 6.5 using the following guide: ...
1
vote
1answer
133 views

PostgreSQL v9.3.4 memory usage Issue on Windows Server 2008 R2

I have DB of size ~16GB Windows Server 2008 R2 (up to date). We moved from Postgres v9.2.4 to Postgres v9.3.4 and now Postgres v9.3.4 memory usage is growing until is takes all the windows physical ...
0
votes
3answers
158 views

Dovecot - auth error permission denied

The following log file arises off my current maillog: Apr 24 17:44:48 h2290750 dovecot: auth: Error: pgsql: Connect failed to mail: could not connect to server: Permission denied Apr 24 17:44:48 ...
0
votes
0answers
14 views

Dovecot and reconnection to database

I've got a setup with Dovecot using a PostgreSQL backend together with vmm. I usually get messages like this into log: dovecot: dict: pgsql(10.0.0.2): Connected to database mail Based on ...
2
votes
0answers
95 views

Database hangs when using owncloud on nginx php5-fpm postgresql - i think postgres if responsible

I have strange problem with this setup. Strangely it occurs only when using owncloud from one specific computer. Problem is when user click on "Activities" an "document" icons one after another ...
0
votes
3answers
154 views

Apache: 403 Forbidden for WSGIScriptAlias

I am trying to install istSOS following these instructions from the website: Installation Install PostgreSQL $ sudo apt-get install postgresql postgresql-client postgresql-contrib pgadmin3 ...
0
votes
0answers
28 views

PostgreSQL DB size increasing after restoring the same database backup

This is my batch script to take backup @ECHO OFF d: cd Apps\RemedyStar 9.0 KREMCOS\bin\Debug\PG pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -b -v -f "C:\Documents and ...
0
votes
1answer
43 views

Using pg_dump when connecting via a service

I connect to my postgres server using psql "service=subscription". How do I use the service with pg_dump? I tried to do the following: pg_dump -h "service=subscription" > /home/fogest/dump.out ...
0
votes
0answers
48 views

psql doesn't allow to input cyrillic symbols

I have a server with postgresql 8.4 installed on it. But when I try to insert some data in russian, for example: UPDATE category set question = '[there should be russian symbols]' WHERE id = 1; ...
0
votes
1answer
24 views

flagstaff_subset is not empty error when using pg_upgrade

sudo -u postgres /usr/lib/postgresql/9.3/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.3/bin -d /data/postgres/9.1/main -D /data/postgres/9.3/main -o ' -c ...
0
votes
0answers
229 views

Tons of “invalid command \N” when restoring a dump

I'm following these instructions to upgrade postgres from 9.1 to 9.3: http://www.postgresql.org/docs/9.1/static/upgrading.html When I restore (Step 8), I get a ton of messages like this: ...
0
votes
1answer
627 views

postgres server fails to start, produces no log, how to to troubleshoot? [closed]

I'm starting up a postgres 9.3 instance on a ubuntu 12.04 server : ~# service postgresql start * The PostgreSQL server failed to start. Please check the log output. ...
1
vote
1answer
78 views

What is proper host in PGAdmin for accessing postgresql through firewall

Here is my situation. I have Postgresql installed on a Windows Server on a LAN. I have an IIS web server set up outside the lan. I want to connect to the postgresql database from the webserver. ...