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
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
16 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
28 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
17 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
17 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
12 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
6 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
18 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
17 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
40 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
50 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
64 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
28 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
33 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
82 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
95 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
25 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
48 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
90 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
286 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
56 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
36 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
76 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
69 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
108 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
51 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
401 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
22 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
158 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
146 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
130 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
143 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
86 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
144 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
25 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
41 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
47 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
23 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
183 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
456 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
73 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. ...
0
votes
1answer
50 views

Install PostgreSQL under a system user other than “postgres”?

I need to run my current Postgresql 9.3 under a system user other than postgres, say admin OR I need to install Postgresql 9.3 with the default user as say admin on Ubuntu 12.04
0
votes
0answers
23 views

Postgresql upgrade between major versions without downtime

Is there any recommended way to upgrade between different postgresql versions (say, 9.2 to 9.3) without downtime?
0
votes
1answer
59 views

Postgresql not listening on the correct port using service command

In my /var/lib/pgsql9/data/postgresql.conf I added port = 55434 and if I start Postgres with /usr/bin/pg_ctl start -D /var/lib/pgsql9/data/ as the postgres user then Postgres is listening to the right ...
1
vote
1answer
135 views

RHEL SELinux blocking Apache access to PostgreSQL

I'm running a Django app that uses PostgreSQL. The server is running RHEL 6.5 with SELinux. I'm having an issue where the Django app can't connect to the DB, and I think it's because SELinux is ...