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
0answers
8 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 ...
1
vote
0answers
10 views

Process of Upgrading PostgreSQL and Slony

I've been working on upgrading a cluster of Postgres servers from 9.2 to 9.3. I thought I would start with a slony upgrade(because it's necessary for PG version bump), but I'm lost. So; How close ...
0
votes
1answer
6 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
11 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
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
32 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
14 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
19 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
32 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
40 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
24 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
43 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
65 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
14 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
133 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
43 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
42 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
128 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
164 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
33 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
62 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
107 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
404 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
66 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
43 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
90 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
84 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
130 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
62 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
498 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
205 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
205 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
134 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
161 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
98 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
156 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
29 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
45 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; ...