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)

-2
votes
0answers
12 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
1answer
668 views

How to send task to celery using redis pubsub with postgresql?

How do you send task to celery through redis pubsub once a new record has been inserted into a postgresql table? My problem here is to get redis to listen for inserts in my postgresql table, and when ...
2
votes
1answer
661 views

pg_basebackup: could not get WAL end position from server

I want to create a Base Backup with the pg_basebackup tool of postgres 9.1. After some seconds I receive: `pg_basebackup: could not get WAL end position from server What can be the reason for this ...
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 ...
2
votes
1answer
261 views

PostgreSQL 7.4 => 8.1 migration: timezone issue

Okay, so I'm migrating Project Open to a new server (opensource project management system built on OpenACS which uses AOLServer) and ran into a very strange issue: importing a 7.4 dump automatically ...
2
votes
1answer
3k views

How to restart postgresql 8.4 on Debian Squeeze when there are no clusters defined?

How to restart postgresql 8.4 on Debian Squeeze? /etc/init.d/postgresql stop/start/restart does nothing (no output given).
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
18 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?
3
votes
0answers
52 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 ...
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: ...
0
votes
1answer
677 views

Error in osm data data import while nominatim installation

I am doing nominatim installation on my server. I run the following command ./utils/setup.php --osm-file /usr/share/osm2pgsql/planetfile/planet-latest.osm.pbf --all to import the pbf file and Few ...
1
vote
1answer
1k views

PostgreSQL pg_hba.conf with “password” auth wouldn't work with PHP pg_connect?

I've recently experimented with the settings in pg_hba.conf. I read the PostgreSQL documentation and I though that the "password" auth method is what I want. There are many people that have access to ...
1
vote
1answer
2k views

How do I fix issue causing “incomplete startup packet” log message trying to implement replication in Postgresql?

I've got two cloud servers running Ubuntu 13.04 and PostgreSQL 9.2. I've primarily used this blog post to aid me in setting things up. However, to do the initial database dump to the slave I'm using ...
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
2answers
1k views

How to make a JDBC connect to Crystal Reports with Postgres

I want to create a new report using Crystal Reports. I downloaded the Postgres driver but when I want to create the connection, it shows an error "JDBC Driver not found" How can I solve it? Thanks ...
0
votes
0answers
18 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
41 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 ...
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
68 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 ...
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
831 views

Postgres pgpass windows - not working

DB: Postgres 9.0 Client: Windows 7 Server Windows 2008, 64bit I'm trying to connect remotely to a postgres instance for purposes of performing a pg_dump to my local machine. Everything works from my ...
0
votes
1answer
3k views

CentOS6 and PostgreSQL-YUM, (Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg90. Please verify its path and try again)

I'm using CentOS 6. I need to configure my YUM to have access to the PostgreSQL repository, but I'm getting an error. I've followed this guide: ...
1
vote
1answer
30 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 ...
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 - ...
2
votes
1answer
1k views

pgpool2+streaming replication failover on only 2 servers?

I am trying to configure pgpool2 and postgresql 9.1 to handle failover. I currently have streaming replication running, and are using pgpool2 for read-only load balancing. I have 2 servers in my ...
1
vote
1answer
83 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 ...
0
votes
2answers
2k views

pgAdmin cannot connect to PostgreSQL 9.1

I am trying to use pgAdmin on Windows to connect to postgresql 9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432. pgAdmin Error: Error connecting to the ...
0
votes
2answers
673 views

Bash script to install PostgreSQL

I'm trying to write a bash script to install PostgreSQL server on a Debian 6 VPS. I keep wiping the server and I'm like to write something to auto-install it. #!/bin/bash export ...
1
vote
2answers
953 views

RoundCube login to local IMAP server failing

I've been following this guide to set up a mail server on my server: http://flurdy.com/docs/postfix/edition5.html The only difference is that this tutorial uses a MySQL database and I've used ...
1
vote
3answers
1k views

Cannot connect to postgres installed on Ubuntu

I installed the Bitnami Django stack which included PostgreSQL 8.4. When I run psql -U postgres I get the following error: psql: could not connect to server: No such file or directory Is the ...
0
votes
1answer
849 views

pg_restore is taking too long to finish. What could be the problem?

pg_restore is taking too long to finish. I already performed the following service postgresql initdb /etc/init.d/postgresql start Modified /var/lib/pgsql/data/pg_hba.conf to use local all ...
1
vote
1answer
101 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
2answers
1k views

I think I have multiple postgresql servers installed, how do I identify and delete the 'extra' ones?

I seem to have a few installations of postgresql on my machine somehow. I'm not sure if this is a mistake or, if Ubuntu for some odd reason duplicates direcotories and keeps them elsewhere. I have a ...
4
votes
2answers
1k views

Postgres application tries to use incorrect socket file

I have a local postgres server running (on ubuntu linux). It is listening via a socket file: $ ls -la /var/run/postgresql/ total 8 drwxrwsrwx 2 postgres postgres 100 2011-04-15 19:06 . drwxr-xr-x ...
2
votes
1answer
91 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
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 ...
0
votes
1answer
290 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 ...
5
votes
2answers
2k views

Unable to connect to Postgres on Vagrant Box - Connection refused?

First off, I'm new to Vagrant and Postgres. I created my Vagrant instance using http://files.vagrantup.com/lucid32.box without any trouble. I am able to run vagrant up and vagrant ssh without ...
88
votes
7answers
130k views

What's the default superuser username/password for postgres after a new install?

I have just installed postgres 8.4 on Ubuntu 9.10 and it has never asked me to create a superuser. Is there a default superuser and its password? If not, how do I create a new one?
2
votes
2answers
307 views

Identifying processes responsible for queries with client_port==-1 in pg_stat_activity

I'm trying to trace the source of postgres queries identified by a pid. Normally you can do this by finding the client_addr and client_port fields in the pg_stat_activity table. However, some entries ...
1
vote
2answers
1k views

Dependency issue installing PostGIS on CentOs 6.3

I am new to linux and is trying to install PostGIS2 after successfully installing PostgreSQL 9.1. The machine is running CentOS 6.3 and has cPanel installed. Problem: When I tried installing PostGIS ...
1
vote
2answers
321 views

Can't connect to Postgres in production

I'm trying to connect to my Postgres instance on a local IP, which I can connect to with no problem using the psql -h localhost command. However, which trying to run via rails, I get this: $ rails c ...